Home » Infrastructure » Windows » Error of TNS protocol Adapter
icon14.gif  Error of TNS protocol Adapter [message #122168] Fri, 03 June 2005 09:04 Go to next message
hsperhar
Messages: 2
Registered: June 2005
Location: Chandigarh
Junior Member
In my system Oracle 9i is installed but it is giving the below mentioned error ,while I login through even normal & most commenly used username/password=scott/tiger in SQL *Plus.

ERROR:
ORA-12560: TNS:protocol adapter error

Please help me in the same.
Re: Error of TNS protocol Adapter [message #122204 is a reply to message #122168] Fri, 03 June 2005 15:02 Go to previous messageGo to next message
ender
Messages: 14
Registered: May 2005
Junior Member
Make sure your oracle server and your listener service are started.
Re: Error of TNS protocol Adapter [message #122225 is a reply to message #122204] Fri, 03 June 2005 23:31 Go to previous messageGo to next message
hsperhar
Messages: 2
Registered: June 2005
Location: Chandigarh
Junior Member
Thanks For reply, but to do so what should I do ,please advice me the procedure to run my Oracle9i on my system. If i Start Apache Server also it is also end up with error:

Access is denied:FastCGI:CreateMutex() failed
Systex error on line 92 of ..//sqlplus/admin/isqlplus.conf: Failed to create FastCGI application accept mutex

Please help me & advice me for doing the needful for runing the Oracle sucessfully.
Re: Error of TNS protocol Adapter [message #122277 is a reply to message #122225] Sat, 04 June 2005 15:01 Go to previous message
ender
Messages: 14
Registered: May 2005
Junior Member
Make sure the file isqlplus can be found at : PathToOracle9iHome\bin\isqlplus and that you have permission to access it. If you cannot find it you will probably have to reinstall Oracle.

However, if you only want to connect to the database locally you needn't worry about the server. All you have to do is start the listener service. Cool That means running :
PathToOracle9iHome\bin\TNSLSNR.EXE
and
PathToOracle9iHome\bin\oracle.exe -DatabaseName

PathToOracle9iHome is the directory where you installed Oracle 9i and DatabaseName is the name of the database you created.

[Updated on: Sat, 04 June 2005 15:08]

Report message to a moderator

Previous Topic: Oracle Lite 10g installation
Next Topic: Problem installing Oracle9i Database 9.2.0.1 on XP Professional SP2
Goto Forum:
  


Current Time: Fri Nov 22 06:59:51 CST 2024