Home » RDBMS Server » Server Administration » configuring listener
configuring listener [message #184194] Tue, 25 July 2006 12:32 Go to next message
nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa
Member

hello!

i'm new to oracle.

i set up an oracle instance and db.

but when i tried to sqlplus to the instance i got :

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


is this a problem with the listener?
Re: configuring listener [message #184195 is a reply to message #184194] Tue, 25 July 2006 12:34 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
No. the problems is that in file tnsnames.ora(client part) are not definiton for your database.
Re: configuring listener [message #184196 is a reply to message #184194] Tue, 25 July 2006 12:35 Go to previous messageGo to next message
nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa
Member

one more thing is the listener name :

ps -ef shows :

oracle 17885 1 0 11:41:18 ? 0:00 /apps/oracle/oracle/product/10.2.0/bin/tnslsnr LISTENER -inherit


but my listener.ora shows :

ENGDBA =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP) (HOST = host1) (PORT = 1521)
)
(ADDRESS =
(PROTOCOL = IPC) (KEY = ENGDBA)
)
)

SID_LIST_ENGDBA =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ENGDBA)
(ORACLE_HOME = /apps/oracle/oracle/product/10.2.0)
(SID_NAME = ENGDBA)
)
)


why doesn't ps -ef show the listener by its name ie ENGDBA instead of LISTENER?

appreciate the feedback.
Re: configuring listener [message #184198 is a reply to message #184194] Tue, 25 July 2006 12:40 Go to previous messageGo to next message
nandac
Messages: 41
Registered: July 2006
Location: jersey city, usa
Member

which is correct entry for tnsnames.ora :

1.
ORAGFBU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host>)(PORT = 1524))
)
(CONNECT_DATA =
(SERVICE_NAME = ORAGFBU)
)
)

or

2.
ENGDBA =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC) (KEY = ENGDBA)
)
(CONNECT_DATA =
(SERVICE_NAME = ENGDBA.<network>)
)
)

ENGDBATCP =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP) (HOST = <host>) (PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME = ENGDBA.<network>)
)
)
Re: configuring listener [message #184202 is a reply to message #184194] Tue, 25 July 2006 12:50 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
1)Why you think, that ps -ef must show listener name???
2)Setting for tnsnames.ora are very specifically for your network. If you have not experience by Net8, then try to use wizards for setting correct tnsnames.ora and sqlnet.ora.
Previous Topic: Change temp TBS to permanent TBS
Next Topic: moving the partitions
Goto Forum:
  


Current Time: Fri Dec 02 16:19:21 CST 2016

Total time taken to generate the page: 0.17618 seconds