Viewing Category » Oracle
26 January 2012

Easily Solved Stream Closed Error When Click on Coreapplication

Post Thumbnail of Easily Solved Stream Closed Error When Click on Coreapplication
 OBIEE, Oracle, Software         No comments

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 …

10 November 2011

Prepare Disk for ASM Usage in Linux RHEL5

Post Thumbnail 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 …

9 November 2011

Backup OCR and voting disk for Oracle 10G

Post Thumbnail of Backup OCR and voting disk for Oracle 10G
 Oracle, Software         No comments

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 …

11 August 2011

Full Export DB Hang Plus EXP-00056 & OCI-21560

Post Thumbnail of 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 …

11 February 2011

ASM Error and ORA-1092 During DBCA

Post Thumbnail of 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 …

11 January 2011

A Little Bit Show Off Entry

Post Thumbnail of 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 …

20 December 2010

Create ASM Disk on RHEL5 or OEL5

Post Thumbnail of 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 …

15 December 2010

What? Error ORA-600 While Dropping Table Oracle

Post Thumbnail of What? Error ORA-600 While Dropping Table Oracle
 Oracle, Software, Technology         1 comment

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 …

5 October 2010

Oracle 10g Grid Control 503 Service Unavailable

Post Thumbnail of Oracle 10g Grid Control 503 Service Unavailable

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 …

28 September 2010

Oracle RAC Command to Remember

Post Thumbnail of Oracle RAC Command to Remember

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 <nodename>
Stop All …

 Page 1 of 2  1  2 »
Delighted Black designed by Christian Myspace In conjunction with Ping Services   |   French Teacher Jobs   |   Maths Teacher Jobs