Home » RDBMS Server » Server Administration » obsolete and/or deprecated parameter(s)
obsolete and/or deprecated parameter(s) [message #207932] Thu, 07 December 2006 07:35 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
during my 10G instnace startup ...i get follwing

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 847249408 bytes
Fixed Size 2019904 bytes
Variable Size 228658624 bytes
Database Buffers 614400000 bytes
Redo Buffers 2170880 bytes
SQL> select name from v$obsolete_parameter where isspecified='TRUE';

NAME
----------------------------------------------------------------
enqueue_resources
row_locking


i checked in pfile,it is as follows ....
enqueue_resources = 2000
row_locking = always


any idea,wht wrong here
Re: obsolete and/or deprecated parameter(s) [message #207933 is a reply to message #207932] Thu, 07 December 2006 07:44 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
ok i found those are obsolete from 10g .and i commented both.

but i still get same error
ORA-32004: obsolete and/or deprecated parameter(s) specified

SQL> select name from v$obsolete_parameter where isspecified='TRUE';

no rows selected
Re: obsolete and/or deprecated parameter(s) [message #207934 is a reply to message #207933] Thu, 07 December 2006 07:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
post your pfile.
Re: obsolete and/or deprecated parameter(s) [message #207945 is a reply to message #207932] Thu, 07 December 2006 08:23 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
in alert file , i found ...
Deprecated system parameters with specified values:
log_archive_start
max_enabled_roles

and i have values as...
max_enabled_roles = 30
log_archive_start = true
Re: obsolete and/or deprecated parameter(s) [message #207946 is a reply to message #207945] Thu, 07 December 2006 08:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> log_archive_start = true
Depreciated in 10g.
Look into documentation.
As said before in other posting,
DO NOT copy an older version of pfile/spfile
Re: obsolete and/or deprecated parameter(s) [message #207950 is a reply to message #207932] Thu, 07 December 2006 08:37 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks Mahesh .
now i wonder how automatic archive will work in 10g.what parameter in pfile decides that ?
Re: obsolete and/or deprecated parameter(s) [message #207954 is a reply to message #207950] Thu, 07 December 2006 08:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> now i wonder how automatic archive will work in 10g
There is nothing to wonder here.
As said before, everything is already said in documentation.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm#sthref1040
All you need is just to look there. Smile
In 10g, you are supposed to use SPFILE.
PFILE is meant only for very specific purposes.
Re: obsolete and/or deprecated parameter(s) [message #207963 is a reply to message #207932] Thu, 07 December 2006 09:09 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i read the doc ,but stil its not clear about that .

ALTER DATABASE ARCHIVELOG;
i can use to change to auto .but i am using pfile.so how the change take effect next time ?
Re: obsolete and/or deprecated parameter(s) [message #207970 is a reply to message #207963] Thu, 07 December 2006 10:19 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

Before 10g for archive we have to specify two thing.

1.is parameter
2. in alter database archivelog ( for enable)

but in 10g we have to user only enable or disable through alter database sttatement.

SQL> startup pfile=d:\oracle\product\10.1.0\db_2\database\initorcl.ora
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount pfile=d:\oracle\product\10.1.0\db_2\database\initorcl.ora
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     208
Current log sequence           210
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup  pfile=d:\oracle\product\10.1.0\db_2\database\initorcl.ora
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     208
Next log sequence to archive   210
Current log sequence           210
SQL>




regards
Taj
Re: obsolete and/or deprecated parameter(s) [message #207974 is a reply to message #207932] Thu, 07 December 2006 10:43 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Taj, what is your first point ?
can i set that in parameter file.i am using only pfile no spfile.
Re: obsolete and/or deprecated parameter(s) [message #207975 is a reply to message #207974] Thu, 07 December 2006 10:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
All you need to specify is LOG_ARCHIVE_DEST.
LOG_ARCHIVE_START is no more used.
As said in documentation
when you issue
sql> ALTER DATABASE ARCHIVELOG;

it is all done for you.

>>so how the change take effect next time
Just shutdown and startup.

[Updated on: Thu, 07 December 2006 10:54]

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207976 is a reply to message #207932] Thu, 07 December 2006 10:55 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
so the conclusion is that there is no way to start a database in archivemode using a pfile.
Re: obsolete and/or deprecated parameter(s) [message #207978 is a reply to message #207976] Thu, 07 December 2006 10:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
so the conclusion is that there is no way to start a database in archivemode using a pfile.

Where and how did you conclude it?
You can start the database with PFILE or SPFILE.
only the parameter LOG_ARCHIVE_START is no more available.
Re: obsolete and/or deprecated parameter(s) [message #207979 is a reply to message #207932] Thu, 07 December 2006 11:10 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i am confused.
can we start a datase in archive mode using only pfile ?(the database should comeup in automatically in arvhice mode,when we issue "startup" )
i mean to say there is no spfile.but only pfile
Re: obsolete and/or deprecated parameter(s) [message #207980 is a reply to message #207979] Thu, 07 December 2006 11:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>can we start a datase in archive mode using only pfile
Yes.
Re: obsolete and/or deprecated parameter(s) [message #207981 is a reply to message #207932] Thu, 07 December 2006 11:17 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
if pfile dont have any LOG_ARCHIVE_START value,how it will come in archive mode when we issue STARTUP ?
by default it comeup in NOARCHIVE MODE .

Mahesh can you please make your point clear Smile
Re: obsolete and/or deprecated parameter(s) [message #207982 is a reply to message #207981] Thu, 07 December 2006 11:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you atleast try any of those above?
By default STARTUP will only refer to SPFILE.
If you want your PFILE to be used,
you need use
sql>startup pfile='yourpfile' (as User52 has already said).

You no need to specify archive_log_start.
>>value,how it will come in archive mode when we issue STARTUP ?
Initially, you have to do this.
SQL> STARTUP PFILE 'YOURpfile';
sql> ALTER DATABASE ARCHIVELOG;
sql> ALTER DATABASE OPEN;
sql> shutdown.


next time you startup (with pfile), everything is all set for you.
User52 has already provided the same in example.
Did you fail to read it?
Re: obsolete and/or deprecated parameter(s) [message #207983 is a reply to message #207982] Thu, 07 December 2006 11:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look into User52's post.
First
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled

Then he issues
SQL> alter database archivelog;

followed by
SQL> alter database open;
SQL> shutdown immediate;
SQL> startup  pfile=d:\oracle\product\10.1.0\db_2\database\initorcl.ora

Now
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled


Re: obsolete and/or deprecated parameter(s) [message #207986 is a reply to message #207932] Thu, 07 December 2006 11:43 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
>>next time you startup (with pfile), everything is all set for you.

where this info is recorded ?

>>By default STARTUP will only refer to SPFILE
if SPFILE is not there,it wil go for PFILE.

Please correct me if i am wrong
Re: obsolete and/or deprecated parameter(s) [message #207995 is a reply to message #207986] Thu, 07 December 2006 13:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>where this info is recorded ?
Again quoting the same link we poste early.

Quote:
Changing the database archiving mode updates the control file.

All the corresponding information is stored in control file.

>>if SPFILE is not there,it wil go for PFILE.
Quoting the same documentation, different section
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#i1009971
Quote:

When you issue a STARTUP command with no PFILE clause, the Oracle instance searches an operating system
specific default location for a server parameter file from which to read initialization parameter
settings. If no server parameter file is found, the instance searches for a text initialization
parameter file. If a server parameter file exists but you want to override it with settings in a
text initialization parameter file, you must specify the PFILE clause when issuing the STARTUP command.

Re: obsolete and/or deprecated parameter(s) [message #208157 is a reply to message #207932] Fri, 08 December 2006 06:36 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
>>Changing the database archiving mode updates the control file.

that cleared all my doubts.Thanks everybody
thanks Mahesh
Previous Topic: SHUTDOWN: Active sessions prevent database close operation
Next Topic: Default tablespace
Goto Forum:
  


Current Time: Mon Dec 05 15:20:36 CST 2016

Total time taken to generate the page: 0.10024 seconds