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 10:38:39 -0800
Message-ID: <F001.0057E2D6.20030409103839@fatcity.com>


Try

sqlplus "sys/password_at_Remote_db as sysdba"

Alessandro Guimaraes

> 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).
>
>

-- 
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 - 13:38:39 CDT

Original text of this message

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