FaizSulaiman.com

 Oracle,Software,Technology         2 comments

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         9 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 …

 Linux Tips,Online,Software,Technology         6 comments

How to enable Oracle Enterprise Manager for Oracle 10g Database Control Release 10.2.0.4?
Hey, it easy right. Just type the following command to start the OracleDBConsole:
emctl start dbconsole
But, how about if the following statement came out?
Unable to determine local host from URL REPOSITORY_URL=http://your-url.com.my:%EM_UPLOAD_PORT%/em/upload as shown on picture below:

Hurm, I don’t wanna …

 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 …