Database Creation on NT Box
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Creation on NT Box

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi Guru's,

    I am new to NT environment. Now I need to create a database on NT box, on which already one database is running. How can I create another database on same box? Please tell me the steps to complete this task. Your help in this regard highly appreciated.


    Thanks In Advance.
    Nagesh

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Use Oracle Database Configuration Assistant. It is a GUI method of creating a database.

    Vijay.
    Say No To Plastics

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    It's basically the same as UNIX except the oradim.exe is used to setup a new service to run the Oracle instance.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  4. #4
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi DBA guru's

    I apologize for the delay in responding. Job successes fully done. Thank You Very Much.

    But, I have small doubt, is it required to set remote_login_passwordfile = exclusive, because, I tried with uncommenting the same, I got the insufficient privileges error while database creation.

    Please clear me in this regard.

    Thanks Once again.
    Nagesh

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Change remote_login_passwordfile = exclusive to remote_login_passwordfile = none and run the "create database" statement. If no success, then post here the init.ora with which you have nomounted the database.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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