| configuring listener [message #184194] |
Tue, 25 July 2006 12:32  |
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 #184196 is a reply to message #184194] |
Tue, 25 July 2006 12:35  |
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 |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
