What does "didn't work" mean? What error message do you see?
What are the values of the "remote_login_passwordfile" database parameter?
What do you see in v$pwfile_users ?
Do you have a password file for the database?
> -----Original Message-----
> From: CSP2201_at_netscape.net [mailto:CSP2201_at_netscape.net]
>
> 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
> $
> --------------------------------------------------------------
> -------------
>
> Alessandro Guimarães <alessandro_at_applysolutions.com.br> wrote:
>
> >Try
> >
> >sqlplus "sys/password_at_Remote_db as sysdba"
> >
> >----- Original Message -----
> >>
> >> 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!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.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 - 15:23:51 CDT
