Un punto unico de encuentro para compartir el conocimiento sobre bases de datos.


Switch SELinux "Enforcing" mode to "Permissive" mode

Security-Enhanced Linux (SELinux) is a security architecture integrated into the 2.6.x kernel using the Linux Security Modules (LSM). It is a project of the United States National Security Agency (NSA) and the SELinux community. SELinux integration into Red Hat Enterprise Linux was a joint effort between the NSA and Red Hat.

Any Idea About "INITRANS"

What is "INITRANS"?
Specify the initial number of concurrent transaction entries allocated within each data block allocated to the database object. This value can range from 1 to 255 and defaults to 1, with the following exceptions: (on10g MAX_TRANS 's ignored )

Check Oracle Binary Support RAC Feature *rac_on)

It's a simple thing for someone to check RAC is linked in the Oracle Binary.
when we need to convert Single database to RAC database... we may find Error

ORA-00439: feature not enabled: Real Application Clusters

DB_FILES... think???

DB_FILES initialization parameter... why i should to think about it?

When starting Oracle database instance, DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and maximum number of datafiles that can be created for the instance.

crsctl.bin: error while loading shared libraries: libnnz11.so: cannot restore segment prot after reloc: Permission

# /u01/app/oracle/product/11.1/db/bin/localconfig add

/u01/app/oracle/product/11.1/db/bin/crsctl.bin: error while loading shared libraries: /u01/app/oracle/product/11.1/db/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
/u01/app/oracle/product/11.1/db/bin/clscfg.bin: error while loading shared libraries: /u01/app/oracle/product/11.1/db/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!

I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %

$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 12722 96.4 0.2 19560 4600 pts/5 R 15:36 0:06 sqlplus

So, found out on metalink... (338461.1)
SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time (Linux x86)

Used "strace" :

$ strace sqlplus -V 2>&1 |less



Syndicate

Syndicate content

Follow DatabasesLA on Twitter

Who's online

There are currently 0 users and 0 guests online.

Estadisticas

Locations of visitors to this page

hidden hit counter