Issue : during oracle installation, if getting ntcrontab error or make file error, den check all packages have been installed properly using the below command,
rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch --qf '%{name}.%{arch}\n'|sort
Other errors :
ORA-01045: user U1 lacks CREATE SESSION privilege; logon denied
ORA-00060 : Deadlock detected while waiting for resources.
ORA-01555 snapshot error, caused due to read consistency as no space available in undo tablespace.
ORA-01653, Unable to extent error, caused due to lack of space in the datafile.
ORA-12154 , TNS could not resolve the connect identifier specified.
$oerr ora 00439
00439, 00000, "feature not enabled: %s"
// *Cause: The specified feature is not enabled.
// *Action: Do not attempt to use this feature.
cause : most probably value for partitioning in v$option will be in false, which means the binaries/rdbms for partition is not configured properly. This might be
the reason of inproper installation.
Fix : Reinstall the oracle again and make sure to backup all before going for reinstallation.
Problem :
SQL> startup pfile='/home/oracle/Desktop/zod/admin/pfile/initzod.ora'
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 1222168 bytes
Variable Size 213912040 bytes
Database Buffers 620756992 bytes
Redo Buffers 2969600 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
fix :
rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch --qf '%{name}.%{arch}\n'|sort
Other errors :
ORA-01045: user U1 lacks CREATE SESSION privilege; logon denied
ORA-00060 : Deadlock detected while waiting for resources.
ORA-01555 snapshot error, caused due to read consistency as no space available in undo tablespace.
ORA-01653, Unable to extent error, caused due to lack of space in the datafile.
ORA-12154 , TNS could not resolve the connect identifier specified.
$oerr ora 00439
00439, 00000, "feature not enabled: %s"
// *Cause: The specified feature is not enabled.
// *Action: Do not attempt to use this feature.
cause : most probably value for partitioning in v$option will be in false, which means the binaries/rdbms for partition is not configured properly. This might be
the reason of inproper installation.
Fix : Reinstall the oracle again and make sure to backup all before going for reinstallation.
Problem :
SQL> startup pfile='/home/oracle/Desktop/zod/admin/pfile/initzod.ora'
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 1222168 bytes
Variable Size 213912040 bytes
Database Buffers 620756992 bytes
Redo Buffers 2969600 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
fix :
http://osqlplsql.blogspot.in/ -- oracle sql & Plsql
ReplyDeletehttp://lss-arvind.blogspot.in/ -- Linux & shell script
http://oracle-arvind.blogspot.in/ -- Oracle Dba
http://postgres-arvind.blogspot.in/ -- Postgres Dba.
http://ora-errors-arvind.blogspot.in/ -- Oracle errors
THUMBS UP
ReplyDelete