| database link is not working on 3rd party tools [message #350659] |
Thu, 25 September 2008 18:21  |
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 #350955 is a reply to message #350953] |
Sun, 28 September 2008 03:38  |
 |
Littlefoot
Messages: 21823
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
