Error when trying to create 9i database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Error when trying to create 9i database

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    Hi ,

    I'm trying to create a 9i database. I've created the instance using the oradim utility.

    then I connect to sql using sqlplus /nolog

    when I try to do connect / as sysdba or
    connect sys/passwd@dbname as sysdba, it gives me an error either saying service handle not initialised or invalid username/password.

    Can you please let me know where I'm going wrong.
    This is oracle9.0.1.3 on win2000.

    thanks a lot
    pst

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Firstly start the service in the control panel.

    Cheers

    Angel

  3. #3
    Join Date
    Sep 2000
    Posts
    103
    I've already started the service in control panel. But when I try to do conn / as sysdba, it stops the started service.

    thanks a lot

    pst

  4. #4
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Try to connect like this:
    connect /@dbname as sysdba
    "Greatest Rewards come only with Greatest Commitments!"

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