Skip to main content

Posts

Showing posts from June, 2008
UnixHowTo: How to find a particular word in a list of files in UNIX? I am about to find the string "sqlplus" in a list of shell scripts:- $ find . -name "*.sh" -print | xargs grep -l sqlplus ./jupallisampleshell1.sh ./jupallisampleshell2.sh $ find . -name "*.sh" -print | xargs grep sqlplus ./jupallisampleshell1.sh: $ORACLE_HOME/bin/sqlplus -s scott/tiger@localhost @testsql2.sql ./jupallisampleshell2.sh: $ORACLE_HOME/bin/sqlplus -s scott/tiger@localhost @testsql2.sql

Server uptime command to find out how long the system has been running

You would like to find out how long the system has been running. Linux and UNIX comes with various command to find out server uptime command. Under Linux file /proc/uptime has uptime information, /var/run/utmp has information about who is currently logged on. However, information from /proc or utmp file is not directly readable by humans so we use following commands: Uptime command $ uptime 17:08:49 up 5:54, 6 users, load average: 2.03, 1.68, 1.50 uptime command gives a one line display of the following information. The current time (17:08:49) How long the system has been running (up 5:54) How many users are currently logged on (6 users) The system load averages for the past 1, 5, and 15 minutes (2.03, 1.68, 1.5) This is the same information contained in the header line displayed by w and top command: $ w $ top Note that w displays who is logged on and what they are doing while top command provides a dynamic real-time view of a running Linux/UNIX/BSD system.

INFORMATICA INSTALLATION

Informatica7.1: Installation Steps in WINDOWS XP ( Service Pack 2) Oracle 8i /************************************************ * INFORMATICA 7.1 Installation Steps * OS: WINXP(SP-2) * Oracle 8i *************************************************/ 1. Create an user for informatica metadata:- DROP user jupalli_user cascade; CREATE USER jupalli_user IDENTIFIED BY jupalli_user DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; GRANT CONNECT,DBA TO jupalli_user; 2. Configure IRS( Informatica Repository Sever ):- Server port no-- 5858 ( say ) Administrator password-- 5858 ( say ) Remaining all--Keep as it is. 3. Create a New Repository Server:- Go to ( RSAC )Repository server admin console. Right click on Informatica Repository servers -->New server registration. Hostname--yours computer name. Portnumber--IRS port number ( Here 5858 ) -->ok Try to connect. If its not getting connected,go to services and check whether Informatica Repository Service is running or not.If its not ...