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

Thread: Second db on Oracle 8.0.4 Netware

  1. #1
    Join Date
    Mar 2001
    Posts
    4

    Unhappy

    Please can anyone help me. I'm facing the task of putting a second database next to a production database.

    I'm familiar with this on a NT-platform, but not on a Novell-platform.

    I am intending to:

    Add a new SID name to the listener in LISTENER.ORA.

    Setup a new service name in TNSNAMES.ORA that uses the IPC protocol.

    Create a new parameter file in the ORACLE_HOME\DATABASE directory of the form initSID.ora.
    making sure that the control_file parameter specifies a new control file name, and the db_name points to the newdatabase name.

    Start Server Manager

    LOAD SVRMGR

    Connect as INTERNAL.

    SVRMGR>CONNECT INTERNAL/<PASSWORD@service_name

    Start up the database with the new instance:

    SVRMGR>STARTUP PFILE=%ORACLE_HOME%DATABASE\INITSID.ORA

    And then running the necesarry scripts.

    If this is not the correct procedure, please help me.
    I'd appreciate any help.

    Thnx in advance.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    [url]http://www.dbasupport.com/forums/showthread.php?threadid=7266[/url]
    Reddy,Sam

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