Category: Oracle

ORA-12919: Can not drop the default permanent tablespace

SQL> drop tablespace users including contents and datafiles;
drop tablespace users including contents and datafiles
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace


SQL> alter database default tablespace user1;

Database altered.

SQL>  drop tablespace users including contents and datafiles;

Tablespace dropped.

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
ORACLE_OCM                     USER1
OJVMSYS                        USER1
SYSKM                          USER1
XS$NULL                        USER1
GSMCATUSER                     USER1
MDDATA                         USER1
AUDSYS                         USER1
DIP                            USER1
SYSDG                          USER1
SPATIAL_CSW_ADMIN_USR          USER1
SPATIAL_WFS_ADMIN_USR          USER1
GSMUSER                        USER1
SYSBACKUP                      USER1
SYSTEM                         SYSTEM
SYS                            SYSTEM

How To Change SYS Password On ExaCC

Changing Oracle Database SYS user password is more complicated in Exacc Gen 2 environment.

The following should be considered, and takes action appropriately when changing SYS user password:

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Check if TDE ( Transparent Data Encryption ) is Enabled in Oracle Database

This post shows us how to check if TDE ( Transparent Data Encryption ) has even been enabled or not in your Oracle database, even there is no encrypted tables or tablespaces in your Oracle database at the moment.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Know RAC Instance Disabled ?

The client RAC database has 4 nodes, but due to the resource and load reasons, two of the 4 instances were disabled by the following command :

$ srvctl disable instance -db TESTDB -instance TESTDB2, TESTDB4

But after a period of time, the client forgot which instances have been disabled exactly.

Here is the right way to report a RAC instance is disabled or not.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

ORA-28040: No matching authentication protocol

After Oracle database server upgraded from 11.2.0.4 to 12.2.0.1, client application connections throw the following errors:

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 27 more
Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol

SOLUTION

Add the following line into sqlnet.ora file of ORACLE_HOME:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Then client application connects to new database working fine.