Oracle Study Guide

setting up a kiosk using XP

Windows XP 19.06.2009 Comments Off

http://support.microsoft.com/kb/555463

1. dell computer gx620 has an auto on feature. Auto on time set to 9:45AM.
2. scheduled task set ’shutdown -s -t 01′ to shutdown at 1:30AM every day.
3. Windows set to autologin Customer user (http://support.microsoft.com/kb/315231).
4. All scripts are stored in vidmenu on Customer desktop.
5. Screensaver turned off for Customer.
6. Login script: automate ftp in windows: ftp -n -s:”c:\Documents and Settings\Customer\Desktop\vidmenu\cmdftp.txt” oasisbowl.com cmdftp.txt contains:

lcd “c:\Documents and Settings\Customer\Desktop\vidmenu”
user xxxxxx
<password>
bin
cd /httpdocs/vidmenu get menuBuford.txt
quit

7. set iexplore homepage to C:\Documents and Settings\Customer\Desktop\vidmenu\menu.html which contains:
<head>
<meta HTTP-EQUIV=”REFRESH” content=”60; url=http://www.oasisbowl.com/vidmenu/menu.swf”>
</head>
<center>
Please wait. Menu is loading…
</center>

Create local yum repository

Linux 25.05.2009 Comments Off

http://dotancohen.com/howto/yum_repo.html

iscsi-ls for redhat Enterprise Linux 5

RAC 23.05.2009 Comments Off

You can download a perl script I wrote to replace the work of iscsi-ls here.

From the linux server:

wget http://oracle.3dub.com/iscsi-ls
chmod 755 iscsi-ls
./iscsi-ls

Tags: iscsi-ls red hat EL5, iscsi-ls redhat, iscsi-ls RHEL 5

Actual RAC build notes

RAC 18.05.2009 Comments Off

tmpfs needs to be expanded: /etc/fstab put size=4G in place of ‘default’ for the tmpfs. This is necessary to get isci to start! I beat myself up for 2 days on this
openfiler host/netmask is somewhat misleading. Use the EXACT rac nodes IP addresses and the netmask 255.255.255.255 (specifying the host explicitly).
ocfs2 rpms need to match ‘uname -a’ exactly or it wil NOT work. It will install without warning, but will NOT work.
iscsi-ls is not available for RHEL5. You can run ocfs2console and it will show you the scsi ID on the local machine that the disks are attached to. You can then mount them manually.
java not installed to /usr/local/java/bin, but at /bin/java/jre/1.4.2_06/bin so I had to symlink like so
cd /usr/local
mkdir java
cd java
ln -s /bin/java/jre/1.4.2_06/bin
vipca and srvctl have a wierd bug where it uses LS_ASSUME_KERNEL. They need to be commented out as explained in http://cs.felk.cvut.cz/10gr2/relnotes.102/b15659/toc.htm#CJABAIIF

Getting APC back-UPS UPS’s to work on Linux

Linux, RAC 15.05.2009 Comments Off

Guide at : http://www.mscs.dal.ca/~selinger/ups/backups.html

you will need to change the following line if you use dual NIC’s (as in the case of our RAC systems) in /usr/etc/upsd.conf

LISTEN localhost

Wake On Lan software

RAC 14.05.2009 Comments Off

Download from here: http://www.depicus.com/download.aspx?product=gui

OCFS2 and ASMlib downloads

RAC 12.05.2009 Comments Off

OCFS2:

http://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL5/i386/

OCFS2 tools/console:

http://oss.oracle.com/projects/ocfs2-tools/files/RedHat/RHEL5/i386/1.4.1-1/

http://oss.oracle.com/projects/oracleasm/dist/files/RPMS/rhel5/x86/2.0.5/2.6.18-92.1.17.el5/oracleasm-2.6.18-92.1.17.el5-2.0.5-1.el5.i686.rpm

Getting OEM to work on Vision 12i

OEM 09.05.2009 Comments Off

1. emca -config dbcontrol db -repos create

2. by default the sys user is NOT in the remote password file and will NOT be able to login via OEM. Add the user:
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw<INST> password=hullahoop

Show grants for a specific user

GRANTS 09.05.2009 Comments Off

select privname,object_name from ku$_objgrant_view join all_objects on object_id=obj_num where grantee=’THE_USER’;

recovering from hung nxclient session

Linux, NXclient/server 09.05.2009 Comments Off

If the server crashes while there are active nxclient connections nxclient will continue to detect the stale connection and will not allow you to connect. The easy way to get around this is by stopping the statistics daemon for NX:

/usr/NX/bin/nxstat stop

It is a good idea to restart it after you successfully login:

/usr/NX/bin/nxstat start

Category: