... and it's even more fun if you need to run
utilities as sys - you also might need to add single
quotes to the mix as in:
$imp "'sys/password_at_rem_prod as sysdba'"
- Igor Neyman <ineyman_at_perceptron.com> wrote: > 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
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, April 09, 2003 3:03 PM
>
>
> 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: 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).
>
Post your free ad now!
http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: boris_dali_at_yahoo.ca
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 - 15:53:55 CDT