Code Snippet

Just another Code Snippet site

Databae

ORA-01102: cannot mount database in exclusive

is often due to one of the following reasons: – there is still an “sgadef.dbf” file in the “ORACLE_HOME/dbs” directory – the processes for Oracle (pmon, smon, lgwr and dbwr) still exist – shared memory segments and semaphores still exist even though the database has been shutdown – there is a “ORACLE_HOME/dbs/lk” file

,

[Oracle] Enable partitions

Check if partitionning is enabled or not : To enable partition feature : On Solaris, ‘make’ could be installed using following packages : make libgcc libintl libiconv libintl-3.4.0-sol10-x86-local make-3.82-sol10-x86-local libiconv-1.14-sol10-x86-local libgcc-3.3-sol10-intel-local

, , , ,