OraFAQ Forum: Server Administration » Transparent Data Encryption

Home » RDBMS Server » Server Administration » Transparent Data Encryption (Ora 10.2)

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

Transparent Data Encryption [message #427655]

Fri, 23 October 2009 15:01

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!

Report message to a moderator