Oracle Database Discussions

Hi All,

I have created database under following environment.
1. Oracle 10g 10.2.0.3
2. ASM 10g 10.2.0.3
3. Oracle Clusterware 10.2.0.3
4. Two node cluster
Platformm Sun Solaris 10

When I startup Database usging pfile, it started up without any issue.
startup pfile='/u01/app/oracle/admin/HALA01/pfile/initHALA01.ora';

But When I creating spfile from above pfile and startup the database then I am getting following error message.

SQL> startup pfile='/u01/app/oracle/admin/HALA01/pfile/initHALA011.ora'

ORACLE instance started.

Total System Global Area 536870912 bytes
Fixed Size 2129752 bytes
Variable Size 152928424 bytes
Database Buffers 377487360 bytes
Redo Buffers 4325376 bytes
Database mounted.
Database opened.
SQL> SQL>
SQL> create spfile='+DATA_DG01/HALA01/PARAMETERFILE/spfileHALA01.ora' from pfile;

File created.

SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA_DG01/HALA01/PARAMETERFILE/spfileHALA01.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA_DG01/HALA01/PARAMETERFILE/spfileHALA01.ora
ORA-01000: maximum open cursors exceeded
SQL>

You can see from above steps when I started with pfile no issue and when created spfile and started and error message.

INITHALA011.ora file

*.audit_file_dest='/u01/app/oracle/admin/HALA01/adump'
*.background_dump_dest='/u01/app/oracle/admin/HALA01/bdump'
*.cluster_database=TRUE
*.cluster_database_instances=2
*.compatible='10.2.0.3.0'
*.control_files='+DATA_DG01/hala01/controlfile/current.261.647627209','+FLBK_DG01/hala01/controlfile/current.257.647627209'
*.core_dump_dest='/u01/app/oracle/admin/HALA01/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DATA_DG01'
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='HALA01'
*.db_recovery_file_dest='+FLBK_DG01'
*.db_recovery_file_dest_size=2048M
*.dispatchers='(PROTOCOL=TCP) (SERVICE=HALA01XDB)'
HALA011.instance_name=HALA011
HALA012.instance_name=HALA012
HALA011.instance_number=1
HALA012.instance_number=2
*.job_queue_processes=10
open_cursors=2048
pga_aggregate_target=50M
*.processes=150
*.remote_login_passwordfile='exclusive'
sga_target=512M
HALA012.thread=2
HALA011.thread=1
*.undo_management='AUTO'
HALA012.undo_tablespace='UNDOTBS2'
HALA011.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/HALA01/udump'
HALA011.local_listener=HALA011_local_listener
HALA012.local_listener=HALA012_local_listener
db_files=2000
global_names=TRUE

Even I have increased the size of open_cursors from 300 to 2048. I got only one Database on this machine.

Even I can see spfile has been created in ASM.....

ASMCMD [+DATA_DG01/HALA01] > cd PARAMETERFILE/
ASMCMD [+DATA_DG01/HALA01/PARAMETERFILE] > ls -lrt
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE MAR 03 00:00:00 Y spfile.269.648347023
N spfileHALA01.ora => +DATA_DG01/HALA01/PARAMETERFILE/spfile.269.648347023
ASMCMD [+DATA_DG01/HALA01/PARAMETERFILE] >

Please help me ................