Home » RDBMS Server » Server Administration » ORA-16019.....................
ORA-16019..................... [message #259731] Thu, 16 August 2007 06:26 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-16019..................... [message #259783 is a reply to message #259731] Thu, 16 August 2007 08:58 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259784 is a reply to message #259783] Thu, 16 August 2007 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no Raymond Wauben here.

Regards
Michel
Re: ORA-16019..................... [message #259789 is a reply to message #259752] Thu, 16 August 2007 09:11 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259794 is a reply to message #259789] Thu, 16 August 2007 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does my last reply the one you quoted or the last I wrote?

Regards
Michel
Re: ORA-16019..................... [message #259795 is a reply to message #259789] Thu, 16 August 2007 09:22 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259797 is a reply to message #259795] Thu, 16 August 2007 09:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259804 is a reply to message #259802] Thu, 16 August 2007 09:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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


Re: ORA-16019..................... [message #259809 is a reply to message #259804] Thu, 16 August 2007 10:29 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259827 is a reply to message #259809] Thu, 16 August 2007 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-16019..................... [message #259852 is a reply to message #259827] Thu, 16 August 2007 12:40 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259855 is a reply to message #259731] Thu, 16 August 2007 12:53 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: ORA-16019..................... [message #259856 is a reply to message #259827] Thu, 16 August 2007 12:54 Go to previous messageGo to next message
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 158 times)
Re: ORA-16019..................... [message #259861 is a reply to message #259852] Thu, 16 August 2007 13:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"startup" command is explained in details in Chapter 3 of Administrator's guide.

Regards
Michel
Re: ORA-16019..................... [message #259866 is a reply to message #259862] Thu, 16 August 2007 13:21 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259868 is a reply to message #259866] Thu, 16 August 2007 13:23 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Enterprise Edition Release 10.2.0.2.0
Re: ORA-16019..................... [message #259873 is a reply to message #259868] Thu, 16 August 2007 13:34 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259877 is a reply to message #259873] Thu, 16 August 2007 13:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read all the previous answer from Ana, DreamzZ and me?
We already answered you 3 times.

Regards
Michel
Re: ORA-16019..................... [message #259887 is a reply to message #259873] Thu, 16 August 2007 14:27 Go to previous messageGo to next message
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....
Re: ORA-16019..................... [message #259889 is a reply to message #259877] Thu, 16 August 2007 14:29 Go to previous messageGo to next message
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

Re: ORA-16019..................... [message #259890 is a reply to message #259889] Thu, 16 August 2007 14:31 Go to previous messageGo to next message
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....
Re: ORA-16019..................... [message #259891 is a reply to message #259887] Thu, 16 August 2007 14:32 Go to previous messageGo to next message
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
Re: ORA-16019..................... [message #259892 is a reply to message #259891] Thu, 16 August 2007 14:35 Go to previous message
amansharma81
Messages: 8
Registered: June 2005
Location: India
Junior Member

Good Smile
Cheers,
Aman....
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:
  


Current Time: Thu Dec 08 20:27:31 CST 2016

Total time taken to generate the page: 0.05803 seconds