Create DataBase Error,Help me
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Create DataBase Error,Help me

  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Unhappy

    I have a database,now i want to create another database .
    i login svrmgr as internal.when i do with the create database command,system show error as below:
    CREATE DATABASE failed
    error while processing file '?/rdbms/admin/sql.bsq' near line 1425
    error occurred at recursive SQL level 2
    user requested cancel of current operation

    i am so worry about it ,anyone can helpme.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    When you enter svrmgl, is your window set for the new database, or are you still trying to do create database against the database you are logged in against (which, of course, has already been created)?

  3. #3
    Join Date
    Mar 2002
    Posts
    24
    If you want create a new database in windows , first of all u need to create a service using oradim utility...

    After that .. set the ORACLE_SID= and
    run the svrmgrl command...


    Otherwise if you want to create a new database in unix ,

    Just set the ORACLE_SID= and pfile ..
    And run the svrmgrl and create the database.

    thats it!!!

    Happy DBAing....



    G.Laxman
    Oracle DBA

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    just use dbassist GUI Interface ( UNIX) to create a Database .
    then continue creating the database or save it to a shell script and execute later.

    siva prakash
    DBA

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