Thursday, June 6, 2013

libstdc++.so.5: cannot open shared object file: No such file or directory

Hello,

I have upgraded apache web server from 1.x version to 2.2.15 for PCI compliance. I had to upgrade bea plug-in also and i did, then apache is not coming up.


-bash-4.1$ sudo /sbin/service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd: httpd: Syntax error on line 223 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/modules/mod_wl_22.so into server: libstdc++.so.5: cannot open shared object file: No such file or directory
                                                           [FAILED]

After googling on this error some time and i found a solution.

SOLUTION: 
My server is 64 bit one and it doesn't have 64 bits version of libstdc++.

Install 64 bit version of libstdc++ using below commnand:

sudo yum install compat-libstdc++-33.x86_64

After successful install locate libstdc++ in /usr/lib64/

-bash-4.1$ ls -l /usr/lib64/libstd*
lrwxrwxrwx  1 root root     18 Jun  6 14:56 /usr/lib64/libstdc++.so.5 -> libstdc++.so.5.0.7
-rwxr-xr-x  1 root root 825480 Jun 28  2010 /usr/lib64/libstdc++.so.5.0.7
lrwxrwxrwx. 1 root root     19 Mar 11 16:22 /usr/lib64/libstdc++.so.6 -> libstdc++.so.6.0.13
-rwxr-xr-x. 1 root root 989840 Oct 18  2012 /usr/lib64/libstdc++.so.6.0.13
-bash-4.1$ 


Now restart apache and comes up fine:

-bash-4.1$ sudo /sbin/service httpd restart
Stopping httpd:                                            [FAILED]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using 192.168.200.93 for ServerName
                                                           [  OK  ]
-bash-4.1$ 





Wednesday, April 24, 2013

Copy a Oracle table from one Database to other


Copy a Oracle table from one Database to other


We have two Data bases:  PROD1 DB and PROD2 DB
Table name: Employee
Schema is same in both DBs

We need to sync Employee table from PROD1 DB to PROD2 DB.

1) Create a DB link between PROD1 and PROD2 DBs - assume it is dblink12
2) Create Employee table in PROD2 DB if it doesn't exist
3)  Run below SQL statement in PROD2 DB

TRUNCATE TABLE .EMPLOYEE;
INSERT INTO EMPLOYEE select * FROM EMPLOYEE@dblink12;

and finally don't forget to run commit.

commit;