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: <CSP2201_at_netscape.net>
Date: Wed, 09 Apr 2003 11:03:42 -0800
Message-ID: <F001.0057E3FE.20030409110342@fatcity.com>


Hi Allessandro,

I am sorry, I missed the - " before the after the connection information. It works.

Thanks a lot for your help!
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).
Received on Wed Apr 09 2003 - 14:03:42 CDT

Original text of this message

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