Posted by Mir Sayeed Hassan on 23rd August 2020
Error while loading shared libraries: libnsl.so.1 or libnsl.so.1 not found in Oracle 19c Installation This error is occur while installation of Grid Infrastructure for Oracle 19c database. [root@pri-db ~]# cd /u01/app/19c/grid/ [root@shop-pri grid]# ls acfsccm addnode cdp css demo gnsd instantclient ldap network oracore… Read more..
Posted in ORA-Error | Comments Off on Error while loading shared libraries: libnsl.so.1 or libnsl.so.1 not found in Oracle 19c Grid Installation
Posted by Mir Sayeed Hassan on 26th July 2020
ORA-55641: Cannot drop tablespace used by Flashback Data Archive I was trying to drop the tablespace from the test database & got the below error LOGIN TO DATABASE [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 26 05:17:21 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected… Read more..
Posted in ORA-Error | Comments Off on ORA-55641: Cannot drop tablespace used by Flashback Data Archive
Posted by Mir Sayeed Hassan on 16th July 2020
How to fix “SSH – “REMOTE HOST IDENTIFICATION HAS CHANGED” in Oracle Linux This Warning has occur in one of our database while trying to connect by using SSH General Information: The SSH/Secure shell is to securely login to the remote machine by using the SSH & ensuring that our connection is secure. Warning message… Read More
Posted in ORA-Error | Comments Off on How to fix “SSH – “REMOTE HOST IDENTIFICATION HAS CHANGED” in Oracle Linux
Posted by Mir Sayeed Hassan on 22nd June 2020
ORA-00119 invalid specification for system parameter REMOTE_LISTENER in RAC 11gR2 Database Issue occur while startup of the RAC Database. [oracle(racdb-n1)@racdb-n1 ~]$ srvctl start database -d racdb ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-00119: invalid specification for system parameter REMOTE_LISTENER ORA-00132:… Read more..
Posted in ORA-Error | Comments Off on ORA-00119 invalid specification for system parameter REMOTE_LISTENER in RAC 11gR2 Database
Posted by Mir Sayeed Hassan on 17th April 2020
One of test database is set with flashback enabled as on, But there are some flashback files are deleted so we are not able to open the database in open mode & got the below ORA-38760 error. ORA-38760: This database instance failed to turn on flashback database Check the status of the database SQL> select Read More
Posted in ORA-Error | Comments Off on ORA-38760: This database instance failed to turn on flashback database
Posted by Mir Sayeed Hassan on 26th January 2020
ORA-00054: resource busy and acquire with NOWAIT specified Error occur while creating a table. SQL> create table MIR.T_TRANSACTION(C_ID VARCHAR2(255 CHAR) not null primary key); ORA-00054: resource busy and acquire with NOWAIT specified ORA-00054: resource busy and acquire with NOWAIT specified 9260 views Less than… Read more..
Posted in ORA-Error | Comments Off on ORA-00054: resource busy and acquire with NOWAIT specified
