Protocol Adapter Error?

[kgb]

Hi, guys!
I am trying to install Oracle 8.1.7 on WinNT 4 as Administrator, during database creation using DB assist., I am getting error 12560:TNS : protocol adapter error.
Does anyone have edias how to fix it?
The same error message I get when connect to svrmgrl
Thank you very much.

[Edited by kgb on 11-05-2001 at 01:25 PM]

[gd_1976]

Issue the command
SET oracle_sid=yourservice_name
in ur dos prompt.
TNS Protocl adapter error is mostly due to the service name.
IT should work once you sset the Oracle_sid

Thanks.
GD_1976.

[kgb]

I created ORACLE service using command line
oradim -new -sid trax51 -intpwd oracle -startmode AUTO -pfile=E:\orant\admin\inittrax51.ora

I used:
SET ORACLE_SID=trax51
in command line, but when I am trying to start svrmgrl, I am getting error:
ORA-12560:TNS: protocol adapter error

Any ideas would be very appreciated.
Thank you.

[aarroyob]

Hi,

In 8.1.7 svrmgrl is not available. You must use sqlplus:

sqlplus sys/password@sid as sysdba

If doesn't work try with another this:

sqlplus "sys/password@sid as sysdba"

The last i use with some remote applications because it doesn't work i don't know why (was Oracle directly who recommended to use).

Hope this helps

[jmodic]

Originally posted by aarroyob
In 8.1.7 svrmgrl is not available. You must use sqlplus:

As it was stated a couple of times recently in this forum: SVRMGRL *is* available and fully supported in 8.1.7. You can use SQL*Plus for managing the database, but you still can use svrmgrl also.

[aarroyob]

Thanks for the correction Jurij, I didn't know. I'm new in this forum and I didn't read.

Best regards

Angel Arroyo

[kgb]

I was trying to use sqlplus
sqlplus /nologing
> connect internal as sysdba
ERROR:
ORA-24314:service handle not initialized
-------

sqlplus /nologing
> connect sys/change_on_install as sysdba
ERROR:
ORA-12560:service handle not initialized
-------
sqlplus /nologing
> connect internal/oracle as sysdba
ERROR:
ORA-01017:invalid username/password
-------


Thank you.

[reydp]

if you have set the ORACLE_SID ok, and your tnsnames is ok, then maybe there was a previous installation of ORACLE in your server and that you may need to edit some registry entry like oracle home, or oracle SID i'm not so sure.

[aarroyob]

Did you try sqlplus "sys/change_on_install@sid as sysdba" ?

Try it with " ".

[julian]

Originally posted by kgb
I was trying to use sqlplus
sqlplus /nologing
> connect internal as sysdba
ERROR:
ORA-24314:service handle not initialized
-------

sqlplus /nologing
> connect sys/change_on_install as sysdba
ERROR:
ORA-12560:service handle not initialized
-------
sqlplus /nologing
> connect internal/oracle as sysdba
ERROR:
ORA-01017:invalid username/password
-------


Thank you.

Sounds like your DB server is not properly configured.