The Oracle resource can not be taken online by vcs while it can be started by manual and then monitored by vcs.
Article ID: 100030361
Updated On:
Description
Error Message
LRM-00123: invalid character 0 found in the input fileORA-01078: failure in processing system parameters
Resolution
This issueis related with the PFILE did not created when the oracleinstalled.
Though wecan support the SPFILE as default,but it should be created from thePFILE;
In thissituation,the customer installed the Oracle102 by the script auto installationwithout the SPFILE,so this type of PFILE can not be recognized byVCS.
Afterre-created the PFILE and modify the "PFILE" attribute with the new filepath ,the ORACLE resource can be taken online as normal in VCS.
Resolution
1.the ORACLE resource inmain.cf before the pfile attribute modified:
Oracle Ora_Oracle(
Sid = gloeye
Owner = oracle
Home ="/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1"
Pfile ="/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/dbs/spfilegloeye.ora"
EnvFile= "/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/root.sh"
User =globaleyeuser
Pword = BPBnCPePEpINf
Table = tbl_ec
)
2.Theerror message when the spfile can not be recognized by VCS:
2008/02/2813:47:01 VCS INFO V-16-2-13072 (vmm) Resource(Ora_ora): Agent is retrying online(attempt number 1 of 1).
2008/02/2813:47:01 VCS INFO V-16-20002-104 (vmm) Oracle:Ora_ora:online:The IPC library isnot from Veritas.
2008/02/2813:47:01 VCS NOTICE V-16-20002-21 (vmm) Oracle:Ora_ora:online:Oracle startupreturned the output
+--------------------------------------------------------------------+
LD_LIBRARY_PATH-/usr/lib:/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/lib:/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/lib:
LRM-00123:invalid character 0 found in the input file
ORA-01078:failure in processing system parameters
+====================================================================+
3.Createthe pfile from the spfile in SQLplus:
SQL>createpfile='/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/dbs/pfilegloeye.ora'from spfile;
Filecreated.
4.Modifythe 'Pfile' attribute in the Oracle resource as bellow:
Pfile ="/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/dbs/pfilegloeye.ora"
5.Tryingto online the Oracle resource again ,It can be online as normal:
2008/02/2815:17:24 VCS NOTICE V-16-1-10301 Initiating Online of Resource Ora_ora (Owner:unknown, Group: svcora) on System vmm
2008/02/2815:17:25 VCS INFO V-16-20002-104 (vmm) Oracle:Ora_ora:online:The IPC library isnot from Veritas.
2008/02/2815:17:26 VCS INFO V-16-1-10298 Resource Ora_IP (Owner: unknown, Group: svcora)is online on vmm (VCS initiated)
2008/02/2815:17:45 VCS NOTICE V-16-20002-21 (vmm) Oracle:Ora_ora:online:Oracle startupreturned the output
+--------------------------------------------------------------------+
LD_LIBRARY_PATH-/usr/lib:/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/lib:/mnt/oracle_home/oracle/oracle/product/10.2.0/db_1/lib:
ORACLEinstance started.
Total SystemGlobal Area 167772160 bytes
FixedSize 1218292 bytes
VariableSize 79694092 bytes
DatabaseBuffers 79691776 bytes
RedoBuffers 7168000 bytes
Databasemounted.
Databaseopened.
+====================================================================+
2008/02/2815:17:47 VCS INFO V-16-1-10298 Resource Ora_ora (Owner: unknown, Group: svcora)is online on vmm (VCS initiated)
Issue/Introduction
The Oracle resource can not be taken online by vcs while it can be started by manual and then monitored by vcs.
Was this article helpful?
Yes
No
Powered by
