Category Archives: Uncategorized

To enable client encryption and integrity checking in a JDBC connect string, use the following syntax: jdbc:oracle:thin:@//hostname:1521/hrdb ?oracle.net.encryption_client=REQUIRED &oracle.net.encryption_types_client=AES256 &oracle.net.crypto_checksum_client=REQUIRED &oracle.net.crypto_checksum_types_client=SHA1 Once you are connected, run the following sql to verify the settings. Look for lines that list ciphers and … Continue reading →

I ran an export which included the table EMP. Later I imported this into a test instance using TABLE_EXISTS_ACTION=SKIP, and received error ORA-39325: TABLE_EXISTS_ACTION cannot be applied to “MYSCHEMA”.”EMP”. Upon further investigation, there was already a view named MYSCHEMA.EMP in … Continue reading →

Here’s an example of counting logons (established connections) at the listener: By minute: fgrep “23-FEB-2017 10:” listener.log | fgrep “establish” | awk ‘{ print $1 ” ” $2 }’ | awk -F: ‘{ print $1 “:” $2 }’ | sort … Continue reading →

If you encounter a ‘db file sequential read’ wait, the P1 and P2 parameters from v$session_wait can be used to identify which object the process is waiting on. This may be helpful during troubleshooting. Here’s a sample query that looks … Continue reading →

A developer reported getting the following connection reset message box while using SQL Developer 4.1.3.20, and a 12c database in which encryption and sqlnet data integrity (checksumming) had been enabled. Here’s the error from Sql Developer: “Your database connection has … Continue reading →

The JDK directory can be specified in the sqldeveloper.conf file. This file is located in SQL_DEVELOPER_HOME\sqldeveloper\bin\sqldeveloper.conf. (Reference MOS Doc ID 603917.1) Examples: SetJavaHome C:\Oracle\product\11.2.0\client_1\jdk (v1.5.5) SetJavaHome ../../jdk (v4.1.3.20)

This is similar to another post “ORA-01565 Unable to open Spfile when spfile is stored on ASM”. New 12.1.0.2 install. Created database using dbca. Specified omf name for spfile. After some database activity, the following error began appearing in the … Continue reading →

To enable client encryption and integrity checking, add the following lines to the client’s sqlnet.ora: # # Encryption # SQLNET.ENCRYPTION_CLIENT = REQUESTED SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256, AES192, AES128) SQLNET.ENCRYPTION_SERVER = REQUESTED SQLNET.ENCRYPTION_TYPES_SERVER = (AES256, AES192, AES128) # # Network integrity # … Continue reading →

Installed 12.1.0.2 client on AIX 7.1 Power 64 bit. After the install, sqlplus returned errors “rtld: 0712-001” and “rtld: 0712-002”. We checked if the I/O Completion ports (IOCP) module was enabled, as we previously had a similar issue while installing … Continue reading →

New 12.1.0.2 install. Created database using dbca. Specified omf name for spfile. Registered database in OEM, and then started getting error: ORA-01565: Unable to open Spfile +DATA/dwtst1/spfiledwtst1.ora. SQL> show parameter spfile NAME TYPE VALUE ———- ——— —————————— spfile string +DATA/dwtst1/PARAMETERFILE/spfile.261.902329725 … Continue reading →