Posted by Mir Sayeed Hassan on 30th October 2021
ORA-14404: partitioned table contains partitions in a different tablespace Got the below error, While dropping a tablespace. SQL> drop tablespace TEST1_TBL including contents and datafiles; drop tablespace TEST1_TBL including contents and datafiles; *ERROR at line 1: ORA-14404: partitioned table contains partitions in a different tablespace Check any contains… Read more..
Posted in ORA-Error | Comments Off on Error while dropping tablespace: ORA-14404: partitioned table contains partitions in a different tablespace
Posted by Mir Sayeed Hassan on 2nd October 2021
ORA-65162: The password of the common user has expired The above error is occur due to the user password was expired in your database Check the status of the user SQL> select username,account_status from dba_users where account_status like ‘%EXPIRED%’; USERNAME ACCOUNT_STATUS —————————– SYSTEM EXPIRED Check… Read more..
Posted in ORA-Error | Comments Off on ORA-65162: The password of the common user has expired
Posted by Mir Sayeed Hassan on 6th September 2021
How to set the alternative archive destination in Oracle database In case of the archivelog destination space is filled/exausted., the database will be hang until the space release from server. Error log: 0RA-00257: Archiver error, connect internal only until freed ORA-16014: Log 1 sequence# 3981 not archived, no available destinations Solution: To… Read more..
Posted in ORA-Error | Comments Off on How to set the alternate archive destination in Oracle database
Posted by Mir Sayeed Hassan on 19th June 2021
Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space Error log while installation. [oracle@miroradb database]$ ./runInstaller Starting Oracle Universal Installer… Checking Temp space: must be greater than 120 MB. Actual 36214 MB Passed Checking swap space: 0 MB available, 150 MB required. Failed <<<< Checking monitor: must… Read more..
Posted in ORA-Error | Comments Off on Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space
Posted by Mir Sayeed Hassan on 14th June 2021
TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c Check the status of database SQL> select status,instance_name,open_mode, version from V$database,v$instance; STATUS INSTANCE_NAME OPEN_MODE VERSION ———— —————- ——————– —————– OPEN oemdb READ WRITE 12.1.0.2.0 Start the listerner [oracle@oemdb… Read more..
Posted in ORA-Error | Comments Off on TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c
Posted by Mir Sayeed Hassan on 10th March 2021
ORA-65096: invalid common user or role name in Oracle 12c DB The above issue is occur in Oracle 12c DB while creation of new database in Container. Solution recommendation If you want to create a user in Container DB (Oracle 12c), you need to use the prefix as “C##” If you want to create a Read More
Posted in ORA-Error | Comments Off on ORA-65096: invalid common user or role name in Oracle 12c DB