Regarding Tnsnames [message #321717] |
Wed, 21 May 2008 02:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|