Home » Infrastructure » Windows » ORA 12154 from other machine (Oracle 11 R2, Windows 2008)
ORA 12154 from other machine [message #494455] Mon, 14 February 2011 19:39 Go to next message
narsana_m
Messages: 3
Registered: February 2011
Location: Singapore
Junior Member
I have Oracle installed on a Windows 2008 server. When the database was created, it could not register with the listener (I confirmed that the listener service was running but when I started creating the database it stopped).
I completed the db creation and started the listener again and tried "alter system register" but that didn't work either.
Then I manually edited listener.ora and added an entry to the SID_LIST_LISTENER and I could successfully connect using
sqlplus dba1@orcl/password from the same server.

Now, I tried to use the instant client to connect to the database from another Windows 2008 server. I copied the TNSNames.ora from the db server to this new server.
When I run sqlplus dba1@orcl/password I get the ORA 12154 error.

Why would this happen from a remote machine which is on the same network? Ping from one server to the other works (both ways).
Any help would be greatly appreciated.

Re: ORA 12154 from other machine [message #494456 is a reply to message #494455] Mon, 14 February 2011 19:59 Go to previous messageGo to next message
BlackSwan
Messages: 26756
Registered: January 2009
Location: SoCal
Senior Member
>sqlplus dba1@orcl/password
incorrect syntax
sqlplus dba1/password@orcl

ORA-12154 means TNS_ALIAS (@orcl) could not be resolved; typically means not found in tnsnames.ora

If sqlnet.ora file exists on client, then post content of sqlnet.ora file.
Re: ORA 12154 from other machine [message #494457 is a reply to message #494456] Mon, 14 February 2011 20:04 Go to previous messageGo to next message
narsana_m
Messages: 3
Registered: February 2011
Location: Singapore
Junior Member
@BlackSwan
I copied the TNSNames.ora from the db server to the other server and confirmed that the entry is there and it looks like it works on the server. For now, I am using the Oracle 11g instant client to try to connect to the db.
There is no sqlnet.ora in the instant client folder. My plan is to try to install the full client now and try connecting.

Thanks.
Mitesh
Re: ORA 12154 from other machine [message #494458 is a reply to message #494457] Mon, 14 February 2011 20:08 Go to previous messageGo to next message
BlackSwan
Messages: 26756
Registered: January 2009
Location: SoCal
Senior Member
sqlplus user1/user1@'hostname:1521/orcl'

above works on newer version

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.
Re: ORA 12154 from other machine [message #494459 is a reply to message #494458] Mon, 14 February 2011 20:18 Go to previous messageGo to next message
narsana_m
Messages: 3
Registered: February 2011
Location: Singapore
Junior Member
Apologies for not following the guideline. The fact is, I am not onsite and am waiting for the contacts to show up in the lab so I can remote connect.
I will copy and paste the following as soon as possible:

LISTENER.ORA on the db server
TNSNAMES.ORA on the db server
output of sqlplus dba1/password@orcl on the dbserver
output of sqlplus dba1/password@orcl on the app server
output of sqlplus dba1/password@'hostname:1521/orcl' on the app server

Is there anything else that might help?
Re: ORA 12154 from other machine [message #494460 is a reply to message #494459] Mon, 14 February 2011 20:27 Go to previous message
BlackSwan
Messages: 26756
Registered: January 2009
Location: SoCal
Senior Member
>Now, I tried to use the instant client to connect to the database from another Windows 2008 server.
>I copied the TNSNames.ora from the db server to this new server.
>When I run sqlplus dba1@orcl/password I get the ORA 12154 error.
>Why would this happen from a remote machine which is on the same network?

Instant client is mis-configured; especially immediately after initial installation.

>output of sqlplus dba1/password@orcl on the dbserver
If/when above succeeds, then listener & DB are properly configured; to a major extent.
If when SQL*net works on DB Server & fails from remote client, then root cause is most likely on the client
Previous Topic: 11g service not starting automatically on Windows 7 Professional
Next Topic: stuck up while installing oracle 10g
Goto Forum:
  


Current Time: Sun Nov 29 17:16:22 CST 2020