Friday, May 25, 2018


Removing a package

You can uninstall a package using -e switch along with rpm command

NOTE: Before removing a package make sure you get the complete name of the package using the below command
# rpm -qa | grep cvs
cvs-1.11.23-16.el6.i686

# rpm -e cvs-1.11.23-16.el6.i686

Removing a package without dependencies

Use an extra argument --nodeps along with rpm command to remove/uninstall a package without dependencies
# rpm -e vsftpd-2.2.2-11.el6_4.1.i686 --nodeps

How to install/uninstall/upgrade rpm package with/without dependencies

I have already written an article with 15 practical examples on various rpm based commands which are used in real world of IT on a day to day basis.

Also do you know what every field of rpm name represents? This is one of the most trickiest interview questions asked many times

A RPM package abbreviated as Red Hat Package Manager refers to Red Hat package installed on Fedora, CentOS, OEL and all Red Hat source code derived OS.


Installing from the downloaded rpm package

Use -ivh switch along with rpm command as shown below

# cd /root/rpms
# rpm -ivh cvs-1.11.23-16.el6.i686.rpm
Preparing...                ########################################### [100%]
   1:cvs                    ########################################### [100%]

Installing directly from the package available on web.

But for this you need to have the proper link of the rpm you want to download or install
# rpm -ivh ftp://ftp.pbone.net/mirror/ftp.centos.org/6.5/os/i386/Packages/cvs-1.11.23-16.el6.i686.rpm
Retrieving ftp://ftp.pbone.net/mirror/ftp.centos.org/6.5/os/i386/Packages/cvs-1.11.23-16.el6.i686.rpm
warning: /var/tmp/rpm-tmp.z3VsTc: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:cvs ########################################### [100%]

Installing a package forcefully without dependencies

Use --force argument along with -ivh switch as shown below to install forcefully without dependencies
# rpm -ivh vsftpd-2.2.2-11.el6_4.1.i686.rpm --force
warning: vsftpd-2.2.2-11.el6_4.1.i686.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:vsftpd ########################################### [100%]

Upgrading a package

Use -Uvh switch along with rpm command
# rpm -q vsftpd
vsftpd-2.0.5-28.el5.i386

# rpm -Uvh vsftpd-2.2.2-11.el6_4.1.i686.rpm
warning: vsftpd-2.2.2-11.el6_4.1.i686.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:vsftpd ########################################### [100%]

Wednesday, May 2, 2018


EBS 12.2 Apps Cloning Error in OEL 6.7

Error 

 txkWfClone.sh exited with status 127 ERROR: txkWfClone.sh execution failed, exit code 127

Solution

 yum install glibc-devel.i686

RC-50013 Fatal: Instantiate driver

Error:
Seen the issue during the execution of adcfgclone.
perl adcfgclone.pl dbTechStack
====================
WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts: 
    Directory: /u01/vis/visdb/tech_st/11.2.0/perl/bin/perl -I /u01/vis/visdb/tech_st/11.2.0/perl/lib/5.10.0 -I /u01/vis/visdb/tech_st/11.2.0/perl/lib/site_perl/5.10.0 -I /u01/vis/visdb/tech_st/11.2.0/appsutil/perl /u01/vis/visdb/tech_st/11.2.0/appsutil/clone
      ouicli.pl               INSTE8_APPLY       1 



AutoConfig is exiting with status 1

WARNING: RC-50013: Fatal: Instantiate driver did not complete successfully.
/u01/vis/visdb/tech_st/11.2.0/appsutil/driver/regclone.drv

====================

CAUSE:
The script was trying to register the oracle home in inventory but its failing to update it.

SOLUTION:

Edit and set correct path for oraInst.loc file

[root@viz Desktop]# vi /etc/oraInst.loc 

inst_group=dba
inventory_loc=/u01/vis/oraInventory

#inst_group=dba
#inventory_loc=/u01/dbobi/oraInventory

or
delete existing files under oraInventory folder and retry the adcfgclone.

rm -rf oraInventory
mkdir oraInventory
Retry :   perl adcfgclone.pl dbTechStack


Tuesday, April 17, 2018


After R12 Clone: XML reports are not completing 

After make a clone of R12, the new instance gave “Completed, Warning” for all XML output requests the request log show the following:


oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: /ebiz/ebizapps/share/temp/xdoiZKMS2ITgq041618_20232583012.tmp (No such file or directory)


Solution:

Navigate to Xml publisher Administrator and add the path

1. Navigation Path: /u01/vis/visapps/share/temp

(Responsibility) XML Publisher Administrator > (Menu) Home > (Tab) Administration > (SubTab) Configuration > Properties > General > Temporary directory

2. Provide a valid value to ‘Temporary directory’, and click button ‘Save’.

3. Re-test the issue.




Tag Archives: XML Publisher Administrator


Thursday, April 5, 2018


RHEL / Centos Linux Disable Firewall


[a] /etc/init.d/iptables – IPv4 iptables firewall service.
[b] /etc/init.d/ip6tables – IPv6 iptables firewall service.

Disable firewall

Type the following command as the root user to disable firewall for IPv4:
# service iptables save
# service iptables stop
# chkconfig iptables off

Sample outputs:
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
Sample output with verification (see below):
Red Enterprise Linux Disable Iptables IPv4 Firewall

Enable firewall

Type the following command as the root user to enable firewall for IPv4:
# service iptables start
# chkconfig iptables on

Sample outputs:
iptables: Applying firewall rules:                         [  OK  ]
Type the following command as the root user to disable firewall for IPv6 :
# service ip6tables start
# chkconfig ip6tables on

Verify that firewall is disabled

Type the following command as root user to see IPv4 firewall rules:
# /sbin/iptables -L -v -n
OR
# service iptables status
The following output indicates that firewall is not active:
Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         

Chain OUTPUT (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination

(b)  IPv6

Type the following command as the root user to disable firewall for IPv6 :
# service ip6tables save
# service ip6tables stop
# chkconfig ip6tables off

Type the following command as root user to see IPv6 firewall rules:
# /sbin/ip6tables -L -v -n
OR
# service ip6tables status



Tuesday, March 27, 2018


Restore RMAN backup
=================

If you are new to RMAN, you should first understand how to backup oracle database using RMAN.

RMAN> SET DBID 12345; 


RMAN> STARTUP NOMOUNT;  or  RMAN> STARTUP FORCE MOUNT;

RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";


RMAN> RESTORE CONTROLFILE;


RMAN> RESTORE DATABASE; 


RMAN> RECOVER DATABASE; 

RMAN> ALTER DATABASE OPEN RESETLOGS;



Problem

Oracle Database recovery using RMAN fails with RMAN-06054: media recovery requesting unknown archived log 

https://www.veritas.com/support/en_US/article.100022346

Error Message

archived log file name=/opt/app/oracle/flash_recovery_area/ETAUTOIT/archivelog/2014_04_18/o1_mf_1_20725_9o0qrvh2_.arc thread=1 sequence=20725
channel default: deleting archived log(s)
archived log file name=/opt/app/oracle/flash_recovery_area/ETAUTOIT/archivelog/2014_04_18/o1_mf_1_20725_9o0qrvh2_.arc RECID=20582 STAMP=845172555
unable to find archived log
archived log thread=1 sequence=20726
released channel: c0
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
released channel: c7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/18/2014 02:10:32
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 20726 and starting SCN of 3101263306

Cause

Oracle does not stop recovery at the last available archive log in the database backupsets as per the restored control file.

Solution

Oracle does not stop recovery at the last available archive log in the database backupsets as per the restored control file. It keeps on requesting for "next available archive log sequence number (20726)". In fact, there is no log sequence 20726 recorded in the restored control file. Hence the database is already consistent after applying log sequence 20725 whose existence was already recorded in the target database control file and that is why the recovery is successful. Now try to open the database with below command and It should complete successfully.

sqlplus '/ as sysdba'
sql>alter database open resetlogs;

Once you execute above command, You should get the "Database altered" message which indicates that the database opened successfully.

Enable and Disable Archive Log Mode 10g/11g


Enable Archive Log Mode
============================

http://www.oracledistilled.com/oracle-database/backup-and-recovery/enabledisable-archive-log-mode-10g11g/

https://logic.edchen.org/how-to-set-use_db_recovery_file_dest/

[oracle@ora1 ~]$ sqlplus / as sysdba


SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     25
Current log sequence           27

-----------------------------------------------------------------------------------------------

SQL> show parameter recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/flash_recovery
                                                 _area
db_recovery_file_dest_size           big integer 3852M
SQL>

--------------------------------------------------------------------------------------------------

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 80G SCOPE=BOTH;

SQL>  alter system set db_recovery_file_dest='/u04/fast_recovery_area/' scope=both;

SQL>  alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;


SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            DB_RECOVERY_FILE_DEST
Oldest online log sequence     25
Current log sequence           27


---------------------------------------------------------------------------------------------------

SQL> shutdown immediate
.

SQL> startup mount

----------------------------------------------------------------------------------------------

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            DB_RECOVERY_FILE_DEST
Oldest online log sequence     25
Next log sequence to archive   27
Current log sequence           27


-----------------------------------------------------------------------------------------------

SQL> alter system switch logfile;

System altered.

SQL> host
[oracle@ora1 ~]$ ls /u02/app/oracle/oradata/orcl/arch
1_27_711369564.dbf
[oracle@ora1 ~]$ exit
exit

SQL>

--------------END-----------------------


Disable Archive Log Mode
=========================

[oracle@ora1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:54:05 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u02/app/oracle/oradata/orcl/arch
Oldest online log sequence     26
Next log sequence to archive   28
Current log sequence           28
SQL>

----------------------------------------------------------------------------------------------

SQL> shutdown immediate

SQL> startup mount

--------------------------------------------------------------------------------------------

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            DB_RECOVERY_FILE_DEST
Oldest online log sequence     26
Current log sequence           28
SQL>

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...