Hi there,
i'm confused in a way to start database instance on my RAC environment.
Now i have:
crsctl status res -t
-------------------------------------------------------------------------------- Local Resources--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE spb-oracle-test-node1 STABLE
ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.DATA.dg
ONLINE ONLINE spb-oracle-test-node1 STABLE
ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.FRA.dg
ONLINE ONLINE spb-oracle-test-node1 STABLE
ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE spb-oracle-test-node1 STABLE
ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.chad
ONLINE ONLINE spb-oracle-test-node1 STABLE
OFFLINE OFFLINE spb-oracle-test-node2 STABLE
ora.net1.network
ONLINE ONLINE spb-oracle-test-node1 STABLE
ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.ons
ONLINE ONLINE spb-oracle-test-node1 STABLE
ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.proxy_advm
OFFLINE OFFLINE spb-oracle-test-node1 STABLE
OFFLINE OFFLINE spb-oracle-test-node2 STABLE
--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE spb-oracle-test-node1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE spb-oracle-test-node1 169.254.232.166 10.172.20.1,STABLE
ora.asm
1 ONLINE ONLINE spb-oracle-test-node1 Started,STABLE
2 ONLINE ONLINE spb-oracle-test-node2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.mgmtdb
1 ONLINE ONLINE spb-oracle-test-node1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.scan1.vip
1 ONLINE ONLINE spb-oracle-test-node1 STABLE
ora.scan2.vip
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.scan3.vip
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.spb-oracle-test-node1.vip
1 ONLINE ONLINE spb-oracle-test-node1 STABLE
ora.spb-oracle-test-node2.vip
1 ONLINE ONLINE spb-oracle-test-node2 STABLE
ora.testdb.db
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE spb-oracle-test-node2 Open,HOME=/u01/app/oracle/product/12.2.0/dbhome_1/,STABLE
ora.testdb.test.svc
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE spb-oracle-test-node2 STABLE
--------------------------------------------------------------------------------
Ok. Now I'm trying to start my instance:
[oracle@spb-oracle-test-node1 ~]$ srvctl start instance -db testdb -n spb-oracle-test-node1
PRCR-1013 : Failed to start resource ora.testdb.db
PRCR-1064 : Failed to start resource ora.testdb.db on node spb-oracle-test-node1
CRS-5017: The resource action "ora.testdb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/inittestdb_1.ora'
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/spb-oracle-test-node1/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.testdb.db' on 'spb-oracle-test-node1' failed
Oh, no-o-o :`(
my SPFILE file is on ASM
[oracle@spb-oracle-test-node1 ~]$ srvctl config database -d testdb -a
Database unique name: testdb
Database name:
Oracle home: /u01/app/oracle/product/12.2.0/dbhome_1/
Oracle user: oracle
Spfile: +DATA/TESTDB/PARAMETERFILE/spfile.320.1017479447
Password file: +DATA/TESTDB/PASSWORD/pwdtestdb.310.1017479231
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: Free
Disk Groups: DATA
Mount point paths:
Services: test
Type: RAC
Start concurrency:
Stop concurrency:
Database is enabled
Database is individually enabled on nodes:
Database is individually disabled on nodes:
OSDBA group: dba
OSOPER group:
Database instances:
Configured nodes:
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is policy managed
suspicious part in /u01/app/oracle/diag/crs/spb-oracle-test-node1/crs/trace/crsd_oraagent_oracle.trc is:
2019-09-12 10:16:33.655 : AGFW:4048115456: {0:19:2} Agent received the message: RESOURCE_ADD[ora.testdb.db 1 1] ID 4356:4443
2019-09-12 10:16:33.656 : CLSDADR:4048115456: (:CLSD0023:)dynamic component [R1730606] mapped to [CLSDYNAM]
2019-09-12 10:16:33.656 : AGFW:4048115456: {0:19:2} ID = [ora.testdb.db 1 1] Intermediate Timeout = [0]
2019-09-12 10:16:33.656 : AGFW:4048115456: {0:19:2} Added new resource: ora.testdb.db 1 1 to the agfw
2019-09-12 10:16:33.657 : AGFW:4048115456: {0:19:2} Agent sending last reply for: RESOURCE_ADD[ora.testdb.db 1 1] ID 4356:4443
2019-09-12 10:16:33.657 : AGFW:4048115456: {1:24747:982} Agent received the message: RESOURCE_CLEAN[ora.testdb.db 1 1] ID 4100:4444
2019-09-12 10:16:33.657 : AGFW:4048115456: {1:24747:982} Preparing CLEAN command for: ora.testdb.db 1 1
2019-09-12 10:16:33.657 : AGFW:4048115456: {1:24747:982} ora.testdb.db 1 1 state changed from: UNKNOWN to: CLEANING
2019-09-12 10:16:33.659 :CLSDYNAM:4050216704: [ora.testdb.db]{1:24747:982} [clean] (:CLSN00106:) clsn_agent::clean {
2019-09-12 10:16:33.659 :CLSDYNAM:4050216704: [ora.testdb.db]{1:24747:982} [clean] Agent::getResAgent resname:ora.testdb.db version:12.2.0.1.0
checked file permission for
$GRID_HOME/bin/oracle but they are fine.
Do you have any suggestions what can it be?