Re: How do you connect sys as sysdba in sqlplus
Date: Mon, 12 Nov 2001 23:37:27 +0100
Message-ID: <tv0ojsnpqfs4eb_at_corp.supernews.com>
"Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.1005601653.1552734375_at_[64.94.198.252]...
> 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>][_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
It is in the error message you got
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
> where <logon> ::= <username>[/<password>][_at_<connect_string>] | /
means
connect sys/<password>_at_servicename as sysdba
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Mon Nov 12 2001 - 23:37:27 CET