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

Thread: Create Database

  1. #1
    Join Date
    May 2003
    Location
    canada
    Posts
    1

    Create Database

    Creating Database..

    1..Unique instance name that i have like "ansi74"

    2.c:\>set ORACLE_SID=ansi74

    3. Copy init.ora file and rename that with initANSI74.ora
    location:c:\oracle\ora81\database\initANSI74.ora
    contents of this file: IFILE=c:\init.ora

    4.Paaword File creation.

    c:\orapwd file=c:\oracle\ora81\database\PWDansi74.ora password=singh entries=5

    5.start instance

    >> connect sys as sysdba
    >> startup nomount pfile=c:\oracle\ora81database\initANSI74.ora

    6. Create data base with this command that below..

    create database "ANSI74"
    maxlogfiles 10
    maxinstances 5
    maxlogmembers 10
    maxdatafiles 30
    maxloghistory 100
    logfile
    group 1
    'c:\pritpal\disk3\redo01.rdo' size 100k,
    group 2
    'c:\pritpal\disk4\redo02.rdo' size 100k
    datafile
    'c:\pritpal\disk5\system01.dbf' size 25m;



    Init.ora
    ********
    remote_login_passwordfile = exclusive

    ok then

    i have abc database and also pwdABC.ora(password file)


    ? Way oracle look for my OLD PASSWORDFILE.
    ? Way not new Password file that is pwdANSI74.ora(in same desti)

    Because
    ? I have set ORACLE_SID=ansi74

    error>>
    ORA-01991:invalid password file c:\oracle\ora81\database\PWDabc.ora .

    before i had this error:

    The environment variables ORA_sid_PWFILE and ORA_PWFILE are not set.

    Give reply.
    Last edited by OCDBA; 05-20-2003 at 06:49 PM.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Did you create a service?

  3. #3
    Join Date
    Mar 2001
    Posts
    286
    You can use DBAssist to create a set of scripts to create your database. That also creates the service for you. Also, type oradim in command line to get a list of info for using oradim to create the service. Good luck! You will learn a lot by creating the db yourself!

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The password file should be in $ORACLE_HOME/dbs directory and named orapwsid
    I guess Oracle is looking at wrong password file.
    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Oooops.. just realised we are talking windows here. The correct location for Windows is $ORACLE_HOME/database and name pwdsid.ora
    Make sure the service is running. And for known issues with password file go through this document.
    How to Avoid Common Flaws and Errors Using Passwordfile
    Last edited by SANJAY_G; 05-20-2003 at 11:06 PM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    May 2001
    Posts
    736
    When u have DB Configuration Asst to create a database for u why u are messing with other files.As said by DBA_ADMIN use this tool to create a new DB.

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by akhadar
    When u have DB Configuration Asst to create a database for u why u are messing with other files.As said by DBA_ADMIN use this tool to create a new DB.
    I don't know about others but I don't really like to do the things with GUIs.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its 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