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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to connect to remote database as sys/sysdba

Re: How to connect to remote database as sys/sysdba

From: Alessandro Guimar„es <alessandro_at_applysolutions.com.br>
Date: Wed, 09 Apr 2003 11:54:21 -0800
Message-ID: <F001.0057E5CA.20030409115421@fatcity.com>


Hi CP,

note the double quotes :)
sqlplus "sys/password_at_Remote_db as sysdba"

[]'s
Alessandro Guimaraes

> Hi Allesandro,
>
> Tried that, before posting the question. Unfortunately, didn't work.
>
> --------------------------------------------------------------------------
> $sqlplus sys/password_at_rem_prod as sysdba
> Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
> where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
> <logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
> <start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
> "-H" displays the SQL*Plus version banner and usage syntax
> "-V" displays the SQL*Plus version banner
> "-L" attempts log on just once
> "-M <o>" uses HTML markup options <o>
> "-R <n>" uses restricted mode <n>
> "-S" uses silent mode
> $
> ---------------------------------------------------------------------------
> Thanks
> CP
>
>
> Alessandro Guimar„es <alessandro_at_applysolutions.com.br> wrote:
>
> >Try
> >
> >sqlplus "sys/password_at_Remote_db as sysdba"
> >
> >Alessandro Guimaraes
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> >Sent: Wednesday, April 09, 2003 10:58 AM
> >
> >
> >> Hi Gurus,
> >>
> >> I am having trouble getting connected as sys to a remote database. In Oracle8i, I used use the following:
> >>
> >> sqlplus sys/password_at_Remote_db
> >>
> >> With Oracle9i, I have to login using "as sysdba" or "as sysoper". Tried with various combinations (placing the word "as sysdba"), but didn't work. Please help!
> >>
> >> Thanks
> >> CP
> >>
> >>
> >> __________________________________________________________________
> >> Try AOL and get 1045 hours FREE for 45 days!
> >> http://free.aol.com/tryaolfree/index.adp?375380
> >>
> >> Get AOL Instant Messenger 5.1 for FREE! Download Now!
> >> http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >> --
> >> Author:
> >> INET: CSP2201_at_netscape.net
> >>
> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >> San Diego, California -- Mailing list and web hosting services
> >> ---------------------------------------------------------------------
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from). You may
> >> also send the HELP command for other information (like subscribing).
> >>
> >>
> >
>
> __________________________________________________________________
> Try AOL and get 1045 hours FREE for 45 days!
> http://free.aol.com/tryaolfree/index.adp?375380
>
> Get AOL Instant Messenger 5.1 for FREE! Download Now!
> http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: CSP2201_at_netscape.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?Q?Alessandro_Guimar=E3es?=
  INET: alessandro_at_applysolutions.com.br

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Apr 09 2003 - 14:54:21 CDT

Original text of this message

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