OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Regarding Tnsnames (Windows Xp, Oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regarding Tnsnames [message #321717]

Wed, 21 May 2008 02:24

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

Report message to a moderator