OraFAQ Forum: Server Administration » obsolete and/or deprecated parameter(s)

Home » RDBMS Server » Server Administration » obsolete and/or deprecated parameter(s)

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

obsolete and/or deprecated parameter(s) [message #207932]

Thu, 07 December 2006 07:35

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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207933 is a reply to message #207932]

Thu, 07 December 2006 07:44

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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207934 is a reply to message #207933]

Thu, 07 December 2006 07:45

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

post your pfile.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207945 is a reply to message #207932]

Thu, 07 December 2006 08:23

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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207946 is a reply to message #207945]

Thu, 07 December 2006 08:25

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207950 is a reply to message #207932]

Thu, 07 December 2006 08:37

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 ?

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207954 is a reply to message #207950]

Thu, 07 December 2006 08:41

Mahesh Rajendran
Messages: 10707
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

Smile

In 10g, you are supposed to use SPFILE.
PFILE is meant only for very specific purposes.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207963 is a reply to message #207932]

Thu, 07 December 2006 09:09

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 ?

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207970 is a reply to message #207963]

Thu, 07 December 2006 10:19

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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207974 is a reply to message #207932]

Thu, 07 December 2006 10:43

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.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207975 is a reply to message #207974]

Thu, 07 December 2006 10:54

Mahesh Rajendran
Messages: 10707
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

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.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207978 is a reply to message #207976]

Thu, 07 December 2006 10:57

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207979 is a reply to message #207932]

Thu, 07 December 2006 11:10

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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207980 is a reply to message #207979]

Thu, 07 December 2006 11:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>can we start a datase in archive mode using only pfile
Yes.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207981 is a reply to message #207932]

Thu, 07 December 2006 11:17

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

Smile

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207982 is a reply to message #207981]

Thu, 07 December 2006 11:23

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207983 is a reply to message #207982]

Thu, 07 December 2006 11:27

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207986 is a reply to message #207932]

Thu, 07 December 2006 11:43

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

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #207995 is a reply to message #207986]

Thu, 07 December 2006 13:39

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: obsolete and/or deprecated parameter(s) [message #208157 is a reply to message #207932]

Fri, 08 December 2006 06:36

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

Report message to a moderator

Previous Topic:	SHUTDOWN: Active sessions prevent database close operation
Next Topic:	Default tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:38:27 CDT 2024