FaizSulaiman.com

 Oracle, Software, Technology, Windows Matter         No comments

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 …

 Linux Tips, Oracle, Software, Technology         No comments

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 …

 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 …

 Oracle, Software, Technology         No comments

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 …

 Oracle, Software, Technology         1 comment

Yesterday, I am attempted a creation of auto start/stop script for Oracle Database 11g R2 on Solaris 10 (SPARC).
As usual (I’ve created on Linux environment before), I’ve created the auto start script on /etc/init.d/.
Then created symbolic links on /etc/rc3.d to the script that I created on /etc/init.d (in this case …

 Oracle, Software, Technology, Windows Matter         4 comments

Oracle Error ORA-12557 – TNS:protocol adapter not loadable occurs on my Windows machine whenever I want to access sqlplus using command prompt.
Once hit [Enter] button after issuing command sqlplus / as sysdba, an unwanted popup appear  and it said:
The procedure entry point snlseFreeSecAttrib could not be located in the dynamic …

 Linux Tips, Oracle, Software, Technology, Windows Matter         4 comments

Owh, ORA-12560: TNS:protocol adapter error..
This is the error that always I faced and always forgot what is this error about.
This error was like dejavu all over again. I ever faced and solved this but, how eh? Every time this error comes, I’m start looking and navigate to tnsnames.ora, sqlnet.ora and …

 General, Linux Tips, Online, Software, Technology         4 comments

Yesterday I have done a Preventive Maintenance (PM) for Oracle database at Ministry of Education Malaysia. At the end of PM when I want to retrieve the final report for Oracle database (after compiling, analyzing etc), suddenly…the database get mad and I can’t connect to any user in that Oracle …