Wednesday, June 19, 2013

Remove Control M' Characters (^M) with Unix and Linux commands

Using dos2unix  command
dos2unix ORIG_FILENAME TEMP_FILENAME
mv TEMP_FILENAME ORIG_FILENAME
IMP NOTE: use dos2ux command if you are using HPUX
                    use dos2unix  command if you are using LINUX
Using sed command
sed ‘s/^M//g’ ORIG_FILENAME > TEMP_FILENAME
mv TEMP_FILENAME ORIG_FILENAME
IMP NOTE: To get ^M in UNIX (Hold control key and then press v and m character).  
Using vi Editor
ESCAPE   :%s/^M//g ENTER
IMP NOTE: To get ^M in UNIX (Hold control key and then press v and m character).

Friday, June 14, 2013

EXP-00008: ORACLE error 904 encountered ORA-00904: "IFREEPOOL": invalid identifier

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.

Symptoms

Export reports ORA-00904 "IFREEPOOL": invalid identifier while using a version 10.2.0.4.0 export client to export from a 10.2.0.3.0 database.
Export Log File 
---------------
. . Export der Tabelle CALCULATEDFIELDS
EXP-00008: ORACLE-Fehler 904 aufgetreten
ORA-00904: "IFREEPOOL": invalid identifier

Cause

This is an expected behaviour.
The version of the Export utility must be equal to the earliest version of the source or target database. Here, the source database is based on release 10.2.0.3.0 and hence the export client has to be a version 10.2.0.3.0.
An export client of a later release cannot be used for the following reasons:
  • The export utility is continuously accessing dictionary objects such as SYS.EXU9LOB.
  • Starting with release 10.2.0.4.0 we introduced additional columns such as 'IFREEPOOL'. This column is not available in 10.2.0.3.0 and hence the client cannot handle this and ORA-00904/EXP-00008 appears.

    Client 10.2.0.4.0 is not supported to export from 10.2.0.3.0 database.

Solution

The version of the Export utility must be equal to the earliest version of the source or target database.

Thursday, June 6, 2013

Run Multiple Apache On Single Host

In this blog post we are going to discuss on how to run two Apache instances on single Linux host.
We already have one Apache installed and serving the static content. The Apache is installed at the following location:
/etc/httpd
Let`s copy the directory /etc/httpd to /etc/avon_httpd
  cp -pr /etc/httpd  /etc/avon_httpd   
Now, as we have copied the old Apache web-server to a new location /etc/avon_httpd. We need to make the changes to the configuration file.
cd  /etc/avon_httpd and open the httpd.conf file in a vi editor and make changes to the following values:
ServerRoot “/etc/httpd”  TO ServerRoot “/etc/avon_httpd”
Listen 80 TO Listen 82
PidFile run/httpd.pid TO PidFile run/avon_httpd.pid
Save and close the file.
In the next step we are going to copy the RHEL httpd configuration file.
 cp -pr /etc/sysconfig/httpd  /etc/sysconfig/avon_httpd 
In the next step, let`s copy the script /etc/init.d/httpd  TO /etc/init.d/avon_httpd
 cp -pr  /etc/init.d/httpd   /etc/init.d/avon_httpd 
In this step, Link the /usr/sbin/httpd TO /usr/sbin/avon_httpd
 ln -s  /usr/sbin/httpd   /usr/sbin/avon_httpd 
Open the file avon_httpd under /etc/sysconfig/ and enter the following lines:
## CUSTOM SETTINGS ##
HTTPD=/usr/sbin/avon_httpd
OPTIONS="-f /etc/avon_httpd/conf/httpd.conf"
LOCKFILE=/var/lock/subsys/avon_httpd
PIDFILE=/var/run/avon_httpd.pid
Open the avon_httpd file under /etc/init.d and replace httpd to avon_httpd.
The command used to start/stop httpd and avon_httpd service could be:
  • /etc/init.d/httpd {start|stop|restart|condrestart|reload|status|fullstatus|graceful|help|configtest}
  • /etc/init.d/avon_httpd {start|stop|restart|condrestart|reload|status|fullstatus|graceful|help|configtest}


Wednesday, June 5, 2013

Ubuntu 12.10- No Unity GUI(missing sidebar in ubuntu 12.10)

Install unity Package  first
sudo apt-get install unity
To see what will happen.

For now, it might be easier for you to use some other DE, such as Gnome-shell.

sudo apt-get install gnome-shell
Then restart Your system .