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

Thread: Creating new DB

  1. #1
    Join Date
    Sep 2001
    Posts
    163
    HELP!! I know I am missing something but I can't think of what. I am trying to create a second database on a development machine. (NT 4.0 SP6, Oracle 8.1.6.0.0). One db already exists on the machine and is operating just fine. Let's call this db "Mickey". I'm now trying to create a second db called "Minnie". (atleast I still have a sense of humor.) Anyway, I have not executed any scripts as of yet. I have created my "create database" script, create tablespaces, create users, etc. When I'm at the DOS prompt, I set Oracle_sid=Minnie, type svrmgrl to get server manager. I then connect internal/manager and say show parameters db*. It always shows up as Mickey. Shouldn't it show up as nothing, since Minnie has not been created yet. How can I create this second database? When I try to startup/nomount the new database with its init.ora, I get the message that the database is already running.

  2. #2
    Join Date
    Oct 2001
    Location
    Toronto, Canada
    Posts
    236
    You need to create a new instance first. One instance can connect to one db only ( well, not exactly, but let's assume it is correct for now).

    Leo

  3. #3
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    Did you create the new service for the new database in services? And the start the service. After setting these the set the sid and start srvmgrl

  4. #4
    Join Date
    Sep 2001
    Posts
    163
    I have OracleServiceMickey
    OracleServiceMinnie

    I stopped and restarted Lsnrctl.

    I added the new sid_name = Minnie to the listener.ora file.

    I added a new entry into my tnsnames.ora file.

    The only way I can get svrmgrl to "point" to my new db is to shutdown the current db and startup the new one. But I shouldn't have to do this.

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