One of my collegues has asked me to help him to start thedatabase that has been created before. When i check, i saw that the databaseserver parameter files –somehow- has been deleted from its own place($ORACLE_HOME/dbs).Then, i opened the database from the init.ora which is created during databasecreation. Finally, i created spfile form this init.ora(pfile).
[oracle@localhost dbs]$/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun21 08:58:08 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing systemparameters
LRM-00109: could not open parameter file'/app/oracle/product/11.2.0/dbhome_1/dbs/initTESTDB.ora'
SQL> exit
Disconnected
[oracle@localhost dbs]$
[oracle@localhost pfile]$/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun21 09:08:29 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup nomountpfile=/app/oracle/admin/TESTDB/pfile/init.ora
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 209718360 bytes
Database Buffers 96468992 bytes
Redo Buffers 6336512 bytes
SQL> create spfile from pfile
2 ;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing systemparameters
LRM-00109: could not open parameter file
'/app/oracle/product/11.2.0/dbhome_1/dbs/initTESTDB.ora'
SQL> create spfile frompfile=/app/oracle/admin/TESTDB/pfile/init.ora;
create spfile frompfile=/app/oracle/admin/TESTDB/pfile/init.ora
*
ERROR at line 1:
ORA-02236: invalid file name
SQL> create spfile frompfile='/app/oracle/admin/TESTDB/pfile/init.ora';
File created.
SQL> create pfile from spfile;
File created.
SQL> exit
Disconnected from Oracle Database 11g EnterpriseEdition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and RealApplication Testing options
[oracle@localhost pfile]$ pwd
/app/oracle/admin/TESTDB/pfile
[oracle@localhost pfile]$ ls
init.ora
[oracle@localhost pfile]$ ls -ltr $ORACLE_HOME/dbs
total 72
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
drwx------ 2 oracle dba 4096 Jun 20 14:19peshm_DBUA0_0
-rw-rw---- 1 oracle dba 1544 Jun 20 14:19hc_DBUA0.dat
drwx------ 2 oracle dba 4096 Jun 20 22:52peshm_TESTDB_0
-rw-r----- 1 oracle dba 1536 Jun 20 22:52orapwTESTDB
-rw-rw---- 1 oracle dba 1544 Jun 20 22:52hc_TESTDB.dat
-rw-r----- 1 oracle dba 24 Jun 20 22:52 lkTESTDB
-rw-r----- 1 oracle dba 1536 Jun 21 09:14spfileTESTDB.ora
-rw-r--r-- 1 oracle dba 476 Jun 21 09:14 initTESTDB.ora
[oracle@localhost pfile]$/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun21 09:15:44 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and RealApplication Testing options
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> startup
ORA-01081: cannot start already-running ORACLE -shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 209718360 bytes
Database Buffers 96468992 bytes
Redo Buffers 6336512 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
TESTDB
SQL>
No comments:
Post a Comment