Home » RDBMS Server » Server Administration » Transparent Data Encryption (Ora 10.2)
Transparent Data Encryption [message #427655] Fri, 23 October 2009 15:01 Go to next message
william7001
Messages: 8
Registered: October 2009
Location: MD
Junior Member
I am trying to test Oracle Transparent Data Encryption and have following command in SQL*PLUS

alter system set encryption key authenticated by "test";

get following error:

ERROR at line 1:
ORA-00406: COMPATIBLE parameter needs to be 10.2.0.0.0 or greater
ORA-00722: Feature "Transparent Data Encryption"

Try to check my Oracle version by runing select * from v$version and got following

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 Production


My Oracle version is greater than 10.2.0.0.0, why do I still get "COMPATIBLE parameter needs to be 10.2.0.0.0 or greater" error?

Thanks!
Re: Transparent Data Encryption [message #427656 is a reply to message #427655] Fri, 23 October 2009 15:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select value from v$system_parameter where name='compatible';
select value from v$parameter where name='compatible';

Regards
Michel
Re: Transparent Data Encryption [message #427659 is a reply to message #427655] Fri, 23 October 2009 16:12 Go to previous messageGo to next message
william7001
Messages: 8
Registered: October 2009
Location: MD
Junior Member
Here is the result.

VALUE
10.1.0.2.0

1 row selected.

VALUE
10.1.0.2.0

What should I do?
Re: Transparent Data Encryption [message #427664 is a reply to message #427659] Fri, 23 October 2009 18:12 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>What should I do?
set
compatible=10.2.0.1
& restart database
Previous Topic: Database open issue
Next Topic: Memory Notification
Goto Forum:
  


Current Time: Sun Dec 04 08:25:01 CST 2016

Total time taken to generate the page: 0.05992 seconds