Flashback database / New Feature in oracle 10g

Dear Friens back to my Oracle journey after long time. This was interview question ask to my friend during the interview last week.Lots of questions relate with flashback and 10g / 11g new features.       As requested by him decided to put new post on  Flashback database. Enable Flash Recovery Area / Flashback database Flashback [...]

Read Full Post »

Oracle 10g Installation & Configuration On Solaris

Dear Friend, due to busy schedule writing new post after long time and extremely sorry for that. Step 1 Install the Operating System Note: No specified operating system patches are required with Solaris 10 OS. Step 2 Make sure that following software packages has been installed. SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWilof SUNWxwfnt [...]

Read Full Post »

ora-12505 connection refused the specified sid

Hi,today one developer got this error while connecting to new production server. Problem: User was not able to connect to production server throght the application the error was, ORA-12505 Connection refused, the specified SID (retaildb) was not recognized by the Oracle server.” C:Documents and SettingsAdministrator>tnsping Global TNS Ping Utility for 32-bit Windows: Version 9.2.0.6.0 – [...]

Read Full Post »

ORA-01157: cannot identify/lock data file / ORA-01110: data file/ EXP-00056: ORACLE error 1157 encountered

Dear all, yesterday I face small issue which I would like to share with you guy’s.It was temporary tablespace issue.This was development server for storage was recently changed.As mount point was changed but control file was having the previous temp file details so got the error while exporting schema.Just drop the old tempfile and created new [...]

Read Full Post »