If you had a problem / crash in your DB Machine and need to investigate it you can simply us this command below to gather information from time where the crash happened:
Oracle GoldenGate Capture for Oracle, ext_cont.prm: Formatting error on: table name SALES_SOUB_ADMIN.CW_OPT_INS, rowid AAAR5fAAGAAJ/3PAB8, X ID 20.12.64, position (Seqno 64, RBA 3474748). Error converting timestamp with timezone from Oracle to ASCII format for column DT_LAST_UPDATE.
As you can see, I have 185 datafiles using ASYNC IO, if you cannot find anyone using ASYNC_ON, than you are not using ASYNC_IO, check your disk_asynch_io initialisation parameter and make sure it is set to TRUE. Also check with your OS admin if your OS is ok to use ASYNC IO.
Description The environment variables ORACLE_HOME and ORACLE_SID determine the instance to which the program connects, and ASMCMD establishes a bequeath connection to it, in the same manner as a SQLPLUS / AS SYSASM. The user must be a member of the OSASM group.
If Flex ASM is enabled, the ASMCMD connects to any one of the ASM instances running in the cluster. The connection to ASM instance does not depend on the environment variables ORACLE_HOME and ORACLE_SID. The ASMCMD alert log shows to which instance ASMCMD is connected to. If the user wants to connect to a specific ASM instance, --inst option should be used to specify the instance name.
Specifying the -V option prints the asmcmd version number and exits immediately.
Specifying the --nocp option disables connection pooling feature for ASMCMD.
Specifying the -v option prints extra information that can help advanced users diagnose problems.
Specify the --privilege option to choose the type of connection. There are only two possibilities: connecting as SYSASM or as SYSDBA.
The default value if this option is unspecified is SYSASM.
Specifying the -p option allows the current directory to be displayed in the command prompt, like so:
ASMCMD [+DATA/ORCL/CONTROLFILE] >
Specifying the --discover option uses discovery string obtained from Listener, does not use ORACLE_SID.
[command] specifies one of the following commands, along with its parameters.
Type "help [command]" to get help on a specific ASMCMD command.
ASMCMD> lsaudconfigparams Type Parameter Name Parameter Value AUDIT FILE MAX SIZE 10000 AUDIT FILE MAX SIZE 10000 AUDIT FILE MAX AGE 5 AUDIT FILE MAX AGE 5 AUDIT_TRAIL_WRITE_MODE QUEUED WRITE MODE AUDIT_TRAIL_WRITE_MODE ASMCMD> showclustermode ASM cluster : Flex mode disabled ASMCMD> showclusterstate Normal ASMCMD> showversion ASM version : 12.1.0.2.0 ASMCMD> spbackup usage: spbackup help: help spbackup ASMCMD> ASMCMD> help spbackup spbackup Backs up an Oracle ASM SPFILE to a back up file.
Synopsis spbackup
Description The options for the spbackup command are described below: source - specifies the source file name destination - specifies the destination file name spbackup should be used when you want to make single or multiple backups of an SPFILE in the same or different disk group without creating an SPFILE in target disk group. Note the following about the use of spbackup: spbackup can back up an Oracle ASM SPFILE from a disk group to a disk group or to an operating system file. spbackup can back up an Oracle ASM SPFILE from an operating system file to a disk group or to an operating system file. spbackup can back up an Oracle ASM SPFILE when the SPFILE is being used by an open Oracle ASM instance. spbackup can make multiple backups of an Oracle ASM SPFILE in the same disk group. spbackup does not affect the GPnP profile. The back up file that is created is not a special file type and is not identified as an SPFILE. This back up file cannot be copied with spcopy. To copy this back up file, use the ASMCMD cp command. To make a copy of a back up file in a disk group that is identified as a SPFILE file: 1. Use the ASMCMD cp command to copy the back up file from the disk group to an operating system file. 2. Use the ASMCMD spcopy command to copy the operating system file to a disk group.
Examples The following are examples of the spbackup command. The first example backs up the SPFILE in the DATA disk group. The second example backs up the SPFILE from the DATA disk group to the FRA disk group. ASMCMD>spbackup +DATA/asm/asmparameterfile/registry.253.721810181 +DATA/spfileBackASM.bak ASMCMD>spbackup +DATA/asm/asmparameterfile/registry.253.721810181 +FRA/spfileBackASM.bak
See Also cp spcopy
ASMCMD> help chtmpl chtmpl Changes the attributes of a template.
Description The options for the chtmpl command are described below. -G diskgroup - Name of the disk group. template - Name of the template to change. --striping {coarse | fine} - Striping specification, either coarse or fine. --redundancy { high | mirror | unprotected} - Redundancy specification, either high, mirror, or unprotected. --primary { hot | cold } - Intelligent Data Placement specification for primary extents, either hot or cold region. --secondary { hot | cold } - Intelligent Data Placement specification for secondary extents, either hot or cold region. At least one of these options is required: --striping, --redundancy, --primary, --secondary.
Examples The following is an example of the chtmpl command that updates the mytemplate template of the DATA disk group. The redundancy attribute is set to high and the striping attribute is set to fine. ASMCMD [+]>chtmpl -G DATA --redundancy high --striping fine mytemplate
CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888. cellsrvStatus: stopped msStatus: running rsStatus: running
Edit your /etc/hosts file and comment out this line below:
The file that the installation is complaining is :
Following executables are active :
/dbgc/products/12.1.0/rdbms/lib/libclntsh.so.12.1
Log file location: /dbgc/products/12.1.0/rdbms/cfgtoollogs/opatch/opatch2014-06-27_15-55-45PM_1.log
Use this simple command to check the health of your installation (GI and DB 12c):
[grid@xxxxxx bwdhdbpr106]$ cluvfy comp health
Verifying Health Check
Total memory check passed
Available memory check passed
Swap space check failed
Check failed on nodes: bwdhdbpr106
Free disk space check passed for "bwdhdbpr106:/tmp"
Check for multiple users with UID value 500 passed
User existence check passed for "grid"
Group existence check passed for "oinstall"
Membership check for user "grid" in group "oinstall" [as Primary] passed
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "make"
Package existence check passed for "binutils"
Package existence check passed for "gcc(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for "compat-libstdc++-33(x86_64)"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "gcc-c++(x86_64)"
Package existence check passed for "libaio-devel(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for "libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "ksh"
Check for multiple users with UID value 0 passed
Starting check for consistency of primary group of root user
Check for consistency of root user's primary group passed
Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed
Checking if CTSS Resource is running on all nodes...
CTSS resource check passed
Querying CTSS for time offset on all nodes...
Query of CTSS for time offset passed
Check CTSS state started...
CTSS is in Observer state. Switching over to clock synchronization checks using NTP
Starting Clock synchronization checks using Network Time Protocol(NTP)...
Checking daemon liveness...
Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes
NTP common Time Server Check started...
Check of common NTP Time Server passed
Clock time offset check from NTP Time Server started...
Clock time offset check passed
Clock synchronization check using Network Time Protocol(NTP) passed
Oracle Cluster Time Synchronization Services check passed
Checking OHASD integrity...
OHASD integrity check passed
Checking CRS integrity...
Clusterware version consistency passed.
CRS integrity check passed
Checking Single Client Access Name (SCAN)...
Checking TCP connectivity to SCAN Listeners...
TCP connectivity to SCAN Listeners exists on all cluster nodes
Checking name resolution setup for "oemgt-scan.b2w"...
Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...
Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed
ERROR:
PRVG-1101 : SCAN name "oemgt-scan.b2w" failed to resolve
ERROR:
PRVF-4657 : Name resolution setup check for "oemgt-scan.b2w" (IP address: 10.13.0.227) failed
ERROR:
PRVF-4664 : Found inconsistent name resolution entries for SCAN name "oemgt-scan.b2w"
Checking SCAN IP addresses...
Check of SCAN IP addresses passed
Verification of SCAN VIP and Listener setup failed
Checking node application existence...
Checking existence of VIP node application (required)
VIP node application check passed
Checking existence of NETWORK node application (required)
NETWORK node application check passed
Checking existence of ONS node application (optional)
ONS node application check passed
The disk free space for file system path "/opt/oracle/12.1.0/grid" is sufficient on all nodes
Verification of Health Check was unsuccessful on all the specified nodes.
[grid@xxxxx bwdhdbpr106]$
If you got this message while running post-installation root.sh script GI 12c:
/proc/net/ipv6_route: No such file or directory
You can safe ignore it as per note: "Error "/proc/net/ipv6_route: no such file or directory" while Running root.sh or Srvctl Modify Nodeapps Commands (Doc ID 1616776.1)"
1-Create user, groups and OH directory on all cells
dcli -k -g dbnodes -l root --Configure user equivalence for root if not already done dcli -g dbnodes -l root /usr/sbin/useradd -u 503 -g oinstall -G dba,asmdba,asmadmin,racoper orabob --Add user dcli -g dbnodes -l root id orabob --Check user dcli -g dbnodes -l root mkdir -p /u01/app/oracle/product/11.2.0.4/dbbob --Create OH directory dcli -g dbnodes -l root chown -R orabob:oinstall /u01/app/oracle/product/11.2.0.4/dbbob --Change OH permission dcli -k -g dbnodes -l orabob --Configure user equivalence for new user
2-Change /etc/security/limits.conf on all cels (Use the same values as your other user created by OneCommand)
oratkc soft core unlimited
oratkc hard core unlimited
orabob soft nproc 131072
orabob hard nproc 131072
orabob soft nofile 65536
orabob hard nofile 65536
orabob soft memlock 396748650
orabob hard memlock 396748650
3-Login with new user and run runInstaller to install OH Binaries
5.2-Check with there is enough system space: $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /opt/oracle.SupportTools/onecommand/Software/patches/18371656/18371656/ 5.3-Apply the BP patch on OH (GI was already applied on past). Login with ROOT user and make sure opatch is in PATH. opatch auto /opt/oracle.SupportTools/onecommand/Software/patches/18371656/18371656/ -oh /u01/app/oracle/product/11.2.0.4/dbbob OBS: if you still don't have, create ocm file using command "$ORACLE_HOME/OPatch/ocm/bin/emocmrsp"
If you want to automatize your PDBs to open soon as CDB opens, create a trigger like below:
sqlplus / as sysdba create or replace trigger OPEN_PDBS after startup on database begin execute immediate 'alter pluggable database all open'; end OPEN_PDBS; / --Testing SQL> shut immediate SQL> startup SQL> select name, open_mode from v$pdbs; Best Regards, Paulo Portugal
1-First create the directory of datafiles (if using FS of course) mkdir -p /u01/oradata/SID 2-Now, create the database connected in CDB$ROOT sqlplus / as sysdba
create pluggable database yourPDB admin user your_PDB_admin identified by mnager123roles = (DBA)FILE_NAME_CONVERT='/u01/app/oracle/oradata/cdb1/pdbseed','/u01/oradata/SID'); 3-Check new services:
sqlplus / as sysdba SQL> select name, con_id from v$active_services; Simple like that. Best Regards,
--Check current container SELECT SYS_CONTEXT ('USERENV', 'CON_NAME') FROM DUAL;
--Switch to a different container ALTER SESSION SET CONTAINER = salespdb; ALTER SESSION SET CONTAINER = CDB$ROOT; ALTER SESSION SET CONTAINER = PDB$SEED;
--Execute one command in many PDBs at the same time
DECLARE
c1 INTEGER;
rowcount INTEGER;
taskList VARCHAR2(32767) :=
'DECLARE
PRAGMA AUTONOMOUS TRANSACTION;
BEGIN
-- Create the hr.identact table.
EXECUTE IMMEDIATE
''CREATE TABLE hr.identact
(actionno NUMBER(4) NOT NULL,
action VARCHAR2 (10))'';
EXECUTE IMMEDIATE
''INSERT INTO identact VALUES(1, 'ACTION1')'';
-- A commit is required if the tasks include DML.
COMMIT;
EXCEPTION
WHEN OTHERS THEN
-- If there are errors, then drop the table.
BEGIN
EXECUTE IMMEDIATE ''DROP TABLE identact'';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END;';
TYPE containerListType IS TABLE OF VARCHAR2(128) INDEX BY PLS_INTEGER;
containerList containerListType;
BEGIN
containerList(1) := 'PDB1';
containerList(2) := 'PDB2';
c1 := DBMS_SQL.OPENCURSOR;
FOR conIndex IN containerList.first..containerList.last LOOP
DBMS_OUTPUT.PUT_LINE('Creating in container: ' || containerList(conIndex));
DBMS_SQL.PARSE(c => c1 ,
statement => taskList,
language_flag => DBMS_SQL.NATIVE,
edition= > NULL,
apply_crossedition_trigger => NULL,
fire_apply_trigger => NULL,
schema => 'HR',
container => containerList(conIndex));
rowcount := DBMS_SQL.EXECUTE(c=>c1);
END LOOP;
DBMS_SQL.CLOSE_CURSOR(c=>c1);
END;
/
--Change open mode of PDBs databases ALTER PLUGGABLE DATABASE salespdb, hrpdb OPEN READ WRITE; ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE; ALTER PLUGGABLE DATABASE ALL EXCEPT salespdb, hrpdb CLOSE IMMEDIATE;
--Open a PDB in read write mode STARTUP PLUGGABLE DATABASE hrpdb OPEN
--Open a PDB in restricted mode STARTUP PLUGGABLE DATABASE hrpdb RESTRICT
--Open a PDB in restricted and read only mode STARTUP PLUGGABLE DATABASE hrpdb OPEN READ ONLY RESTRICT
--Open a PDB in read only mode STARTUP PLUGGABLE DATABASE hrpdb OPEN READ ONLY
--If the PDB is already open, use FORCE to close and open in read write mode STARTUP PLUGGABLE DATABASE hrpdb FORCE
--Alter system parameters in all containers ALTER SYSTEM SET OPEN_CURSORS = 200 CONTAINER = ALL;
--Execute DML/DDL in a current container CREATE USER testpdb IDENTIFIED BY password
DEFAULT TABLESPACE pdb1_tbs
QUOTA UNLIMITED ON pdb1_tbs
CONTAINER = CURRENT;
--Create a COMMON user in a CDB (user in all PDBS). Common user MUST start with c##
CREATE USER c##testcdb IDENTIFIED BY password
DEFAULT TABLESPACE cdb_tbs
QUOTA UNLIMITED ON cdb_tbs
CONTAINER = ALL;
--Run catblock.sql script in all containers at once perl catcon.pl -u SYS -d $ORACLE_HOME/rdbms/admin -b catblock_output catblock.sql
--Run catblock.sql script in specif CDBs perl catcon.pl -u SYS -U SYS -d $ORACLE_HOME/rdbms/admin -l '/disk1/script_output' -c 'HRPDB SALESPDB' -b catblock_output catblock.sql
--Run catblock script in a CDB except from PDBs hrpdb and salespdb perl catcon.pl -u SYS -d $ORACLE_HOME/rdbms/admin -l '/disk1/script_output' -C 'HRPDB SALESPDB' -b catblock_output catblock.sql
--Close a PDB ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
--Change open mode of a PDB to read only ALTER PLUGGABLE DATABASE OPEN READ ONLY;
--Bring a datafile of a PDB online ALTER PLUGGABLE DATABASE DATAFILE '/u03/oracle/pdb1_01.dbf' ONLINE;
--Change the default tablespace of a PDB ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE pdb1_tbs;
--Change global database name for a PDB ALTER PLUGGABLE DATABASE RENAME GLOBAL_NAME TO salespdb.example.com;
--Create a service for a PDB using SRVCTL srvctl add service -db mycdb -service salesrep -pdb salespdb
--Create a service for a PDB using DBMS_SERVICE
BEGIN
DBMS_SERVICE.CREATE_SERVICE(
service_name => 'salesrep',
network_name => 'salesrep.example.com'); END; /
--General queries SELECT CDB FROM V$DATABASE; COLUMN NAME FORMAT A8 SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID; COLUMN PDB_NAME FORMAT A15 SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
COLUMN NAME FORMAT A15 COLUMN RESTRICTED FORMAT A10 COLUMN OPEN_TIME FORMAT A30 SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
--Show tables owned by specif schemas in Multiples PDBs COLUMN PDB_NAME FORMAT A15 COLUMN OWNER FORMAT A15 COLUMN TABLE_NAME FORMAT A30 SELECT p.PDB_ID, p.PDB_NAME, t.OWNER, t.TABLE_NAME FROM DBA_PDBS p, CDB_TABLES t WHERE p.PDB_ID > 2 AND t.OWNER IN('HR','OE') AND p.PDB_ID = t.CON_ID ORDER BY p.PDB_ID;
--Show users in multiple PDBs COLUMN PDB_NAME FORMAT A15 COLUMN USERNAME FORMAT A30 SELECT p.PDB_ID, p.PDB_NAME, u.USERNAME FROM DBA_PDBS p, CDB_USERS u WHERE p.PDB_ID > 2 AND p.PDB_ID = u.CON_ID ORDER BY p.PDB_ID;
--Shoe datafiles for each PDBs COLUMN PDB_ID FORMAT 999 COLUMN PDB_NAME FORMAT A8 COLUMN FILE_ID FORMAT 9999 COLUMN TABLESPACE_NAME FORMAT A10 COLUMN FILE_NAME FORMAT A45 SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME FROM DBA_PDBS p, CDB_DATA_FILES d WHERE p.PDB_ID = d.CON_ID ORDER BY p.PDB_ID;
--Shoe tempfiles in CDB COLUMN CON_ID FORMAT 999 COLUMN FILE_ID FORMAT 9999 COLUMN TABLESPACE_NAME FORMAT A15 COLUMN FILE_NAME FORMAT A45 SELECT CON_ID, FILE_ID, TABLESPACE_NAME, FILE_NAME FROM CDB_TEMP_FILES ORDER BY CON_ID;
--Show services associated with a PDBs COLUMN NETWORK_NAME FORMAT A30 COLUMN PDB FORMAT A15 COLUMN CON_ID FORMAT 999 SELECT PDB, NETWORK_NAME, CON_ID FROM CDB_SERVICES WHERE PDB IS NOT NULL AND CON_ID > 2 ORDER BY PDB;
--Show current container ID and name SHOW CON_ID SHOW CON_NAME SELECT CON_NAME_TO_ID('HRPDB') FROM DUAL; SELECT CON_DBID_TO_ID(2226957846) FROM DUAL;
--History of PDBs COLUMN DB_NAME FORMAT A10 COLUMN CON_ID FORMAT 999 COLUMN PDB_NAME FORMAT A15 COLUMN OPERATION FORMAT A16 COLUMN OP_TIMESTAMP FORMAT A10 COLUMN CLONED_FROM_PDB_NAME FORMAT A15 SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME FROM CDB_PDB_HISTORY WHERE CON_ID > 2 ORDER BY CON_ID;
--Check open mode of all PDBs
SELECT NAME,OPEN_MODE FROM V$PDBS WHERE CON_ID > 2;
I just finish an ODA X4 installation using Oracle VM and deployed a WLS template. Everything was fine. You must not forget to download 2.9 Configurator for WLS. The 2.7 doesn't work.
Some commands that may help admin this env:
--COmandos OAKCLI Abramus
1-Modify some resources on a VM:
cd /opt/oracle/oak/bin ./oakcli stop vm WLS_1_mydomain_mycluster_1 ./oakcli configure vm WLS_1_mydomain_mycluster_1 -vcpu 3 -memory 4196 ./oakcli start vm WLS_1_mydomain_mycluster_1
2-Completely delete a VM
cd /opt/oracle/oak/bin
./oakcli stop vm WLS_mydomain_ManagedServer_8
./oakcli delete vm WLS_mydomain_ManagedServer_8
3-Undeploy and WLS environment
./cleanup.sh
4-Accessing your Admin Console of WLS env:
https://admin-server-ip:listen-port/console https://10.0.1.186:7001/console
5-Show your VMs created:
oakcli show vm oakcli show vmtemplates
6-Create new CPU pools
I just installed APEX on two new environments. This is an EBS database and they have the same version of database 11.2.0.3 and applications 12.1.3. No error in APEX installation LOG.
On first installation, everything went fine without any major problem. On second installation, using the same procedure, I finished the installation but I couldn't access the APEX webpage. Neither /apex nor /apex_admin.
After trying to find the error, I saw that APEX needs DISPATCHERS and Oracle Support recommended to set it on my database.
So, the solution was:
1-Set Dispatchers on your database because it is a pre-req to work XDB.
2-Look at you listener status and see the XDB port there:
[oradsv@f2chml admin]$ sqlplus / as sysdba
@
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 30 12:28:08 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
epgstat.sql
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
+--------------------------------------+
| XDB protocol ports: |
| XDB is listening for the protocol |
| when the protocol port is non-zero. |
+--------------------------------------+
HTTP Port FTP Port
--------- --------
8080 0
1 row selected.
+---------------------------+
| DAD virtual-path mappings |
+---------------------------+
Virtual Path DAD Name
-------------------------------- --------------------------------
/apex/* APEX
1 row selected.
+----------------+
| DAD attributes |
+----------------+
DAD Name DAD Param DAD Value
------------ ------------------------ ----------------------------------------
APEX database-username ANONYMOUS
default-page apex
document-table-name wwv_flow_file_objects$
request-validation-funct wwv_flow_epg_include_modules.authorize
ion
+---------------------------------------------------+
| DAD authorization: |
| To use static authentication of a user in a DAD, |
| the DAD must be authorized for the user. |
+---------------------------------------------------+
no rows selected
+----------------------------+
| DAD authentication schemes |
+----------------------------+
DAD Name User Name Auth Scheme
-------------------- -------------------------------- ------------------
APEX ANONYMOUS Anonymous
1 row selected.
+--------------------------------------------------------+
| ANONYMOUS user status: |
| To use static or anonymous authentication in any DAD, |
| the ANONYMOUS account must be unlocked. |
+--------------------------------------------------------+
Database User Status
--------------- --------------------
ANONYMOUS OPEN
1 row selected.
+-------------------------------------------------------------------+
| ANONYMOUS access to XDB repository: |
| To allow public access to XDB repository without authentication, |
| ANONYMOUS access to the repository must be allowed. |
+-------------------------------------------------------------------+
I just installed 4.2.5 APEX Installation and the component stays invalid.
I check wich object was invalid and got this package body below. I tried to compile and got SHARED POOL memory error.
SQL> alter package apex_040200.WWV_FLOW_GEN_API2 compile body;
alter package apex_040200.WWV_FLOW_GEN_API2 compile body
*
ERROR at line 1:
ORA-04031: unable to allocate 91248 bytes of shared memory ("shared pool","unknown object","PLMCD^72ae492e","BAMIMA: Bam Buffer")
#####################################
I them flush shared and buufer cache pool and compiled again. This works for me:
SQL> alter system flush buffer_cache ;
System altered.
SQL> alter system flush shared_pool;
System altered.
SQL> alter package apex_040200.WWV_FLOW_GEN_API2 compile body;
Check if that is a new table created with XMLYPE column data type.
select distinct data_type from dba_tab_columns ;
select object_name,object_type, created from dba_objects where object_name in (select table_name from dba_tab_columns where data_type= 'XMLTYPE');
Add a new line in your EXTRACT parameter excluding this table from replication:
run {
allocate channel c1 type disk format '/migra_UOL/APPRD/%d_APPRD_BKP_12_MAR_2014_%u_%s_%p';
set limit channel c1 kbytes = 20000000;
allocate channel c2 type disk format '/migra_UOL/APPRD/%d_APPRD_BKP_12_MAR_2014_%u_%s_%p';
set limit channel c2 kbytes = 20000000;
allocate channel c3 type disk format '/migra_UOL/APPRD/%d_APPRD_BKP_12_MAR_2014_%u_%s_%p';
set limit channel c3 kbytes = 20000000;
allocate channel c4 type disk format '/migra_UOL/APPRD/%d_APPRD_BKP_12_MAR_2014_%u_%s_%p';
set limit channel c4 kbytes = 20000000;
allocate channel c5 type disk format '/migra_UOL/APPRD/%d_APPRD_BKP_12_MAR_2014_%u_%s_%p';
set limit channel c5 kbytes = 20000000;
allocate channel c6 type disk format '/migra_UOL/APPRD/%d_APPRD_BKP_12_MAR_2014_%u_%s_%p';
set limit channel c6 kbytes = 20000000;
backup current controlfile format '/migra_UOL/APPRD/ctl_for_APPRD_antes.ctl';
backup database include current controlfile tag = 'Backup_APPRD_12_Mar_2014';
backup current controlfile format '/migra_UOL/APPRD/ctl_for_APPRD_depois.ctl';
allocate channel ch1 type disk format '/migra_UOL/APPRD/%d_ARCH_%u_%s_%p';
backup archivelog all;
}
PS: I used kbytes to set a maximum file size so I could move these files while backup is still running without going out of space.
After cloning Oracle 8i binaries I was getting these errors below when trying to start a sqlplus session:
sqlplus
Could not load program sqlplus:
Symbol resolution failed for sqlplus because:
Symbol pw_post (number 274) is not exported from dependent
module /unix.
Symbol pw_wait (number 275) is not exported from dependent
module /unix.
Symbol pw_config (number 276) is not exported from dependent
module /unix.
Symbol aix_ora_pw_version3_required (number 277) is not exported from dependent
module /unix.
Examine .loader section symbols with the 'dump -Tv' command.
Even after checking LIBPATH, LD_LIBRARY_PATH, OS Patches, Relinking binaries without any error the same problem persists.
I them found the patch in MOS 2896876. Ifter downloading it, run the ROOTPRE.sh as ROOT and relink all again.
