Home » RDBMS Server » Server Administration » Error While Starting Database (Oracle Database 10g Release 10.2.0.1.0 - 64bit Production)
Error While Starting Database [message #530617] Wed, 09 November 2011 06:19 Go to next message
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
Re: Error While Starting Database [message #530618 is a reply to message #530617] Wed, 09 November 2011 06:25 Go to previous messageGo to next message
cookiemonster
Messages: 10961
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.
Re: Error While Starting Database [message #530620 is a reply to message #530618] Wed, 09 November 2011 06:38 Go to previous messageGo to next message
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
Re: Error While Starting Database [message #530623 is a reply to message #530620] Wed, 09 November 2011 06:47 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
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
Re: Error While Starting Database [message #530638 is a reply to message #530623] Wed, 09 November 2011 08:16 Go to previous messageGo to next message
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.
Re: Error While Starting Database [message #530642 is a reply to message #530638] Wed, 09 November 2011 08:31 Go to previous messageGo to next message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
Since we don't know what the DB is actually complaining about, how would we know?
Re: Error While Starting Database [message #530646 is a reply to message #530642] Wed, 09 November 2011 08:34 Go to previous messageGo to next message
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
Re: Error While Starting Database [message #530648 is a reply to message #530646] Wed, 09 November 2011 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 22787
Registered: January 2009
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
Re: Error While Starting Database [message #530650 is a reply to message #530648] Wed, 09 November 2011 08:39 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Where is this file?How to check it?
Regards,
Paules
Re: Error While Starting Database [message #530655 is a reply to message #530650] Wed, 09 November 2011 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the directory pointed by your parameter background_dump_dest.

Regards
Michel
Re: Error While Starting Database [message #530710 is a reply to message #530655] Wed, 09 November 2011 23:40 Go to previous messageGo to next message
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.
Re: Error While Starting Database [message #530714 is a reply to message #530710] Thu, 10 November 2011 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see dead pixels. Oooops! I see some deprecated system parameters. You?
Re: Error While Starting Database [message #530716 is a reply to message #530714] Thu, 10 November 2011 00:29 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Please Kindly advice how to resolve.

Regards,
Paules.
Re: Error While Starting Database [message #530720 is a reply to message #530716] Thu, 10 November 2011 00:44 Go to previous messageGo to next message
Littlefoot
Messages: 19608
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?
Re: Error While Starting Database [message #530721 is a reply to message #530720] Thu, 10 November 2011 00:46 Go to previous messageGo to next message
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.
Re: Error While Starting Database [message #530723 is a reply to message #530716] Thu, 10 November 2011 00:52 Go to previous messageGo to next message
ramoradba
Messages: 2452
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
Re: Error While Starting Database [message #530727 is a reply to message #530723] Thu, 10 November 2011 01:09 Go to previous messageGo to next message
Littlefoot
Messages: 19608
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?
Re: Error While Starting Database [message #530728 is a reply to message #530638] Thu, 10 November 2011 01:13 Go to previous messageGo to next message
ramoradba
Messages: 2452
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
Re: Error While Starting Database [message #530729 is a reply to message #530727] Thu, 10 November 2011 01:14 Go to previous messageGo to next message
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.
Re: Error While Starting Database [message #530730 is a reply to message #530729] Thu, 10 November 2011 01:19 Go to previous messageGo to next message
ramoradba
Messages: 2452
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
Re: Error While Starting Database [message #530732 is a reply to message #530730] Thu, 10 November 2011 01:23 Go to previous messageGo to next message
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.
Re: Error While Starting Database [message #530736 is a reply to message #530732] Thu, 10 November 2011 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
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

Re: Error While Starting Database [message #530742 is a reply to message #530736] Thu, 10 November 2011 02:21 Go to previous messageGo to next message
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.
Re: Error While Starting Database [message #530743 is a reply to message #530742] Thu, 10 November 2011 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it what you need it.

Regards
Michel
Re: Error While Starting Database [message #531088 is a reply to message #530743] Sun, 13 November 2011 04:57 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Thank u all. Resolved the Issues.

Regards,
Paules.
Re: Error While Starting Database [message #531095 is a reply to message #531088] Sun, 13 November 2011 06:13 Go to previous message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How?

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


Current Time: Wed Sep 17 20:42:26 CDT 2014

Total time taken to generate the page: 0.14181 seconds