Database Oracle Security

Connection Encryption in Oracle Database

To encrypt connections between client and database server you have to set some parameters in sqlnet.ora file ($ORACLE_HOME/network/admin/sqlnet.ora) of server and client (you have to install oracle client on the client): server side: client side: the ENCRYPTION_CLIENT parameter can have one of these values: ACCEPTED : The client or server will allow both encrypted and […]

ASM Database Oracle

Database Startup Error: Fatal NI connect error 12547

If you see Fatal NI connect error 12547 error in alert log file of a Database in the middle of startup, and the database process couldn’t find DB PARAMETER FILE and CONTROL FILE, you have to check permissions,owner and group of these files: The permission of these files have to be 6751. The group of […]

Database Export/Import (EXPDP/IMPDP) Oracle

IMPDP Errors: ORA-02374, ORA-12899

If the Character set of source and destination database are not equal, you will see below errors in the impdp log file: to solve this error, you have to restore the structure of tables first then you have to modify these fields with alter table command as below: finally, we you have to import data […]