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

Thread: DB Creation problem

  1. #1
    Join Date
    Oct 2001
    Location
    India
    Posts
    36
    Hi Friends,

    I have a problem in DB Creation thru script.

    We have installed oracle in NT environment with the default database. We want to create one more database. so first we created init.ora file. After that we have changed relevant parameters in init file. After setting ORACLE_SID to new sid and ORACLE_HOME as environment varibles. When we are trying to execute svrmgrl then it is saying tns : protocol adaptor error. Can any one suggest what may be the problem. And we also we modified the tnsnames and listner files.


    Thanks in advance.


  2. #2
    Join Date
    Dec 2000
    Posts
    255
    How are you creating database .. Have you used ORADIM utility?

    Amol

  3. #3
    Join Date
    Oct 2001
    Location
    India
    Posts
    36

    db creation

    Dear friend,

    I running this script

    create database VEN
    controlfile reuse
    datafile 'd:\ora81\oradata\ven\systemven.ora' size 10m
    logfile 'd:\\ora81\oradata\ven\log1ven.ora' size 50k,
    'd:\\ora81\oradata\ven\log2ven.ora' size 50k
    maxlogmembers 2


    This is to create a sample database. I am doing this thru svrmgrl prompt.

    Thanks

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Have you defined your ORACLE_SID in the command prompt?

    set ORACLE_SID=VEN

    svrmgrl and then execute again your database creation command.

    Hope that helps

    Angel


  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    even you fix that error your script is not 100% correct

    logfile 'd:\\ora81\oradata\ven\log1ven.ora' size 50k,
    'd:\\ora81\oradata\ven\log2ven.ora' size 50k

    these two has extra backslah \

    how have you defined your enviroment variables? from ms-dos or from control panel?

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

  7. #7
    Join Date
    Oct 2001
    Location
    India
    Posts
    36
    Thank u friends,

    It was solved like this.

    I have registered the SID via
    ORADIM -NEW -SID VEN

    after this it has gone thru success full.


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