OraFAQ Forum: Server Administration » Error ORA-47306 causing error for Checkpoint

Home » RDBMS Server » Server Administration » Error ORA-47306 causing error for Checkpoint (Oracle 11.2.0.4 on Linux)

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

Error ORA-47306 causing error for Checkpoint [message #643070]

Mon, 28 September 2015 06:02

orapratap
Messages: 134
Registered: November 2011
Location: Canada

Senior Member

Hello

We are getting "ORA-47306" for following which thus is completing the checkpoint

Not getting much information on "ORA-47306" for Oracle 11.2, on Metalink too

Any directions please?

SQL> alter system checkpoint;
alter system checkpoint
*
ERROR at line 1:
ORA-47306: 4067:


SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-47306: 4067:


SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-47306: 4067:

Thanks and Regards
Orapratap

Report message to a moderator

Re: Error ORA-47306 causing error for Checkpoint [message #643071 is a reply to message #643070]

Mon, 28 September 2015 06:18

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

Senior Member
Account Moderator

Is this a DB Vault install?

Report message to a moderator

Re: Error ORA-47306 causing error for Checkpoint [message #643073 is a reply to message #643071]

Mon, 28 September 2015 06:33

orapratap
Messages: 134
Registered: November 2011
Location: Canada

Senior Member

Many Thanks Michel

Yes, looks like Vault is enabled on the database


SQL> SELECT comp_name, version, status FROM dba_registry;

COMP_NAME                                          VERSION                        STATUS
-------------------------------------------------- ------------------------------ --------------------------------------------
Oracle Database Vault                              11.2.0.4.0                     VALID
Oracle XML Database                                11.2.0.4.0                     INVALID
Oracle Label Security                              11.2.0.4.0                     VALID
Oracle Database Catalog Views                      11.2.0.4.0                     VALID
Oracle Database Packages and Types                 11.2.0.4.0                     VALID

SQL> select * from v$option where parameter ='Oracle Database Vault';

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Oracle Database Vault                                            TRUE

Of course we are Not using the Vault functionality

In that case shall I disable the vault using 'make' command?

Thanks and Regards
Orapratap

Report message to a moderator

Re: Error ORA-47306 causing error for Checkpoint [message #643077 is a reply to message #643073]

Mon, 28 September 2015 09:27

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

Senior Member
Account Moderator

Yes, I think I remember you have an option dvon/dvoff or something like that.
Have a look at the DB Vault documentation or MOS, it is explained there.

Report message to a moderator

Previous Topic:	PGA memory allocation
Next Topic:	query of 'dba_free_space' is too slow??!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 09:55:02 CST 2025