Home » Server Options » RAC & Failsafe » CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit,windows server 2008)
CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643365] Tue, 06 October 2015 05:06 Go to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
here in my test rac database i want try to increase my sga_target size that time i follow this steps

that time my sga_target size its 0 and my sga_max_size its 1408M i change this my value of sga_target using this command its

alter system set sga_target =2G sid='*' scope=spfile;


its change successfully but when i restart server its give me error

Quote:
ORA-00838: Specified value of MEMORY_TARGET is too small


so i just edit this pfile and start database with pfile then create this spfile file from this pfile and start database with force option but only my one node start another node not started
i follow this steps mention on this website
Quote:

http://dbatricksworld.com/ora-00838-specified-value-of-memory_target-is-too-small-needs-to-be-at-least-3072m-oracle-12c/


any body help me how can i change this memory_target value in this 11g RAC database.
Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643367 is a reply to message #643365] Tue, 06 October 2015 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Stop the database (all instances).
Start one instance in nomount state.
Change the parameters as you want in the spfile using ALTER SYSTEM.
Shutdown the database.
Start the instances.

Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643369 is a reply to message #643367] Tue, 06 October 2015 06:43 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
thanks for your quick reply i did this steps michel but i cannot start my another instance orcl2 only one instance i started using your giving steps;

SQL> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2182592 bytes
Variable Size             746586688 bytes
Database Buffers          314572800 bytes
Redo Buffers                5595136 bytes

SQL> alter system set sga_target =350M sid='*' scope=spfile;

System altered.

SQL> alter system set memory_target=1024M sid='*' scope=spfile;

System altered.


C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 6 16:27:13 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL> show parameter sga_target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_target                           big integer 352M
SQL> show parameter memory_target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_target                        big integer 1G
SQL> select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl1            OPEN


C:\Users\Administrator>srvctl start instance -d  orcl -i  orcl2
PRCR-1013 : Failed to start resource ora.orcl.db
PRCR-1064 : Failed to start resource ora.orcl.db on node node-db2
ORA-01078: failure in processing system parameters
CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed


i create a pfile my current pfile its look like this

orcl2.__db_cache_size=419430400
orcl1.__db_cache_size=314572800
orcl2.__java_pool_size=16777216
orcl1.__java_pool_size=16777216
orcl2.__large_pool_size=16777216
orcl1.__large_pool_size=4194304
orcl1.__oracle_base='C:\app\Administrator'#ORACLE_BASE set from environment
orcl2.__oracle_base='C:\app\Administrator'#ORACLE_BASE set from environment
orcl2.__pga_aggregate_target=603979776
orcl1.__pga_aggregate_target=432013312
orcl2.__sga_target=872415232
orcl1.__sga_target=641728512
orcl2.__shared_io_pool_size=0
orcl1.__shared_io_pool_size=0
orcl2.__shared_pool_size=402653184
orcl1.__shared_pool_size=293601280
orcl2.__streams_pool_size=0
orcl1.__streams_pool_size=0
*.audit_file_dest='C:\app\Administrator\admin\orcl\adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+ASM_DF_DG/orcl/controlfile/current.260.890485061'
*.db_block_size=8192
*.db_create_file_dest='+ASM_DF_DG'
*.db_domain=''
*.db_name='orcl'
*.diagnostic_dest='C:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
orcl2.instance_number=2
orcl1.instance_number=1
*.memory_target=1073741824
*.open_cursors=300
*.processes=150
*.remote_listener='wrac-scan:1521'
*.remote_login_passwordfile='exclusive'
*.sga_target=367001600
orcl2.thread=2
orcl1.thread=1
orcl2.undo_tablespace='UNDOTBS2'
orcl1.undo_tablespace='UNDOTBS1'

[Updated on: Tue, 06 October 2015 07:07]

Report message to a moderator

Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643379 is a reply to message #643369] Tue, 06 October 2015 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you use a pfile then the modification in spfile you made are useless.
You must
1/ Use a spfile
2/ Use the SAME spfile for all instances, which means it is in a shared location.

Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643722 is a reply to message #643379] Fri, 16 October 2015 05:41 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
ok i did all this

i create spfile at shared location but when i check this spfile location its change

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 16 13:16:46 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup pfile='C:\tho\tsho.ora';
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2182592 bytes
Variable Size             771752512 bytes
Database Buffers          289406976 bytes
Redo Buffers                5595136 bytes
Database mounted.
Database opened.
SQL> show parameter sga_target;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_target                           big integer 352M
SQL> show parameter sga_max_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 1G
SQL> create spfile='+ASM_DF_DG/orcl/spfileorcl.ora' from pfile='C:\tho\tsho.ora'
;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2182592 bytes
Variable Size             771752512 bytes
Database Buffers          289406976 bytes
Redo Buffers                5595136 bytes
Database mounted.
Database opened.
SQL> show parameter sga_target;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_target                           big integer 352M
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      C:\APP\ADMINISTRATOR\PRODUCT\1
                                                 1.2.0\DBHOME_1\DATABASE\SPFILE
                                                 ORCL1.ORA
SQL>
SQL> select sys_context('USERENV','INSTANCE_NAME') FROM DUAL;

SYS_CONTEXT('USERENV','INSTANCE_NAME')
--------------------------------------------------------------------------------

orcl1


and on my another instance i check this spfile location its different


SQL> select sys_context('USERENV','INSTANCE_NAME') FROM DUAL;

SYS_CONTEXT('USERENV','INSTANCE_NAME')
--------------------------------------------------------------------------------

orcl2

SQL> SHOW PARAMETER SPFILE;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +ASM_DF_DG/orcl/spfileorcl.ora
SQL>


Why my orcl1 instance spfile not created at this +ASM_DF_DG/orcl/spfileorcl.ora location.

[Updated on: Fri, 16 October 2015 05:43]

Report message to a moderator

Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643727 is a reply to message #643722] Fri, 16 October 2015 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 06 October 2015 14:35

If you use a pfile then the modification in spfile you made are useless.
You must
1/ Use a spfile
2/ Use the SAME spfile for all instances, which means it is in a shared location.

Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643730 is a reply to message #643727] Fri, 16 October 2015 07:30 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
i already use spfile
but i create spfile at +ASM_DF_DG/orcl/spfileorcl.ora location. but its show me spfile location another on my orcl1 instance.i already create this spfile in shared location michel.
Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643732 is a reply to message #643730] Fri, 16 October 2015 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Remove the wrong spfile.

Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643761 is a reply to message #643732] Sat, 17 October 2015 05:29 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
how can i remove it from this shared storage .can you guide me
Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643769 is a reply to message #643761] Sat, 17 October 2015 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You are on the wrong track.
The wrong spfile is the one NOT in shared storage.
Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643781 is a reply to message #643730] Sun, 18 October 2015 03:30 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I think that after all this you have probably messed up the registration of the database in the cluster registry. You need to adjust it to point the correct pfile, something like

srvctl modify database -d orcl - p '+ASM_DF_DG/orcl/spfileorcl.ora'
srvctl stop database -d orcl -o abort
srvctl start database -d orcl
Re: CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643802 is a reply to message #643781] Mon, 19 October 2015 02:02 Go to previous message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
thanks for you reply

john i follow steps you give me i got another error


C:\Users\Administrator>srvctl modify database -d orcl -p '+ASM_DF_DG/orcl/spfile
orcl.ora'


C:\Users\Administrator>srvctl stop database -d orcl -o abort



C:\Users\Administrator>srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
ORA-01078: failure in processing system parameters
CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on th
at would satisfy its placement policy


my one instance orcl1 already stared and database open but my another node orcl2 not started and still my spfile not show me on my shared location on my orcl1 instance

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      C:\APP\ADMINISTRATOR\PRODUCT\1
                                                 1.2.0\DBHOME_1\DATABASE\SPFILE
                                                 ORCL1.ORA
SQL> select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl1            OPEN



C:\Users\Administrator>srvctl config database -d orcl -a
Database unique name: orcl
Database name: orcl
Oracle home: C:\app\Administrator\product\11.2.0\dbhome_1
Oracle user: system
Spfile: '+ASM_DF_DG/orcl/spfileorcl.ora'
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: ASM_DF_DG
Services:
Database is enabled
Database is administrator managed

C:\Users\Administrator>


on my another node orcl2

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 19 12:54:42 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file ''
ORA-09314: sltln: error translating logical name
OSD-04026: Invalid parameter passed.
SQL>

[Updated on: Mon, 19 October 2015 02:31]

Report message to a moderator

Previous Topic: Setup RAC at home laptop
Next Topic: Query
Goto Forum:
  


Current Time: Thu Mar 28 13:00:02 CDT 2024