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

Thread: how to rename 9i database in windows 2000

Threaded View

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    how to rename 9i database in windows 2000

    Hi All,
    I am trying to rename an oracle database on windows 2000. I am having some issues...can anyone help me how to fix it.

    Trace file is created from existing database (ORCLDB) using alter database backup controlfile to trace

    and the following steps are followed....

    Modify (and optionally rename) the created trace file:
    Find the line reading # Set #2. RESETLOGS case
    Remove all lines above this line.
    Change the line containing the database name from CREATE CONTROLFILE REUSE DATABASE "ORA9" RESETLOGS NOARCHIVELOG
    to
    CREATE CONTROLFILE SET DATABASE "CAT" RESETLOGS NOARCHIVELOG
    Note, in my case, the database is running in noarchive log mode. The corresponding line reads ARCHIVELOG otherwise.
    Remove the line reading RECOVER DATABASE USING BACKUP CONTROLFILE.
    Remove lines starting with #.

    the edited .trc file is saved as rename.sql

    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "NEWORCLDB" RESETLOGS NOARCHIVELOG
    -- SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 454
    LOGFILE
    GROUP 1 'd:\oracle\databases\redo1.ora' SIZE 100M,
    GROUP 2 'd:\oracle\databases\redo2.ora' SIZE 100M,
    GROUP 3 'd:\oracle\databases\redo3.ora' SIZE 100M
    -- STANDBY LOGFILE
    DATAFILE
    'd:\oracle\datafile\system.dbf',
    'd:\oracle\datafile\undo.dbf',
    'd:\oracle\datafile\data.dbf'
    CHARACTER SET WE8ISO8859P1
    ;
    ALTER DATABASE OPEN RESETLOGS;
    ALTER TABLESPACE TEMP ADD TEMPFILE 'd:\oracle\Ora90\databases\temp.dbf'
    SIZE 104857600 REUSE AUTOEXTEND OFF;

    shutdown the ORCLDB databas from windows services

    Moved the old control file to other location


    The database name are changed in the new initneworcldb.ora

    Bcaz there is no SVRMGRL in 9i....How do i connect ??

    I tried sqlplus "/ as sysdba"

    Its asking for username and password...Which username/password and instance name should i give??

    How to proceed...pls advice.

    Many Thanks,
    Last edited by castlerock; 12-09-2005 at 04:24 PM.

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