Home » Infrastructure » Linux » startup problem
startup problem [message #127555] Tue, 12 July 2005 03:46 Go to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

startup problem

sql>startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.1.0/db_1
/dbs/initcfsl.ora'


above error i got

please help me
Re: startup problem [message #127564 is a reply to message #127555] Tue, 12 July 2005 04:48 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Can you edit the file?

Best regards.

Frank
Re: startup problem [message #127565 is a reply to message #127564] Tue, 12 July 2005 04:50 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

yaa i edit the file


but i only set

utl_file_dir=* in spfile
Re: startup problem [message #127566 is a reply to message #127565] Tue, 12 July 2005 04:54 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
You've got me confused now. Your first post referred to a PFILE, now you are referring to an SPFILE.

SPFILEs are binary files and should not be edited - they will become corrupt!

Best regards.

Frank
Re: startup problem [message #127568 is a reply to message #127566] Tue, 12 July 2005 05:00 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

i changed the setting in spfile

in pfile doesnt change anything

and i got this error

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.1.0/db_1
/dbs/initcfsl.ora'


is because of spfile?

please suggest a solution

if not then what is the actual problem
Re: startup problem [message #127614 is a reply to message #127568] Tue, 12 July 2005 09:12 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Sir

spfile is binary file & is not supposed to be manually edited.
Now start your database using ur pfile & then create a new spfile there.

Regds
Girish
Re: startup problem [message #127724 is a reply to message #127614] Wed, 13 July 2005 01:01 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

hello

i tried to startup database using pfile but i got following errors

SQL> startup pfile='/oracle/app/oracle/product/10.1.0/db_1/dbs/initcfsl.ora'

LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.1.0/db_1
/dbs/initcfsl.ora'

ORA-01078: failure in processing system parameters

[Updated on: Wed, 13 July 2005 01:04]

Report message to a moderator

Re: startup problem [message #127735 is a reply to message #127724] Wed, 13 July 2005 01:29 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

Have u checked the file permissions?
IS your oracle user (under which you are trying to start the instance) allowed to access this file?

Regds
Girish
Re: startup problem [message #127957 is a reply to message #127735] Thu, 14 July 2005 06:28 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

hello

my spfilecfsl.ora is corruptd so i remove this one

and made new spfilecfsl.ora
so by creating spfile using pfile as

SQL> create spfile from
1 pfile='/oracle/app/oracle/product/10.1.0/db_1/dbs/init.ora'

so after creation of spfile

SQL> startup
error message
ORA-01031: insufficient privileges

and in the alert_cfsl.log file following mesage appears

The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below


so what i do next please help me
Re: startup problem [message #128398 is a reply to message #127957] Mon, 18 July 2005 06:29 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

You are connected thru which user?
Also, apart from the message posted for alrt.log file, is there any other error message getting displayed in alert.log file.

Regds
Girish
Re: startup problem [message #128399 is a reply to message #127555] Mon, 18 July 2005 06:38 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

sir

when there is corrupted spfile is prsent following message comes

Sat Mar 5 21:04:16 2005
Errors in file /oracle/app/oracle/admin/cfsl/bdump/cfsl_ora_3799.trc:
ORA-00600: internal error code, arguments: [17302], [1], [], [], [], [], [], []


when i created new spfile then following message appears
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)


i also attach alert_cfsl.log file for u r reference
Re: startup problem [message #128401 is a reply to message #128399] Mon, 18 July 2005 06:45 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
The message displayed about db_block_buffers is not an error. Its warning that value specified is below the required minimum & thats why Oracle is taking its own default deined value.

Have you tried to perform a shutdown? Did it occurred cleanly?

Also, try to restart once again with your parameter file & see if any such messages do appear in alert.log file.

Regds
Girish
Re: startup problem [message #128408 is a reply to message #128401] Mon, 18 July 2005 06:58 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

i restarted using pfile but error message comes as
SQL> startup pfile='/oracle/app/oracle/product/10.1.0/db_1/dbs/init.ora'
ORA-01031: insufficient privileges


and in alert.log

The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)

SQL> shut
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Re: startup problem [message #128493 is a reply to message #128408] Mon, 18 July 2005 23:52 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

In your pfile change the value of this parameter db_block_buffers to the value that its taking by default. That way you wont be getting this warning message.

As for the insufficient privileges message, You are logging into SQL Prompt using which user?

Regds
Girish
Re: startup problem [message #128498 is a reply to message #128493] Tue, 19 July 2005 00:09 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

sir

user: sys as sysdba

there are 3 options for db_block_buffers

which option i ve to take as default

i also attach init.ora for u r reference
  • Attachment: init.ora
    (Size: 8.26KB, Downloaded 1490 times)
Re: startup problem [message #128533 is a reply to message #128498] Tue, 19 July 2005 04:52 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

You can use any of the options specified there. Remember, the setting is specified as "no of db blocks". You multiply it with your block size specified in order to get the size of db buffer.

Regds
Girish
Re: startup problem [message #128538 is a reply to message #128533] Tue, 19 July 2005 05:23 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

sir

i ve made new spfile from the backup of pfile

now the instance is started but error comes as follows


startup
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

SQL>
Re: startup problem [message #128655 is a reply to message #128538] Wed, 20 July 2005 00:44 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

Pls paste the alert log info...

Regds
Girish
Re: startup problem [message #128656 is a reply to message #128655] Wed, 20 July 2005 00:50 Go to previous messageGo to next message
nitin_d_csn
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

sir,
no New message comes in alert_cfsl.log file

i ve pasted the file for u r reference
SQL> startup
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


alert_cfsl.log

Sat Mar 5 21:04:16 2005
Errors in file /oracle/app/oracle/admin/cfsl/bdump/cfsl_ora_3799.trc:
ORA-00600: internal error code, arguments: [17302], [1], [], [], [], [], [], []
Mon Mar 7 21:22:52 2005
Errors in file /oracle/app/oracle/admin/cfsl/bdump/cfsl_ora_3907.trc:
ORA-00600: internal error code, arguments: [17302], [1], [], [], [], [], [], []
Sat Mar 19 21:21:24 2005
Errors in file /oracle/app/oracle/admin/cfsl/bdump/cfsl_ora_3614.trc:
ORA-00600: internal error code, arguments: [17302], [1], [], [], [], [], [], []
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
Re: startup problem [message #128672 is a reply to message #128656] Wed, 20 July 2005 01:48 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

If your instance is getting started, then you should be getting entries in the alert log file. Check for the parameter background_dump_dest in the pfile that you do spcify while using startup command. Look into log file at that location.

Also, this time do go step by step... instead of starting database in one go, first issue startup nomount... then alter database to mount & then open stage, meanwhile do continue checking the log file for all new messages/entries.

Regds
Girish
Previous Topic: problem In opening the ports(5500,5560)
Next Topic: Adding New Master Sites Without Quiescing the Master Group for Oracle10g 10.2.0.1 in RHEL AS 4
Goto Forum:
  


Current Time: Fri Mar 29 09:03:21 CDT 2024