Problems Installing SQL PLUS

[sabelsoftware]

Dear All
I am trying to install SQL plus but I cant login can anyone help?

I'll guide you through the installation

>I chose to intsall Oracle9i database 9.2.0.1.0 >I then chose the Standard edition >I chose software only as I have only 128MB of RAM my port number is 2030 for Oracle Services for Mircrosoft Transaction Server

then I am informed oracle9i database was succesful

Here is the confusing bit

I try to add a database manually to the tree

hostname is abol Port number is 1521 SID test net service name is test_abol

I load SQL plus enter the username SYS and I chnaged the password

I am presented with USERNAME ,password and Host string

I have tryed typing all the diff port numbers and abol and test and i get an error stating:

Error: ORA-12560: TNSrotocol adapter error

what does this mean i how can i solve the problem so i can start using SQL plus

 

[JtheRipper]

Hi,

Have you checked if the listener is started on the database server?

Also, check in the tnsnames.ora file on the client pc if the entry for your database if correct. You can also try to change the port no to 1526 just to see if it has any effect. What is your db_domain parameter? If it is i.e. ".world", use abol.world in your tnsnames.ora file.

 

[SantaMufasa]

Sabel,

Usually, when your receive "Error: ORA-12560: TNSrotocol adapter error", it is from an incorrect setting for an environment variable, ORACLE_HOME (and possibly ORACLE_SID). As a temporary fix and to troubleshoot the problem, issue the following commands from your shell/window that you use for your SQL*Plus command:

set ORACLE_HOME=d:\Oracle\Ora92 (if this is your ORACLE_HOME)
set ORACLE_SID=<your_SID>
sqlplusw

Hopefully, that puts you into sqlplus without the protocol adapter error.

Let us know,

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:37 (27Nov03) GMT, 10:37 (27Nov03) Mountain Time)