Hi there, do you using Solaris Zoning? Stuck in creating NFS to share partition among Local Zone like me? Hehe I just know that in Solaris, non-global zone can only be a NFS client. Cannot be a NFS Server. Only Solaris global zone can be NFS Server. In my case, I have 2 physical servers [...]

ello people. Using Linux? Red Hat Enterprise Linux or Oracle Enterprise Linux? Oppss.. got missing packages and tired of dependencies? Hahahaha.. Here some free repository provided by Oracle for FREE..yahooo!!! But with NO SUPPORT, of course… but, its freeeee… ok, 1st, choose the Linux version that you use? After recognize your Linux version, copy the yum [...]

Lets do restoration and recoveriration.. Spec pliz.. … … OK!! Database: Oracle9i Release 9.2.0.6.0 – 64bit Production (Standard i.e. of course not Enterprise) OS: HP-UX Error: As mention above at the title of this post. LoL Workaround: 1. Shutdown db 2. Set dbid RMAN> set dbid=1372791293 3. Startup NOMOUNT database RMAN> startup nomount Oracle instance [...]

In Oracle 10g, there are 3 options to storage datafiles: 1. Filesystem 2. RAW disk 3. Automatic Storage Management (ASM) ASM is a new feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, log files and control files. Oracle Managed Files (OMF) will be use if ASM is chosen as [...]

I’ve faced situation which export process going hang. It occurs in Oracle 9i (9.2.0.1) database on Windows Server 2000. No matter either I’m using “exp” utility or exp command or par file, the export process likely to going hang itself like this: Export: Release 9.2.0.1.0 – Production on Thu Jul 28 16:24:34 2011 Copyright (c) 1982, [...]

Both errors happen to me when I want to create Oracle Database 10.2.0.4 using ASM on RHEL5 i686 (32-bit). All process during ASM Creation was happen smoothly without any complaint and any error. Then, after ASM creation completed, and new database creation process started. The process stuck whenever I want to enter ASM password, an [...]

Oh my god, I am on standby tonight with no overtime can be claim..wuuu..wuuu..:( Boring…Stared on the black and white putty screen make me hungry..haha..How do they relate?? Then, I take a look at collection of pictures inside my phone. Owh, I forgot to post this picture to my cheesy blog (err..not blog actually, more [...]

Ok, this is just my simple note about how to create ASM disk Assumption: Disk already partitioned and oracleasm package has been installed. If not, partition it using fdisk and download oracleasm package from here Firstly, configure the Oracle Linux ASMLib driver # oracleasm configure -i Configuring the Oracle ASM library driver. This will configure [...]

Case Study: I tried to drop user cascade, and the expected result is the user will drop with no problem. But, the drop process take too long. “Hurm..Maybe there are a lot of table inside the schema”, I guess. No, it only 24 tables..duuhh..I’m waiting almost an hour but the drop process not ended yet. [...]

Owh, I can’t uninstall this stupid application from my Windows machine. What should I do? I’ve clicked on Uninstall button more than 10 times, but the following error still came out: “Internal error: Cannot find utCompiledCode record for this version of the uninstaller” But, I don’t want this application anymore. I want to sack this, [...]

I’ve seen this error happen on Oracle Enterprise Manager Grid Control 10g many times. The error is 503 Service Unavailable Servlet error: Service is not initialized correctly. Verify that the repository connection information provided is correct. Yeah, this error quite frustrating me. There are almost no clue regarding this error. All opmn component is up [...]

This is the basic and important command that I always forgot when working with Oracle RAC. Haish..!!! Faiz, please remember this OK!!! :p Start All Oracle Instance srvctl start database -d <dbname> Start Single Oracle Instance, ASM and Nodeapps srvctl start instance -d <dbname> -i <instancename> srvctl start asm -n <nodename> srvctl start nodeapps -n [...]