Un punto unico de encuentro para compartir el conocimiento sobre bases de datos.
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
Move LOBSEGMENT to different tablespace
create table tmp01 (id number, xml_data XMLTYPE) tablespace users;
srvctl start service; PRKP-1030 : Failed to start the service...ORA-44305: service ... is running
Just my idea. After I stoped service on RAC, and then need to start. But It had a problem.
$ srvctl start service -d DB -s S01 -i DB4
PRKP-1030 : Failed to start the service S01.
CRS-0215: Could not start resource 'ora.DB.S01.DB4.srv'
You can read from my blog http://surachartopun.com/2009/03/srvctl-start-service-prkp-1030-failed.html
From Above Error, that's make me!... Bad, I can not start service.
So, I tried another idea... (try to force stop)
$ srvctl stop service -d DB -s S01 -i DB4
PRKP-1065 : Service S01 is already stopped on instance DB4.
Converting NATIONAL CHARACTER SET (NLS_NCHAR_CHARACTERSET) AL16UTF16 to UTF8
Asian data in AL16UTF16 is more compact than UTF8 and save disk space and have less disk I/O with Asian data. But The maximum lengths for NCHAR and NVARCHAR2 are 1000 and 2000 characters, which is less than the lengths for NCHAR (2000) and NVARCHAR2 (4000) in UTF8.
Sea un heroe, sea proactivo!
Comiésemos este año nuevo con una nueva mentalidad, o una resolución de año nuevo si quieres pensarlo de ese modo, dejemos de ser reactivos y empecemos a ser proactivos. Ser proactivo va a ayudarlo a reducir sus costos en administración de base de datos, incrementar tu nivel de eficiencia, ayudarte a cumplir más fácilmente los SLA’s y lo que es mejor salvar tus horas de sueño cuando estés de turno.
