Help: How do you connect sys as sysdba in sqlplus

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Mon, 12 Nov 2001 21:47:33 GMT
Message-ID: <l.1005601653.1552734375_at_[64.94.198.252]>

[Quoted] [Quoted] 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.
[Quoted] Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL] where <logon> ::= <username>[/<password>][_at_<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/new

Received on Mon Nov 12 2001 - 22:47:33 CET