Home » RDBMS Server » Networking and Gateways » Regarding Tnsnames (Windows Xp, Oracle9i)
Regarding Tnsnames [message #321717] Wed, 21 May 2008 02:24 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
hi,

I have installed oracle9i in windows xp OS.After instalation i connect the db but it shows a error
ORA-12154: TNS:could not resolve service name

My script:

sqlplus system/manager@mike;

error;
ORA-12154: TNS:could not resolve service name

but i connected the db throgh this query

sqlplus system/manager.

After that i proved mike is global db name through below steps

sqlplus sys as sysdba/password;

sql>select name from v$database;

mike

The tnsnames of mike is not present in tnsnames.ora file.
In tnsnames.ora file has only two tnsnames

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC0)
)
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = michael)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http)
)
)
mike tnsname is missing.

How can recover it?

Thanks,
Michael







Re: Regarding Tnsnames [message #321723 is a reply to message #321717] Wed, 21 May 2008 02:46 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can recover it?

Add the entry.
There are examples in the documentation and in $ORACLE_HOME/network/admin/sample directory.

Regards
Michel
Previous Topic: listener error
Next Topic: ora-12224
Goto Forum:
  


Current Time: Tue Dec 06 04:43:44 CST 2016

Total time taken to generate the page: 0.11334 seconds