Printable View
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]
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.
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.
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
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.Quote:
Originally posted by aarroyob
In 8.1.7 svrmgrl is not available. You must use sqlplus:
Thanks for the correction Jurij, I didn't know. I'm new in this forum and I didn't read.
Best regards
Angel Arroyo
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.
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.
Did you try sqlplus "sys/change_on_install@sid as sysdba" ?
Try it with " ".
Sounds like your DB server is not properly configured.Quote:
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.
I have Oracle Client from previous installation, I change Oracle home to my current one.
Quote:
Originally posted by 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.
I don't have an NT box to work on.
But as far as I can remember, try this:
invoke regedt32
export /* save your current registry settings to a file for backup*/
search for HOME0 or HOME1 /*alter the value of this field to be uniform with your current oracle home*/
if there is ORACLE_SID or SERVICE_NAME /*alter it make it uniform to your current ORACLE installation*/
Then try again.
Yes, some problems with Listener it does not started just it ask me to wair forever ...
... NO listener ... in this case
Thank you.
Quote:
Originally posted by aarroyob
Did you try sqlplus "sys/change_on_install@sid as sysdba" ?
Try it with " ".
Ooops... sounds like your listener was just listener to other database, overlooked :-)
NO, I checked IP address.
Thank you!
Quote:
Originally posted by reydp
Ooops... sounds like your listener was just listener to other database, overlooked :-)
Thanks guys !!!
It works now fine!
So could you please enlighten us on your solution?
Sam
Solution is:
I reinsatll Oracle Server 3 times, after that I was able to start listener. I still getting error 'Protocol adapter error' when I am tring to connect to Server using svrmgrl, but I can connect and create database without problems using SQLPLUS and connect line:
sqlplus "sys/change_on_install@sid as sysdba"
Others methods does not work in my case.
Thank you!
Quote:
Originally posted by sambavan
So could you please enlighten us on your solution?
Sam
Is this the only install that you have on the system or do you also have other versions of oracle? One of the possible causes of your earlier poblems could be that your oraInventory could have been corrupted.
-Sam