TNSNames or SQLNet or Listener

[st2000]

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

[stecal]

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

[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.

[abhaysk]

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.

[st2000]

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