Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

821043Aug 3 2011 — edited Aug 3 2011
I'm having a slight issue with Oracle 11 R2

Oracle 10g was removed from the machine - The registry was cleared and I couldn't see anything of 10g left.

I then installed Oracle 11 with just the software only, and then created a listener.

Using the Database Configuration Assistant, I tried to add a database but I get the error:
'ORA-12154: TNS:could not resolve the connect identifier specified'


The TNS_ADMIN is set to: \\ravel\tnsnames and I can connect to other instances around the company.

My tnsnames entry is:

GMAN_1120.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gman)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora112)
)
)


If i start the listener i get:

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to d:\oracle\diag\tnslsnr\gman\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gman)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date 03-AUG-2011 10:34:28
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File d:\oracle\diag\tnslsnr\gman\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gman)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora112" has 1 instance(s).
Instance "ora112", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>


Can anyone spot what may have gone wrong? I've setup 10g multiple times and never had a problem
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2011
Added on Aug 3 2011
19 comments
1,140 views