Friday, February 15, 2013

/bin/bash: Permission denied


[root@host /]# su - user1
/bin/bash: Permission denied

Scenario:  My system is not responsive to any process, so i was forced to reboot. Suddenly i cannot login as ordinary user  "user1" 

Solution:  I look the permission of /bin/bash

[root@host ~]$ ls -l /bin/bash
-rwx------. 1 root root 938736 May 10  2012 /bin/bash

tried to change the permission 
[root@host ~]$ chmod 700 /bin/bash
-rwxr-xr-x. 1 root root 938736 May 10  2012 /bin/bash

Then I try to change the permission of the whole /bin  directory

[root@host ~]$ chmod -R 755 /bin

NOW I  CAN login...


Saturday, February 2, 2013

Database Mysql/MSaccess to Oracle migration all weekend


Its been almost a week trying to solve this database migration. The source in msaccess, mysql, csv and text file and my target database is oracle. 

Here are the following steps in my migration path:

1. Install oracle database server Oracle Database 11gR2 on CentOS 6.3 64 bit

2.  Install Sqldeveloper on MacOSX 10.6.8 64bit plus third party database connection (jtds driver, mysql driver and access driver)

3.  Oracle database repository preparation 

4.  Actual migration process using sqldeveloper migration tool.

5. Test and verify migration process.

Details of this process is not part of this post.