-
TNSNames or SQLNet or Listener
Hello Guys:
If I am connecting to a remote database unless I use the it will not connect. Can anyone please give me some clues..
On my local machine: tnsnames.ora
PCDW.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.242.27)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.242.27)(PORT = 1526))
)
(CONNECT_DATA =
(SID = pcdw)
)
)
SQLPLUS Session: (after removing the .world in tnsnames.ora)
SQL> connect pecdm/pecdm@pcdw
ERROR:
ORA-12154: TNS:could not resolve service name
Warning: You are no longer connected to ORACLE.
SQL> connect pecdm/pecdm@pcdw.world
Connected.
PCDW.world is a remote oracle 8i instance on an Win 2000 Adv Svr.
-----------
# SQLNET.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = prenhall.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-----------------------
# LISTENER.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unemana_nt)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = unemana_nt)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = bits)
(ORACLE_HOME = D:\Oracle\Ora8i)
(SID_NAME = bits)
)
)
------------------------------------
The above attached tnsnames.ora, sqlnet.ora and listener.ora are the files from the local database instance i have on..
Thx, ST2000
-
As you are using names.default_domain in sqlnet.ora, your tnsnames.ora listing for the SID you want must contain SID.NAMES.DEFAULT_DOMAIN instead of SID.
Instead of...
PCDW.world=
(DESCRIPTION =
(ADDRESS_LIST =
...
you need
PCDW.PRENHALL.COM=
(DESCRIPTION =
(ADDRESS_LIST =
...
because you have
# SQLNET.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = prenhall.com
-
Something is goofy here. Your listener is listening to instance 'bits' Your tnsnames should mention SID as bits.
Secondly, if your default domain is prenhall.com, GLOBAL_DBNAME in listner.ora should be bits.prenhall.com.
If you are able to connect to pecdm/pecdm@pcdw.world, you are connecting to something else, not the instance referred to by your listener.ora file.
Check your files again.
Last edited by kris109; 03-24-2003 at 04:59 PM.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
Originally posted by kris109
Something is goofy here. Your listener is listening to instance 'bits' Your tnsnames should mention SID as bits.
Secondly, if your default domain is prenhall.com, GLOBAL_DBNAME in listner.ora should be bits.prenhall.com.
If you are able to connect to pecdm/pecdm@pcdw.world, you are connecting to something else, not the instance referred to by your listener.ora file.
Check your files again.
Kris:
Jus see wat St2000 has posted...
Hello Guys:
If I am connecting to a remote database unless I use the it will not connect. Can anyone please give me some clues..
..
..
..
The above attached tnsnames.ora, sqlnet.ora and listener.ora are the files from the local database instance i have on..
He is connecting to remote DB...and he says hez posting Local DB listener....which dosent make sense...
Wat Stecal said is absolutely correct....
Either make
NAMES.DEFAULT_DOMAIN = world
or change in TNS names file as suggested by stecal...
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Thanks for all the input guys..
The db_links and global_name were different. Once we updated the global_name to xxx.world, it got solved..
Thanks, ST2000
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|