FaizSulaiman.com
What Are You Looking For May be Here
Looking For Yum Yum Linux Repo?
Hello 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?
OEL 4/RHEL 4, Update 6 or …
ORA-01547, ORA-01194, ORA-01110 What is This der?
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 started
Total System Global Area 320293088 …
Easily Solved Stream Closed Error When Click on Coreapplication
Facing problem with OBIEE 11g?
The following error phrase keep appear when attempted to navigate to Business Intelligence -> coreapplication in Oracle Enterprise Manager Fusion Middleware Control:
“Stream Closed for more information…bla..bla..bla..Server Exception during PPR, #8″
Its irritating rite? See below
Ok, let me guess. Just now, your BIEE server ran out of …
Prepare Disk for ASM Usage in Linux RHEL5
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 …
Backup OCR and voting disk for Oracle 10G
Hi guys, did u use Oracle RAC 10g?
How u guys backup your database? obviously u guys using RMAN right?
Then, how about your OCR (Oracle Cluster Registry) and voting disk (CSS – Oracle Cluster Synchronization Services)?
Since RMAN not include OCR and voting disks during backup, so we need to find other …
Full Export DB Hang Plus EXP-00056 & OCI-21560
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 …
ASM Error and ORA-1092 During DBCA
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 …
A Little Bit Show Off Entry
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 …
Create ASM Disk on RHEL5 or OEL5
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 …
What? Error ORA-600 While Dropping Table Oracle
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 …
Blog RSS Feed
Subscribe via E-mail
Follow Me on Twitter