Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help: How do you connect sys as sysdba in sqlplus
We have a 9i on linux which we need to connect sys as sysdba in sqlplus
on windows, but when I started the Sqlplus dialog window and enter
sys as sysdba, or I started at DOS window and enter
C:/> sqlplus /nolog
SQL> connect sys as sysdba
Enter Password:
ERROR:
ORA-12560: TNS:protocol adapter error
If I do
SQL> conn sys/manager as {sysdba}
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
SQL> connect internal
ERROR:
ORA-24314: service handle not initialized
The init.ora has the remote_login_passwordfile=EXCLUSIVE could somebody tell me how can I connect remotely using 'sys as sysdba'?
Thanks for your help
We are using sqlplus 8.1.7.0.0
-- Sent by dbadba62 from hotmail piece from com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Mon Nov 12 2001 - 15:47:33 CST
![]() |
![]() |