OraFAQ Forum: Server Administration » Error While Starting Database

Home » RDBMS Server » Server Administration » Error While Starting Database (Oracle Database 10g Release 10.2.0.1.0 - 64bit Production)

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

Error While Starting Database [message #530617]

Wed, 09 November 2011 06:19

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Hai,

Iam getting the following error while starting database.

ORA-32004:obsolete and/or deprecated parameter(s) specified

Regards,
Paules

Report message to a moderator

Re: Error While Starting Database [message #530618 is a reply to message #530617]

Wed, 09 November 2011 06:25

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

So check the list of parameters specified in your init.ora or sp file. Compare list against the list of parameters in the documentation for your version. See which ones are no longer listed. Remove those parameters.

Report message to a moderator

Re: Error While Starting Database [message #530620 is a reply to message #530618]

Wed, 09 November 2011 06:38

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

SELECT name FROM v$parameter WHERE isdeprecated = 'TRUE'; 
output::
NAME

lock_name_space
buffer_pool_keep
buffer_pool_recycle
max_commit_propagation_delay
remote_archive_enable
log_archive_start
parallel_server
parallel_server_instances
fast_start_io_target
logmnr_max_persistent_sessions
serial_reuse
max_enabled_roles
global_context_pool_size
plsql_compiler_flags
sql_trace
parallel_automatic_tuning
drs_start

Is the Issue is with these parameters?
Regards,
Paules

Report message to a moderator

Re: Error While Starting Database [message #530623 is a reply to message #530620]

Wed, 09 November 2011 06:47

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You will find in the alert.log the list of obsolete parameters that Oracle no more wants.

Regards
Michel

Report message to a moderator

Re: Error While Starting Database [message #530638 is a reply to message #530623]

Wed, 09 November 2011 08:16

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

If I execute the following statement, can I able to resolve this error?

alter system reset log_archive_start scope=spfile sid='*' ;

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530642 is a reply to message #530638]

Wed, 09 November 2011 08:31

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Since we don't know what the DB is actually complaining about, how would we know?

Report message to a moderator

Re: Error While Starting Database [message #530646 is a reply to message #530642]

Wed, 09 November 2011 08:34

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Today I made two changes ::

alter system set max_commit_propagation_delay=700 scope=spfile;
alter system set dml_locks=3440 scope =spfile;

Then while restarting I faced that error. This is a warning error?or something critical?

Regards,
Paules

Report message to a moderator

Re: Error While Starting Database [message #530648 is a reply to message #530646]

Wed, 09 November 2011 08:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Then while restarting I faced that error. This is a warning error?or something critical?
additional clues exist with alert_SID.log file

Report message to a moderator

Re: Error While Starting Database [message #530650 is a reply to message #530648]

Wed, 09 November 2011 08:39

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Where is this file?How to check it?
Regards,
Paules

Report message to a moderator

Re: Error While Starting Database [message #530655 is a reply to message #530650]

Wed, 09 November 2011 08:46

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In the directory pointed by your parameter background_dump_dest.

Regards
Michel

Report message to a moderator

Re: Error While Starting Database [message #530710 is a reply to message #530655]

Wed, 09 November 2011 23:40

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Posting the content of the alert log file at the time of starting the database.

Wed Nov  9 13:04:10 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2073K exceeds notification threshold (2048K)
KGL object name :    SELECT count(*) INTO :num_valid_specs    FROM  all_objects    WHERE object_name = 'DBMS_DEBUG'    AND   owner = 'SYS'    AND   object_type = 'PACKAGE'    AND   status = 'VALID'
Wed Nov  9 13:11:18 2011
ALTER SYSTEM SET max_commit_propagation_delay=700 SCOPE=SPFILE;
Wed Nov  9 13:11:29 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2227K exceeds notification threshold (2048K)
Details in trace file /u01/app/oracle/admin/ORCL/udump/orcl_ora_26850.trc
KGL object name :Select owner, object_type  from sys.all_objects where object_name = :ObjName 
 and owner = :OwnerName 
 order by 2 DESC
Wed Nov  9 13:26:05 2011
Starting background process EMN0
EMN0 started with pid=23, OS id=30080
Wed Nov  9 13:26:05 2011
Shutting down instance: further logons disabled
Wed Nov  9 13:26:05 2011
Stopping background process CJQ0
Wed Nov  9 13:26:05 2011
Stopping background process QMNC
Wed Nov  9 13:26:06 2011
Stopping background process MMNL
Wed Nov  9 13:26:07 2011
Stopping background process MMON
Wed Nov  9 13:26:08 2011
Errors in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_30077.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-12663: Services required by client not available on the server
ORA-36961: Oracle OLAP is not available.
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 15
Wed Nov  9 13:26:08 2011
Shutting down instance (immediate)
License high water mark = 149
Wed Nov  9 13:26:08 2011
Stopping Job queue slave processes
Wed Nov  9 13:26:08 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Nov  9 13:26:20 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:26:32 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:26:44 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:26:56 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:27:08 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:27:20 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:27:32 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:27:43 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:27:55 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:28:07 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:28:18 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:28:30 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:28:41 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:28:53 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:29:04 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:29:16 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:29:27 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:29:38 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:29:50 2011
PMON failed to acquire latch, see PMON dump
Wed Nov  9 13:32:23 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =61
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 500
  sessions                 = 555
  __shared_pool_size       = 218103808
  __large_pool_size        = 16777216
  __java_pool_size         = 16777216
  __streams_pool_size      = 0
  sga_target               = 1224736768
  control_files            = /u02/oradata/ORCL/control01.ctl, /u02/oradata/ORCL/control02.ctl, /u02/oradata/ORCL/control03.ctl
  db_block_size            = 8192
  __db_cache_size          = 956301312
  max_commit_propagation_delay= 700
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /u01/app/oracle/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  dml_locks                = 3440
  transactions             = 610
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
  utl_file_dir             = /u03/ORALOAD
  job_queue_processes      = 10
  background_dump_dest     = /u01/app/oracle/admin/ORCL/bdump
  user_dump_dest           = /u01/app/oracle/admin/ORCL/udump
  core_dump_dest           = /u01/app/oracle/admin/ORCL/cdump
  audit_file_dest          = /u01/app/oracle/admin/ORCL/adump
  db_name                  = ORCL
  open_cursors             = 3000
  pga_aggregate_target     = 402653184
Deprecated system parameters with specified values:
  max_commit_propagation_delay
End of deprecated system parameter listing

Reagrds,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530714 is a reply to message #530710]

Thu, 10 November 2011 00:09

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I see dead pixels. Oooops! I see some deprecated system parameters. You?

Report message to a moderator

Re: Error While Starting Database [message #530716 is a reply to message #530714]

Thu, 10 November 2011 00:29

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Please Kindly advice how to resolve.

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530720 is a reply to message #530716]

Thu, 10 November 2011 00:44

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One of changes you did yesterday was

alter system set max_commit_propagation_delay=700 scope=spfile;

Log file says:

Deprecated system parameters with specified values:
  max_commit_propagation_delay
End of deprecated system parameter listing

What do you think?

Report message to a moderator

Re: Error While Starting Database [message #530721 is a reply to message #530720]

Thu, 10 November 2011 00:46

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

I think max_commit_propagation_delay is the Depreciated parameter. How to remove it?

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530723 is a reply to message #530716]

Thu, 10 November 2011 00:52

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

alter system set max_commit_propagation_delay=700 scope=spfile;

This is the problem.
Remove this condition from Your <Pfile>/<Spfile>.

alter system reset max_commit_propagation_delay scope=spfile sid='*' ;

and restart you instance

Report message to a moderator

Re: Error While Starting Database [message #530727 is a reply to message #530723]

Thu, 10 November 2011 01:09

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Just wondering: how come you (Paules) run these ALTER SYSTEM statements just like that? Obviously, because you are privileged. But, what was the reason? What did you mean to achieve? What problem were you trying to solve? Do you not read the documentation related to your own database version?

Report message to a moderator

Re: Error While Starting Database [message #530728 is a reply to message #530638]

Thu, 10 November 2011 01:13

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Paules wrote on Wed, 09 November 2011 19:46

If I execute the following statement, can I able to resolve this error?
alter system reset log_archive_start scope=spfile sid='*' ;
Regards,
Paules.

By Looking at the above post..I think he is just reading Blogs whenever he got a problem But not even try to understand it.
http://www.oraclekonsulent.dk/en/index.php?blog_id=114

Sriram

Report message to a moderator

Re: Error While Starting Database [message #530729 is a reply to message #530727]

Thu, 10 November 2011 01:14

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Apologies, If I have done mistake. My aim is to solve one Issue ::
While more number of users are working in the database, it is creating blocking sessions. Iam trying to solve this issue.Please guide me.

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530730 is a reply to message #530729]

Thu, 10 November 2011 01:19

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

it is creating blocking sessions

Did you verified..why the sessions blocked by others ? and they are waiting for which resource ?
I suggest you to read Oracle documents first.It will really help you.

Sriram

Report message to a moderator

Re: Error While Starting Database [message #530732 is a reply to message #530730]

Thu, 10 November 2011 01:23

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

While more than one users are trying to do DML statements , session blocking occuring.

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530736 is a reply to message #530732]

Thu, 10 November 2011 01:28

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Expected behaviour, you already have been answered non this point.
Read your previous topic Database Blocking Lock
and do NOT pollute this one with the previous question.

Regards
Michel

Report message to a moderator

Re: Error While Starting Database [message #530742 is a reply to message #530736]

Thu, 10 November 2011 02:21

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Is it require to apply this statement immediately and restart the instance? Or I can do it after two days? (Since it is a Live database Iam asking u)

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #530743 is a reply to message #530742]

Thu, 10 November 2011 02:31

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do it what you need it.

Regards
Michel

Report message to a moderator

Re: Error While Starting Database [message #531088 is a reply to message #530743]

Sun, 13 November 2011 04:57

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Thank u all. Resolved the Issues.

Regards,
Paules.

Report message to a moderator

Re: Error While Starting Database [message #531095 is a reply to message #531088]

Sun, 13 November 2011 06:13

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How?

Regards
Michel

Report message to a moderator

Previous Topic:	Database Blocking Lock
Next Topic:	How to avoid the clear password in checkpoint file with oracle DBCA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 10:20:46 CDT 2024