| CRS-2674: Start of 'ora.orcl.db' on 'node-db2' failed [message #643365] |
Tue, 06 October 2015 05:06  |
 |
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 #643369 is a reply to message #643367] |
Tue, 06 October 2015 06:43  |
|
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 #643722 is a reply to message #643379] |
Fri, 16 October 2015 05:41 |
|
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 #643781 is a reply to message #643730] |
Sun, 18 October 2015 03:30 |
John Watson
Messages: 8977
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 |
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
