Mir Sayeed Hassan Blog- Oracle DBA

Solution to connect user with “@” Password using sqlplus Verify the telnet with specific port as shown below C:\Users>telnet 192.168.1.1 1521 Or [oracle@localhost ~]$ telnet 192.168.1.1 1521 Trying 192.168.1.1... Connected to 192.168.1.1 Escape character is '^]' Try to connect with user which has password as “M@R” using sqlplus [oracle@localhost ~]$ sqlplus mir/"M@R" SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 5 14:53:15 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [oracle@localhost ~]$ Solution: Syntax: sqlplus scott/\”scott@test\”@TEST_DB or sqlplus scott/\”t@ger@\”@IP/SID C:\Users>sqlplus MIR/\"M@R\"@192.168.1.1/testdb SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 5 14:28:33 2017 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to: Oracle Database 1...

ORA-Error – 01111/ORA-01110/ORA-01157 name the datafile is unKnown Cause : This error will occur on standby database after adding the new datafile into primary database Solution: View the alert log [oracle@db-std ~]$ cd /u01/app/oracle/diag/rdbms/teststdby/teststdby/trace/ [oracle@db-std trace]$ tail -100 alert_teststdby.log ORA-01157: cannot identify/lock data file 36 - see DBWR trace file ORA-01111: name for data file 36 is unknown - rename to correct file ORA-01110: data file 36: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00036' Verify the rename datafile from the primary database SQL> select file#,name from v$datafile;  36  +DATA/testdb/datafile/test_tajmi.295.953808069 This shows that the datafile name is mismatch, we need to correct it by using the below procedure SQL> alter system set standby_file_management=manual; Syntax: SQL> ALTER DATABASE CREATE DATAFILE '< ....UNNAMED00167>' as '< datafile name with the ...

ORA-01110: data file 1: '/oradata/datafiles/system01.dbf' Error occur while restoring the database from the backup of RMAN RMAN> alter database open resetlogs; using target database control file instead of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 09/03/2017 16:05:14 ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/oradata/datafiles/system01.dbf' To resolve this error fallow the below procedure – Hopefully you will succeed If you’re primary database is flashback & it has the standby – Fallow below procedure RMAN> run { 2> recover database; 3> } ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter datab...

Install SQL Instant client on Ubuntu Directly we don’t have the RPM/Zip Packages to install the instant client on Ubuntu, as we need to download the Linux Packages/Zip Files from the Oracle Site ( http://www.oracle.com/technetwork/database/features/instant-client/index... )  And convert into Ubuntu compatible then install. The below are the files to download & place into opt directory # /opt root@xyz-deploy:/opt# ls instantclient-basic-linux.x64-12.2.0.1.0.zip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip Before unzip the above files, we need to install some packages like alien & unzip etc, Internet access should be present on server Take the backup of the source.list file & make some changes to existing source file Verify the internet root@xyz-deploy:/opt# ping 8.8.8.8 PING 8.8.8.8 (8.8.8.8) 56(84) bytes of data. 64 bytes from 8.8.8.8: icmp_seq=1 ttl=36 time=141 ms root@xyz-deploy:/opt# cp /etc/apt/sources.list /etc/apt/sour...