Bill, You can't do that. If you try to, you will eventually see ORA-1997
12:18:58 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL> grant sysdba to ops$jkstill; grant sysdba to ops$jkstill * ERROR at line 1: ORA-01997: GRANT failed: user 'OPS$JKSTILL' is identified externally 12:19:07 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL> You can create a remote user that can logon as sysdba remotely, but that user must have a password. See MetaLink Doc # 185703.1 Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/06/2003 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: remote / as sysdba Hello, 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 [EMAIL PROTECTED]>connect /@DWQ as sysdba ERROR: ORA-01031: insufficient privileges Warning: You are no longer connected to ORACLE. [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] as sysdba ERROR: ORA-01017: invalid username/password; logon denied [EMAIL PROTECTED]>connect sys/exr_sys as [EMAIL PROTECTED] SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_string>] | / [EMAIL PROTECTED]>connect sys/[EMAIL PROTECTED] ERROR: ORA-28009: connection to sys should be as sysdba or sysoper I also find I cannot even "connect sys/syspassword" locally: [EMAIL PROTECTED]>connect sys/sys_password ERROR: ORA-28009: connection to sys should be as sysdba or sysoper This does work locally, but not remotely: [EMAIL PROTECTED]>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) Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).