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

From: <CSP2201_at_netscape.net>
Date: Wed, 09 Apr 2003 11:03:40 -0800
Message-ID: <F001.0057E3CA.20030409110340@fatcity.com>

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

Received on Wed Apr 09 2003 - 14:03:40 CDT