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 was lagging on one of the server. On checking master site, I found that…
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 Balance SERIAL: 75DM011<span style="color: #ff0000;"><strong>1101</strong></span> =========================================================================== Path# Adapter/Path Name…
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: /dev/voting_disk03 Format of 3 voting devices complete. Startup will be queued to init within 30 seconds I waited…
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 :%s/,/,^M/g Please note that to insert ^M you need to…
Few days back, while trying to create a synonym over dblink I experienced following error: SQL> create synonym synonymn_name for [email protected]; SP2-0042: unknown command "DBLINK9i" – rest of line ignored Strange error !!! Also while trying to perform a simple select statement over another dblink: SQL > select * from [email protected]; SP2-0042: unknown command "DBLINK10g"…
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 thought of sharing with all of…