Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: How do you connect sys as sysdba in sqlplus

Re: Help: How do you connect sys as sysdba in sqlplus

From: Steve <smontgomerie_at_hotmail.com>
Date: 13 Nov 2001 13:26:35 -0800
Message-ID: <156709aa.0111131326.79f48507@posting.google.com>


try sqlplus "/as sysdba" , remember that the OS user must be a meneber of the ORA_DBA or DBA group

Steve

"Marty Grinstead" <marty_grinstead_at_hotmail.com> wrote in message news:<phZH7.555$OP1.373570_at_newsrump.sjc.telocity.net>...
> Hey Mike,
>
> You cannot make a local connection (connect without using @alias) on a
> client machine. You need a tnsnames.ora file (or OID, names server, etc)
> that provides a connect string to your database. So then, if you created an
> alias of orcl.world, you could:
>
> C:/> sqlplus /nolog
> SQL> connect sys/password_at_orcl.world as sysdba
>
> Marty
>
>
> Mike F <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
> news:l.1005601653.1552734375@[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>][@<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 Tue Nov 13 2001 - 15:26:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US