Para configurar o repositório do yum para OLE ( Oracle Enterprise Linux) 5.4 você deve seguir os seguintes passos: 1-cd /etc/yum.repos.d 2-wget http://public-yum.oracle.com/public-yum-el5.repo 3- Edite o arquivo /etc/yum.repos.d/public-yum-el5.repo , onde os valores [el5_u5_base ] e [ol5_u5_base] são iguais a enabled=0 , mude para 1. Referências: Oracle® Sun Server X2-4 (formerly Sun Fire X4470 M2) Installation Guide for Linux Operating Systems Installing Oracle Unbreakable Enterprise Kernel for Linux Using Local or Remote Console
Direct NFS: please check that oradism is setuid
Enquanto eu estava criando uma tablespace usando um NFS (Network File System), eu recebi o seguinte erro “Direct NFS: please check that oradism is setuid” no alertSID.log . Para resolver este problema, eu fiz os seguintes passos: ls -ld $ORACLE_HOME/bin/oradism chmod u+s oradism ou chmod 4755 (Onde o 4 indica SUID bit set, 7 para permissão total para o owner e 55 para permissão de leitura e execução para o grupo e outros) oradism. chown root:root Tente criar a tablespace usando NFS novamente.
Configurando um banco de dados Oracle 11g para usar Bigfile Tablespace
Para configurar um banco de dados para usar Bigfile Tablespace (tipo de tablespace que usa um único datafile chamado bigfile <> smalffile (padrão)) e somente é “locally managed tablespace with automatic segment space management”, você deve seguir os seguintes passos: — Configure o banco de dados para usar BIGFILE TABLESPACE ALTER DATABASE SET DEFAULT BIGFILE TABLESPACE; — Verificaro o tipo de tablespace padrão no banco de dados: SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = ‘DEFAULT_TBS_TYPE’; — Exemplo para criar uma Bigfile Tablespace: CREATE BIGFILE TABLESPACE BIGTECHDATABASKET DATAFILE ‘/u01/app/oracle/oradata/bigtechdatabasket.dbf’ SIZE…
CALIBRATION I/O ORACLE
Some note from Oracle’s documentation “Applications that spend the majority of CPU time waiting for I/O activity to complete are said to be I/O-bound.Prerequisites for I/O Calibration”. Values to parameters timed_statistics=TRUE “When using file systems, asynchronous I/O can be enabled by setting the FILESYSTEMIO_OPTIONS initialization parameter to SETALL.” DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure SET SERVEROUTPUT ON DECLARE lat INTEGER; iops INTEGER; mbps INTEGER; BEGIN — DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat); DBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 10, iops, mbps, lat); DBMS_OUTPUT.PUT_LINE (‘max_iops = ‘ || iops); DBMS_OUTPUT.PUT_LINE (‘latency = ‘ || lat); dbms_output.put_line(‘max_mbps = ‘ ||…
Check/Example Oracle Requirements to Install Software 11.2.0.3 on Oracle Linux 5.4 – 32 bits
— Confirm ssh package rpm -qa |grep ssh — Oracle Linux 5 and 4 yum install oracle-validated Disk Space for Oracle software: Requirement for Software Files (GB) 4.5G + Disk Space for Data Files (GB) 1.7G = 6.2 GB Packages Oracle Linux 5: binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-common-2.5 glibc-devel-2.5 glibc-headers-2.5 kernel-headers-2.6.18 ksh-20060214 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.2 libgomp-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.81 sysstat-7.0.2 OS Groups: 1-OSDBA group (dba) 2-OSOPER (oper) 3- OSDBA group for ASM (asmdba) From Oracle’s documentation “The Oracle Grid Infrastructure software owner (typically, grid) must…
RMAN-05001: auxiliary filename “filename” conflicts with a file used by the target database
I was trying to do a duplicate database with the same SID to another hostname. Then, during my action I got the error “RMAN-05001: auxiliary “filename” conflicts with a file used by the target database”. To solve this problem I added the sintax “NOFILENAMECHECK” after the “duplicate target database to” command. Below, it is showed the script that I used: run { # Perform allocate channel allocate auxiliary channel t1 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate auxiliary channel t2 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate auxiliary channel t3…
ORA-21561: OID generation failed
I got the error “ORA-21561: OID generation failed” when I tried to connect in rman catalog. To solve this problem, you need to edit the /etc/hosts file and add the name of the machine (host). The text above I wrote in 2015 while I was using the database version 11g. Now in March 2020 I faced the same error and despite of the fact that the version in this new case be 12c and I was trying to clone a virtual marchine from another the solution was the same :…
Managing and Creating a Permanent Tablespaces on Oracle Database 11GR2
Some importants notes from Oracle’s documentation: – “… you cannot rename or drop the SYSTEM tablespace or take it offline.” – “As for the SYSTEM tablespace, management of the SYSAUX tablespace requires a higher level of security and you cannot rename or drop it.” Locally Managed Tablespace : Define through the command EXTENT MANAGEMENT LOCAL where you can: – Choose two types of extent management: AUTOALLOCATE: (default) Database manage extents. CREATE TABLESPACE tech01 DATAFILE ‘/u01/app/oracle/oradata/DB/tech01.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ; UNIFORM: You define the size on command…
ORA-0131:Insufficient Priviledges Debugging requires Debug connect session system priviledges
To solve this error , you have just to run a grant to the username that you can debugging and try again. SQL> grant debug connect session to username;
Getting Instantiating disk: failed while an attempt to create a disk on OEL 6.3
While an attempt to create a disk, I got the follow error: ” Instantiating disk: failed”. Then, I did the follow steps: vi /etc/selinux/config and change the value selinux=enforcing to disabled. Restart your Operating System. Type it getenforce on prompt to your terminal. Try create the disk again through the command oracleasm createdisk DISK1 /dev/sdb1 Follow the example after the reboot: