Home » RDBMS Server » Networking and Gateways » ERROR 12560 TNS : Protocol adapter error ::::::Newbie
ERROR 12560 TNS : Protocol adapter error ::::::Newbie [message #66452] Mon, 17 June 2002 04:23 Go to next message
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..
Re: ERROR 12560 TNS : Protocol adapter error ::::::Newbie [message #66453 is a reply to message #66452] Mon, 17 June 2002 08:24 Go to previous messageGo to next message
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.
Re: ERROR 12560 TNS : Protocol adapter error ::::::Newbie [message #66556 is a reply to message #66452] Tue, 30 July 2002 02:30 Go to previous messageGo to next message
POOJA MATHUR
Messages: 3
Registered: July 2002
Junior Member
you have to write the database name in the column which is asking for service name ,contact your DBA for futher suggestions.
Re: ERROR 12560 TNS : Protocol adapter error ::::::Newbie [message #66596 is a reply to message #66452] Wed, 21 August 2002 13:56 Go to previous message
Hermawan
Messages: 2
Registered: August 2002
Junior Member
Hi,
I have the same problem...
I am using Win 98 SE with Oracle 8.1.7
Is there anybody can help?
Previous Topic: login/connection problem
Next Topic: Problem connecting Win2K (oracle 9i) client to 8.0.5 database
Goto Forum:
  


Current Time: Wed Feb 28 04:38:17 CST 2024