OraFAQ Forum: Linux » startup problem

Home » Infrastructure » Linux » startup problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

startup problem [message #127555]

Tue, 12 July 2005 03:46

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

Report message to a moderator

Re: startup problem [message #127564 is a reply to message #127555]

Tue, 12 July 2005 04:48

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Can you edit the file?

Best regards.

Frank

Report message to a moderator

Re: startup problem [message #127565 is a reply to message #127564]

Tue, 12 July 2005 04:50

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

Report message to a moderator

Re: startup problem [message #127566 is a reply to message #127565]

Tue, 12 July 2005 04:54

Frank Naude
Messages: 4587
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

Report message to a moderator

Re: startup problem [message #127568 is a reply to message #127566]

Tue, 12 July 2005 05:00

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

Report message to a moderator

Re: startup problem [message #127614 is a reply to message #127568]

Tue, 12 July 2005 09:12

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

Report message to a moderator

Re: startup problem [message #127724 is a reply to message #127614]

Wed, 13 July 2005 01:01

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

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

Report message to a moderator

Re: startup problem [message #127957 is a reply to message #127735]

Thu, 14 July 2005 06:28

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

Report message to a moderator

Re: startup problem [message #128398 is a reply to message #127957]

Mon, 18 July 2005 06:29

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

Report message to a moderator

Re: startup problem [message #128399 is a reply to message #127555]

Mon, 18 July 2005 06:38

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

Attachment: alert_cfsl.log
(Size: 4.83KB, Downloaded 2058 times)

Report message to a moderator

Re: startup problem [message #128401 is a reply to message #128399]

Mon, 18 July 2005 06:45

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

Report message to a moderator

Re: startup problem [message #128408 is a reply to message #128401]

Mon, 18 July 2005 06:58

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

Report message to a moderator

Re: startup problem [message #128493 is a reply to message #128408]

Mon, 18 July 2005 23:52

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

Report message to a moderator

Re: startup problem [message #128498 is a reply to message #128493]

Tue, 19 July 2005 00:09

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 1827 times)

Report message to a moderator

Re: startup problem [message #128533 is a reply to message #128498]

Tue, 19 July 2005 04:52

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

Report message to a moderator

Re: startup problem [message #128538 is a reply to message #128533]

Tue, 19 July 2005 05:23

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>

Report message to a moderator

Re: startup problem [message #128655 is a reply to message #128538]

Wed, 20 July 2005 00:44

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi

Pls paste the alert log info...

Regds
Girish

Report message to a moderator

Re: startup problem [message #128656 is a reply to message #128655]

Wed, 20 July 2005 00:50

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)

Report message to a moderator

Re: startup problem [message #128672 is a reply to message #128656]

Wed, 20 July 2005 01:48

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 08:43:23 CST 2025