DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 17

Thread: cannot connect as sys

Threaded View

  1. #14
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by diwakar
    The problem that I need to get through with now is to connect as SYS-DBA. .....
    ...The problem is to connect to the desired database as SYS user as- sysdba.

    ...the database is up and connecting to the desired database as sys as sysdba is one of the proiblems.
    Go to the box where your database is running and do the following after invoking sql*plus ...
    Code:
    TST: SYS> conn / as sysdba 
    Connected.
    TST: SYS>

    Red Hat Linux release 6.2 (Zoot)
    Kernel 2.2.14-5.0 on an i686
    login: oracle
    Password:
    Last login: Wed Mar 19 09:32:53 from sun101.ctg.siptech.co.in
    sql[oracle@eagle oracle]$ sqlplus

    SQL*Plus: Release 8.1.7.0.0 - Production on Thu Mar 20 10:32:30 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.1 - Production

    SQL>
    HTH.
    Last edited by ggnanaraj; 03-20-2003 at 01:37 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width