OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » clone DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

clone DB [message #60405]

Thu, 05 February 2004 23:01

ashokmote
Messages: 56
Registered: December 2003

Member

oracle 8i (version 8.1.5) on windows 2000 prof.

clone DB

1.created backup control file to trace
2.shut down the DB
3. copied all datafiles,log files,control files to new location.
4.init.ora also copied to new locatiion
5.In init.ora file changed db_name = new name and also path of control file;
6.in trace file i made
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "NEW NAME" NORESETLOGS NOARCHIVELOG

and also commented

# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
#RECOVER DATABASE
# Database can now be opened normally.
#ALTER DATABASE OPEN;
# No tempfile entries found to add.
#

and also path of all files changed to new path.

7.then created service for new database

C:>oradim -new -sid ravi

C:>set oracle_sid=ravi

8.when i login as internal it is giving error

C:>sqlplus "/as sysdba"

SQL*Plus: Release 8.1.5.0.0 - Production on Thu Feb 5 13:02:26 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter user-name: internal
Enter password:
ERROR:
ORA-01031: insufficient privileges

Enter user-name: internal
Enter password:
ERROR:
ORA-01031: insufficient privileges
9.
my question is which password i have to give to login into DB.were these passwords r stored.
i am using oracle8i version 8.1.5

Report message to a moderator