OraFAQ Forum: Server Administration » ORA-16019.....................

Home » RDBMS Server » Server Administration » ORA-16019.....................

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

ORA-16019..................... [message #259731]

Thu, 16 August 2007 06:26

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi,
First i like to thank all of you for helping me when i was in trouble.
Here i am with one more question.
I wanted to set 3 archive detination which is LOCAL, so i setted it using ALTER SYSTEM as follows:-

SQL> alter system set log_archive_dest='C:\oracle\admin\Chandu\Arch';
System altered.

SQL> sho parameter log_archive_dest;

NAME                 TYPE                 VALUE
-----------------  ----------   ----------------------------
log_archive_dest    string        C:\oracle\admin\Chandu\Arch


SQL> alter system set log_archive_duplex_dest='F:\Archived';
System altered.

SQL> sho parameter log_archive_duplex_dest;

NAME                            TYPE         VALUE
--------------------------   ------------  ------------------
log_archive_duplex_dest        string        F:\Archived

But when i tried to set 3rd Archive destination i got ORA-16019 Error.

SQL> alter system set log_archive_dest_1='E:\Archived';
alter system set log_archive_dest_1='E:\Archived'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST

Question:-
1) I think according to the error i cant use LOG_ARCHIVE_DEST_n with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST, why cant i use it with those two of them, then how can i set the 3rd archive destination?

2) How to set MANDATORY or OPTIONAL for:-
LOG_ARCHIVE_DEST, LOG_ARCHIVE_DUPLEX_DEST, LOG_ARCHIVE_DEST_n

Regards,
Naveen

[Updated on: Thu, 16 August 2007 09:54] by Moderator

Report message to a moderator

Re: ORA-16019..................... [message #259752 is a reply to message #259731]

Thu, 16 August 2007 06:59

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I even don't read your topic as you continue to refuse to format your post and follow the stickies.

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259783 is a reply to message #259731]

Thu, 16 August 2007 08:58

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Raymond Wauben,

Thank you Raymond Wauben the document which u have sent is really nice it helped me a lot.

In that document it has given that if we need to set archive destination to OPTIONAL or MANDATORY we need to use
LOG_ARCHIVE_DEST_n

But how can i set again it to OPTIONAL (the default) or MANDATORY because i already setted value for LOG_ARCHIVE_DEST_1='C:\oracle\admin\Chandu\Arch'
LOG_ARCHIVE_DEST_2='F:\Archived'
LOG_ARCHIVE_DEST_3='E:\Archived'

Please help me how to set OPTIONAL or MANDATORY to these 3 archive destination and also to LOG_ARCHIVE_DEST, LOG_ARCHIVE_DUPLEX_DEST

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259784 is a reply to message #259783]

Thu, 16 August 2007 09:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no Raymond Wauben here.

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259789 is a reply to message #259752]

Thu, 16 August 2007 09:11

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

"I even don't read your topic as you continue to refuse to format your post and follow the stickies".

I am not understanding about your last reply please make it clear.

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259794 is a reply to message #259789]

Thu, 16 August 2007 09:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Does my last reply the one you quoted or the last I wrote?

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259795 is a reply to message #259789]

Thu, 16 August 2007 09:22

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

"I even don't read your topic as you continue to refuse to format your post and follow the stickies".

I am not understanding the above sentence please make it clear.

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259797 is a reply to message #259795]

Thu, 16 August 2007 09:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Forgot: Server Administration Posting Guidelines

Regards
Michel

[Updated on: Thu, 16 August 2007 09:27]

Report message to a moderator

Re: ORA-16019..................... [message #259802 is a reply to message #259797]

Thu, 16 August 2007 09:52

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

Thanks a lot Michel i dint knew that. I will follow that rules when posting new topics.

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259804 is a reply to message #259802]

Thu, 16 August 2007 09:56

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK point taken and first message updated.

You can't use at the same time log_archive_dest/log_archive_duplex_dest and log_archive_dest_n parameters.
You can't use mandatory/optional options on log_archive_dest and log_archive_duplex_dest, you can use it only on log_archive_dest_n.

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259809 is a reply to message #259804]

Thu, 16 August 2007 10:29

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi,

I am not using any stand by database. I am archiving it to local destination. My database version is 9.0.1.1.1

I have setted archive destinations as:-


ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/archive MANDATORY' scope=spfile;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/archive MANDATORY' scope=spfile;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/archive OPTIONAL' scope=spfile;

When i tried to restart the database i got following error:-

SQL> startup;
ORA-00439: feature not enabled: Managed Standby

I searched in net about this error but i dint understood. Please guide me.

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259827 is a reply to message #259809]

Thu, 16 August 2007 11:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post: "show parameter archive" and "show parameter standby".

Do you have Entreprise Edition or Standard Edition?
In SE you can have only one destination.

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259852 is a reply to message #259827]

Thu, 16 August 2007 12:40

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

I have attached a file which contains information about "show parameter archive" and "show parameter standby" .

I am sorry i had installed oracle 2 moths back i was not knowing much about edition at that time. But when i searched in net how to find out standard edition or enterprise edition i got little information on that and is as follows:-



SQL> SELECT * FROM v$version;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE    9.0.1.1.1       Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production

But looking at this output i was not able to undertsand which edition i am using.
Please guide me.

Regards,
Naveen

Attachment: Archive_Dest.txt
(Size: 2.21KB, Downloaded 1162 times)

Report message to a moderator

Re: ORA-16019..................... [message #259855 is a reply to message #259731]

Thu, 16 August 2007 12:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

 SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

10:53:14 SQL>

Notice the difference?

Report message to a moderator

Re: ORA-16019..................... [message #259856 is a reply to message #259827]

Thu, 16 August 2007 12:54

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

I had changed the archive destination using SCOPE=spfile so when i started the database i got the error.

The file i had attached previously contains information from pfile that i had created it before creating spfile.

So i am attaching a new pfile file which i created from spfile. It contains archive destination information.
and when i run that pfile i got this error:-


SQL> startup 'C:\oracle\admin\Chandu\pfile\Second.ora';
SP2-0714: invalid combination of STARTUP options

Regards,
Naveen

Attachment: Second.ora
(Size: 1.05KB, Downloaded 1020 times)

Report message to a moderator

Re: ORA-16019..................... [message #259861 is a reply to message #259852]

Thu, 16 August 2007 13:15

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have a standard edition, forget the multiple log_archive_dest_n.

[Sorry Ana, didn't see your answer]

Regards
Michel

[Updated on: Thu, 16 August 2007 13:16]

Report message to a moderator

Re: ORA-16019..................... [message #259862 is a reply to message #259856]

Thu, 16 August 2007 13:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"startup" command is explained in details in Chapter 3 of Administrator's guide.

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259866 is a reply to message #259862]

Thu, 16 August 2007 13:21

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Michel,

From this how can i know whether i am using Standard or Enterprise Edition.


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259868 is a reply to message #259866]

Thu, 16 August 2007 13:23

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Enterprise Edition Release 10.2.0.2.0

Report message to a moderator

Re: ORA-16019..................... [message #259873 is a reply to message #259868]

Thu, 16 August 2007 13:34

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi DreamzZ,
Sorry i typed 10G version in previous message.

From this how can i know whether i am using Standard or Enterprise Edition. Please explain.


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE    9.0.1.1.1       Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259877 is a reply to message #259873]

Thu, 16 August 2007 13:58

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you read all the previous answer from Ana, DreamzZ and me?
We already answered you 3 times.

Regards
Michel

Report message to a moderator

Re: ORA-16019..................... [message #259887 is a reply to message #259873]

Thu, 16 August 2007 14:27

amansharma81
Messages: 8
Registered: June 2005
Location: India

Junior Member

Hi Naveen,
I have asked the same question to you on the other forum where you posted this question that are you on EE or SE and replied too.You can check there.
To find the difference in 9i EE or SE, I guess this output may make it clear.

A select from v$version in 9i SE returns:

> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Release 9.2.0.1.0 - Production

And in 9i EE,

SQL> select * from v$version;

BANNER
-----------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

Hope it will help.
Cheers,
Aman....

Report message to a moderator

Re: ORA-16019..................... [message #259889 is a reply to message #259877]

Thu, 16 August 2007 14:29

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi,
I had read all the replies but i had a doubt as how to find it is Standard or Enterprise Edition.


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g [B]Enterprise Edition[/B] Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE    9.0.1.1.1       Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production

Is this correct if there is Enterprise Edition in Banner means it is "Enterprise Edition" otherwise it is "Standard Edition"

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259890 is a reply to message #259889]

Thu, 16 August 2007 14:31

amansharma81
Messages: 8
Registered: June 2005
Location: India

Junior Member

Hi Naveen,
If you see the output that I show you just now,it makes it clear,with EE,it says Enterprise Edition.
Cheers,
Aman....

Report message to a moderator

Re: ORA-16019..................... [message #259891 is a reply to message #259887]

Thu, 16 August 2007 14:32

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi Amansharma,

Thank you, now i got how to find is it Standard or Enterprise Edition.

Regards,
Naveen

Report message to a moderator

Re: ORA-16019..................... [message #259892 is a reply to message #259891]

Thu, 16 August 2007 14:35

amansharma81
Messages: 8
Registered: June 2005
Location: India

Junior Member

Good

Smile

Cheers,
Aman....

Report message to a moderator

Previous Topic:	How doese oracle work when getting some cols from database
Next Topic:	How to modify the existing un-partitioned indexes to partitioned indexes on partitioned tables?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:32:59 CST 2024