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: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 09 Apr 2003 12:23:51 -0800
Message-ID: <F001.0057E666.20030409122351@fatcity.com>


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

Original text of this message

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