+ Reply to Thread
Results 1 to 3 of 3

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Question Personal Oracle 9i Login??

    I installed oracle 9i personal edition on my computer at home and I have a question about logging into oracle from the DOS prompt. I know that svrmgrl is not around anymore and sqlplus internal isn't there. When I log into sqlplus /nolog it asks me for a user name and password. I want to be able to just look around as oracle. Not at any particular database. I want to create a database with a notepad file or start and stop the listener. How do I log in??? Thanks for you help.

  2. #2
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    If you have os_authentication i.e. member of ORA_DBA user group, you may log on with:

    connect / as sysdba

    or

    connect sys a sysdba


    Brgds,

    Andy

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    thanks

    Thanks for your help

Bookmarks

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