-
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]
Best wishes!
Dmitri
-
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.
Best wishes!
Dmitri
-
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
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
Best wishes!
Dmitri
-
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 " ".
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|