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 »

Reducing datafile size to recover free space / ORA-03297: file contains used data beyond requested RESIZE value

At time, we want to recover some space from database just to allocate the same to some other tablespace or to return it back to OS disk. This situation arises many times. And many time we hit with error “ORA-03297: file contains used data beyond requested RESIZE value“. The concept is simple and many of [...]

Read Full Post »