OraFAQ Forum: Networking and Gateways » ERROR 12560 TNS : Protocol adapter error ::::::Newbie

Home » RDBMS Server » Networking and Gateways » ERROR 12560 TNS : Protocol adapter error ::::::Newbie

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

ERROR 12560 TNS : Protocol adapter error ::::::Newbie [message #66452]

Mon, 17 June 2002 04:23

Sandeep Pathak
Messages: 3
Registered: March 2002

Junior Member

hi, i have a great problem. since i am a newbie , i need help..

whenever i try to start SQL*PLUS in oracle 8i on win98, i am asked for the username and passwd, which i enter as scott & Yiger. but i don't know what to fill for the SERVICE NAME ??? thus i keep getting
TNS protocol adapter error
if a fill in a fictious service name and
TNS address name could not be resolved
if i do not give a name. I want to run my machine as a standalone database , how can i do it???

please help me out..

Report message to a moderator

Re: ERROR 12560 TNS : Protocol adapter error ::::::Newbie [message #66453 is a reply to message #66452]

Mon, 17 June 2002 08:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if your database is installed in the loacl machine, or happens to be a personal edition you no need to give host_string.
the solution is create an entry in tnsnames.ora file.
tnsnames. ora can be found at $ORACLE_HOMEnetworkadmin.

HIGH9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = high9i)
)
)
where high9i=hoststring
i have used the hostring same as database name.
host = ur machine name /IP (for a remote database)
= IP/LOCALHOST ( FOR A LOCAL DATABASE).

I WOULD CONNECT TO THIS database like
mag/mag@high9i.

Report message to a moderator