Home » RDBMS Server » Networking and Gateways » database link is not working on 3rd party tools (oracle 10.2.0.3 solaris 10)
database link is not working on 3rd party tools [message #350659] Thu, 25 September 2008 18:21 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
EXPERTS,

i am getting one problem with database link. i have 2 instances TST ans STG. i have created database link in TST. when i trying to access STG objects from TST i am getting results.

when i am trying to access same db link in sql*plus client tool, i am getting following error.
SQL> select * from v$database@BBTST_BBSTG;
select * from v$database@BBTST_BBSTG
                         *
ERROR at line 1:
ORA-12541: TNS:no listener
==========================================

FROM SECURE SHELL
BBTST:TEST> SELECT NAME FROM  V$DATABASE@BBTST_BBSTG;

Thu Sep 25                                                            page    1
                              Instance Parameters

NAME
-----------------------------------------
BBSTG
BBTST:TEST> 


i am not able to understand what could the problem. can any one help me to fix this issue
Re: database link is not working on 3rd party tools [message #350953 is a reply to message #350659] Sun, 28 September 2008 03:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check Listner Services is started?
Re: database link is not working on 3rd party tools [message #350955 is a reply to message #350953] Sun, 28 September 2008 03:38 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not that I can help at the moment, but: you've said that
Quote:
when i am trying to access same db link in sql*plus client tool, i am getting following error.
At the same time, topic title is
Quote:
database link is not working on 3rd party tools

For your information, SQL*Plus is not a third party software here (as - regarding to Wikipedia - third party software component is a reusable software component developed to be either freely distributed or sold by an entity other than the original vendor of the development platform).
Previous Topic: NIC Agents: NIC Connectivity Lost
Next Topic: ora-12540 TNS internal limit restriction exceeded
Goto Forum:
  


Current Time: Thu Mar 28 05:02:28 CDT 2024