Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I have moved all objects out,dropped encrypted tablespace , but why TDE is still there

User_XEAE4Mar 23 2018 — edited Mar 25 2018

Folks,

We are running Oracle 12.1.0.2 db.

We had encrypted TDE, tablespace based, by basically, creating encrypted Tablespaces and then moving tables/indexes to the

encrypted tablespaces.

Also had generated the auto-login file.

Later on, it was decided to remove encryption from that database.

So ,we moved all the tables/indexes from encrypted tablespaces to non-encrypted tablespaces.

Then we dropped those empty tablespaces, so now, all the tablespaces are non-encrypted.

So can we remove all the reference to wallet location etc in the sqlnet.ora and we should be able to start and open the database, without having

any reference to WALLET_LOCATION in the sqlnet.ora file right ?

I believe i tried that, removing reference from sqlnet.ora to WALLET_LOCATION, but after starting the database, it said database not open,as the

reference to autologin file was missing in sqlnet.ora, -- which confused me, as I was thinking it did NOT need the autologin file.

Any input , advise etc ?

Thanks

Ashish

This post has been answered by Roxana - Oracle-Oracle on Mar 23 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2018

Added on Mar 23 2018

#database-security, #database-security-general

4 comments

725 views