| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to connect to remote database as sys/sysdba
You are forgetting double-quotes around sys/password_at_rem_prod, should be:
$sqlplus "sys/password_at_rem_prod as sysdba"
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
Hi Allesandro,
Tried that, before posting the question. Unfortunately, didn't work.
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
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).
>>
>>
>
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: Igor Neyman INET: ineyman_at_perceptron.com 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:48:40 CDT
 |
 |