Most often with fresh DBAs after installing the oracle on linux and setting the environment faced below error message while starting the Database Instance:
ORA-01078: failure in processing system parameters
you did below like setting environment for the instance,i.e oracle sid and oracle home,base etc
Everything else is fine but issue is that oracle SID given during creation of DB is not matching with the environment variable set. In above scenario Oracle is trying to find pfile with name inittestdb.ora but actual file
initTESTDB.ora.
cd $ORACLE_HOME/dbs
-rw-r----- 1 oracle oinstall 39 Feb 7 16:36 initTESTDB1.ora
Solution:
Simple solution will be to set SID name according to SID name given during creation of DB.
Like:
login through oracle user
$ export ORACLE_SID=TESTDB;
OR setting it in enviroment variable file
oracle@racnode1 ~]$ vi db.env
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=racnode1; export ORACLE_HOSTNAME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[oracle@racnode1 ~]$ . db.env
[oracle@racnode1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 7 18:13:35 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
Or as below:
When login through sqlplus , below error was noticed:
If we check the Oracle Unique name and Oracle SID given is testdb:
ORA-01078: failure in processing system parameters
you did below like setting environment for the instance,i.e oracle sid and oracle home,base etc
[oracle@racnode1 ~]$ . db.env
[oracle@racnode1 ~]$ cat db.env
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=racnode1; export ORACLE_HOSTNAME
ORACLE_UNQNAME=testdb; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
ORACLE_SID=testdb; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[oracle@racnode1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 7 17:37:27 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbs/inittestdb.ora'
SQL>
Issue:Everything else is fine but issue is that oracle SID given during creation of DB is not matching with the environment variable set. In above scenario Oracle is trying to find pfile with name inittestdb.ora but actual file
initTESTDB.ora.
cd $ORACLE_HOME/dbs
-rw-r----- 1 oracle oinstall 39 Feb 7 16:36 initTESTDB1.ora
Solution:
Simple solution will be to set SID name according to SID name given during creation of DB.
Like:
login through oracle user
$ export ORACLE_SID=TESTDB;
OR setting it in enviroment variable file
oracle@racnode1 ~]$ vi db.env
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=racnode1; export ORACLE_HOSTNAME
ORACLE_UNQNAME=TESTDB; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
ORACLE_SID=TESTDB; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[oracle@racnode1 ~]$ . db.env
[oracle@racnode1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 7 18:13:35 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
Or as below:
When login through sqlplus , below error was noticed:
If we check the Oracle Unique name and Oracle SID given is testdb:
Now setting both of the above variables to respective name:
Now setting the enviroment and run it again:
No comments:
Post a Comment