Oracle-L: RE: How to connect to remote database as sys/sysdba

From: <CSP2201_at_netscape.net>
Date: Wed, 09 Apr 2003 11:14:25 -0800
Message-ID: <F001.0057E44D.20030409111425@fatcity.com>

Hi Rick,

Thanks for your help! It worked. I didn't try with the " at the beginning and ending of the connection information.

Your help did save my time.

Thanks again for your help!
CP

"Weiss, Rick" <rweiss_at_state.mt.us> wrote:

>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).
>
>

Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: CSP2201_at_netscape.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 Wed Apr 09 2003 - 14:14:25 CDT