| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to connect to remote database as sys/sysdba
Cp:
On a W2000 client to a remote W2000 database:
I opened a DOS window:
C:> SQLPLUS
Enter user-name: SYS/SYSPW_at_TEST AS SYSDBA
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> OR
C:> SQLPLUS "SYS/SYSPW_at_TEST AS SYSDBA"
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Either of these worked for me
Rick Weiss
Oracle DBA
Helena, MT USA
-----Original Message-----
Sent: Wednesday, April 09, 2003 11:59
To: Multiple recipients of list ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Weiss, Rick
INET: rweiss_at_state.mt.us
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 - 13:33:51 CDT
 |
 |