Posts Tagged ‘Unix’
Cluster SSH tool Utility
Many times you come across scenario’s when you wish to open multiple ssh windows and execute same commands.e.g You wish to see alert log for multi-node RAC simultaneously or edit sysctl.conf files for multiple machines. Cluster SSH utility helps solve this problem as [Read More]
Effect Of Multiple SHMMAX Settings
Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size 0x000000000f0020xx fix shm parameters in /etc/system or equivalent It is an Oracle 10204 database running on Solaris. Searching MOS for exact meaning for this [Read More]
How To Discover Disk Name When LUN Number is Known (OEL5)
I am creating 11gR2 RAC setup for one of my client. Following Oracle documentation for storage, I opted for Oracle ASM and asked storage team for new physical devices. Storage admin thus provided me with a set of LUNs instead of actual physical device names like [Read More]
Sqlplus connection on AIX taking too long
Recently we faced a performance issue, where in sqlplus connection from application server A (AIX 5.3) to Database server DB (different physical server,10gR2 on AIX 5.3) was taking nearly 1-2 minutes. We did some quick check’s to narrow down the problematic area.i.e [Read More]
Use awk/sed in vi
Thought of sharing some useful info which can help you to do your work faster in vi.You can use awk/sed scripts in vi using following command in vi :%!scriptname Here the scriptname file should have execute privilges for user. I used this to create a useful script which I [Read More]
Connections to DataBase Hang Including “/ as sysdba”
Recently I faced one issue where all the connection to database hung and it was also not possible to login to database using “/ as sysdba”. To get access of sqlplus I used the following syntax: $ sqlplus -prelim / as sysdba With “prelim” option we [Read More]
Scheduling Job through Cron??
In case you came across this link searching for Cron syntax, then you can refer to following link http://www.adminschoice.com/docs/crontab.htm Other’s can continue reading the article …. This was a problem which I faced yesterday. We had a mview refresh which [Read More]
Creating ASM devices on AIX
I thought of sharing few tips on creating ASM devices on AIX which I will be helpful to Oracle DBA’s. Suppose SysAdmin gives you list of Serial numbers for LUN instead of device Name pcmpath query device DEV#: 33 DEVICE NAME: hdisk33 TYPE: 2107900 ALGORITHM: Load [Read More]
CRS Fails to Start – 10.2.0.1 RAC Install on AIX
I was installing 10.2.0.1 on IBM AIX 5L and while running root.sh from first node (as part of Clusterware installation) got following messages Now formatting voting device: /dev/voting_disk01 Now formatting voting device: /dev/voting_disk02 Now formatting voting device: [Read More]
Input is too long (> 2499 characters) – line ignored
There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve this issue. Copy the code in Text file and while in escape mode enter following command [Read More]
Effect of OS Terminal Setting “STTY” on Oracle Database
Few days back, while trying to create a synonym over dblink I experienced following error: SQL> create synonym synonymn_name for dual@DBLINK9i; SP2-0042: unknown command "DBLINK9i" - rest of line ignored Strange error !!! Also while trying to perform a simple [Read More]
Easy and Free X-Windowing Setup with Cygwin
Today I had to carry out Oracle client Installation on one of the server. Normally I use vncviewer to connect to one of my Linux machine (having vncserver setup) and then get the display on to that machine. But my colleague suggested me about one more approach, which I [Read More]
Significance of LD_LIBRARY_PATH
Few days back, I wanted to remove a instance semaphore as they were not cleared automatically due to abnormal shutdown. As there were few other databases running on the server , so I thought of capturing the semaphore id to remove them manually using “ipcrm” . [Read More]
