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: remote / as sysdba

Re: remote / as sysdba

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Thu, 06 Mar 2003 12:33:51 -0800
Message-ID: <F001.005626DB.20030306123351@fatcity.com>


Hi Bill,

My wife is from Marshfield, so I'll help you!

The documentation you want to look at starts at:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1167

Basically I think you need to create a paswordfile using orapwd and set the REMOTE_LOGIN_PASSWORDFILE parameter.

HTH,

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 6 Mar 2003, becker.bill_at_marshfieldclinic.org wrote:


> env: Oracle 9.2.0.2 on Solaris 9.
>
> Does anyone know of a way to use the "/ as sysdba" logon remotely?
> (to a separate Oracle instance on a separate machine)
>
> Other remote user logons work OK.
>
> I have tried several variations from sqlplus, such as
>
> BECKERB_at_DWS>connect /@DWQ as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> BECKERB_at_DWS>connect sys/sys_password_at_DWQ as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> BECKERB_at_DWS>connect sys/exr_sys as sysdba_at_DWQ
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
> where <logon> ::= <username>[/<password>][@<connect_string>] | /
>
> BECKERB_at_DWS>connect sys/sys_password_at_DWQ
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> I also find I cannot even "connect sys/syspassword" locally:
>
> BECKERB_at_DWS>connect sys/sys_password
> ERROR:
> ORA-28009: connection to sys should be as sysdba or sysoper
>
> This does work locally, but not remotely:
>
> BECKERB_at_DWS>connect sys/sys_password as sysdba
> Connected.
>
> I am a member of the dba group on both platforms.
>
> I have verified that I am using the correct sys_password for sys
> on the remote instance.
>
> Eventually, I want to do a remote transportable tablespace import, where
> the userid would be listed in a parfile; I have tried the same logons in
> a parfile, and that also fails.
>
> I found a Metalink doc that says the O7_DICTIONARY_ACCESSIBILITY (sp?)
> must be true to do this, but the same doc strongly advises against setting
> this to true.
>
> So, has anyone found a way to use the "/ as sysdba" logon remotely?
> (without setting the O7 parameter to true)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: jwilton_at_speakeasy.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 Thu Mar 06 2003 - 14:33:51 CST

Original text of this message

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