Dear Faculties,
Thanks for your great supports.I drop my previous DB. And Create
the new one with the same name.Please advice for any modification is
needed???
oradim -new -sid TempDB -intpwd tempdb -startmode manual -pfile
E:\Oracle\admin\TempDB\pfile\inittempdb.ora
SET ORACLE_SID=tempdb
SQLPLUS /NOLOG
CONNECT internal/tempdb as SYSDBA
STARTUP PFILE=E:\Oracle\admin\tempdb\pfile\inittempdb.ora NOMOUNT
CREATE DATABASE TempDB
CONTROLFILE REUSE
LOGFILE 'E:\Oracle\oradata\tempdb\redo01.log' SIZE 100M,
'E:\Oracle\oradata\tempdb\redo02.log' SIZE 100M,
'E:\Oracle\oradata\tempdb\redo03.log' SIZE 100M
DATAFILE 'E:\Oracle\oradata\tempdb\system01.dbf' SIZE 325M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8;
orapwd file=E:\Oracle\iSuites\DATABASE\PWDtempdb.ORA password=tempdb entries=20
I used orapwd ulility because unless at the time of startup
it was giving error password not indentified check PWDtempdb.ORA
Run The Scripts
@E:\Oracle\iSuites\RDBMS\ADMIN\catalog.sql
@E:\Oracle\iSuites\sqlplus\admin\PUPBLD.SQL
@E:\Oracle\iSuites\RDBMS\ADMIN\catproc.sql
@E:\Oracle\iSuites\RDBMS\ADMIN\standard.sql
@E:\Oracle\iSuites\RDBMS\ADMIN\utlirp.sql
@E:\Oracle\iSuites\RDBMS\ADMIN\catexp.sql
Now I can use the Tab table,open the DBA Studio,
Now it is working fine.
Regards
Arijit Chatterjee
Received on Tue Sep 07 2004 - 07:34:44 CDT