ORA-29540: class oracle/CDC/PublishApi does not exist
SQL> BEGIN
2 DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE(
3 owner => 'cdcpub',
4 change_table_name => 'products_ct',
5 change_set_name => 'PRODUCTS_CS',
6 source_schema => 'MFCAMS',
7 source_table => 'PRODUCTS',
8 column_type_list => 'PROD_ID NUMBER(6), PROD_NAME VARCHAR2(50),PROD_LIST_PRICE NUMBER(8,2),JOB_ID VARCHAR2(10), DEPARTMENT_ID NUMBER(4)',
9 capture_values => 'both',
10 rs_id => 'y',
11 row_id => 'y',
12 user_id => 'y',
13 timestamp => 'y',
14 object_id => 'n',
15 source_colmap => 'n',
16 target_colmap => 'y',
17 options_string => 'TABLESPACE USER_DATA');
18 END;
19 /
BEGIN
*
ERROR at line 1:
ORA-29540: class oracle/CDC/PublishApi does not exist
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 611
ORA-06512: at line 2
Solutions
1.Run the sql rmcdc.sql
SQL>$ORACLE_HOMErdbms/admin/rmcdc.sql
2. Run the sql initcdc.sql
SQL>$ORACLE_HOME/rdbms/admin/initcdc.sql
Friday, October 30, 2009
ORA-29538: Java not installed
ORA-29538: Java not installed
ERROR at line 1:
ORA-29538: Java not installed
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 611
ORA-06512: at line 2
Solutions
$ORACLE_HOME/javavm/install
To load this package into the database, go to the directory location and login to SQL*Plus as the "SYS" user. Then, type the following:
SQL> spool initjvm.log
SQL> @initjvm.sql
ERROR at line 1:
ORA-29538: Java not installed
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 611
ORA-06512: at line 2
Solutions
$ORACLE_HOME/javavm/install
To load this package into the database, go to the directory location and login to SQL*Plus as the "SYS" user. Then, type the following:
SQL> spool initjvm.log
SQL> @initjvm.sql
Thursday, October 29, 2009
Install and configure Java Development Kit 6 (jdk 6) on Oracle Enterprise Linux.
Download Java Development Kit 6
You can download JDK 6 versions from e.g. Sun's web site.
Select "Accept License Agreement".
Then select "Linux self-extracting file" for Linux Platform.
Save the file "jdk-6--linux-i586.bin" to e.g . /usr/local or
Install JDK or JRE
# cd /usr/local
# chmod +x jdk-6-linux-i586.bin
# ./jdk-6-linux-i586.bin
... ...
Do you agree to the above license terms? [yes or no]
yes
Press the spacebar to read Sun Microsystems, Inc. Binary Code License Agreement, then input "yes" and press Enter.
... ...
... ...
Done.
Set the environment variables
You can add the following lines to /etc/profile or .bash_profile file in your home directory. And then run "source /etc/profile" or ". .bash_profile" so that the environment variables can take effect.
export JAVA_HOME=/usr/local/jdk1.6.0
export PATH=$JAVA_HOME/bin:$PATH
Check the JDK version
# java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build 1.6.0-b105)
Java HotSpot(TM) Client VM (build 1.6.0-b105, mixed mode, sharing)
You can download JDK 6 versions from e.g. Sun's web site.
Select "Accept License Agreement".
Then select "Linux self-extracting file" for Linux Platform.
Save the file "jdk-6-
Install JDK or JRE
# cd /usr/local
# chmod +x jdk-6-linux-i586.bin
# ./jdk-6-linux-i586.bin
... ...
Do you agree to the above license terms? [yes or no]
yes
... ...
... ...
Done.
Set the environment variables
You can add the following lines to /etc/profile or .bash_profile file in your home directory. And then run "source /etc/profile" or ". .bash_profile" so that the environment variables can take effect.
export JAVA_HOME=/usr/local/jdk1.6.0
export PATH=$JAVA_HOME/bin:$PATH
Check the JDK version
# java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build 1.6.0-b105)
Java HotSpot(TM) Client VM (build 1.6.0-b105, mixed mode, sharing)
Wednesday, October 21, 2009
Transprotable Tablespace using export/import
Transprotable Tablespace using export/import
Source
1. Create tablespace.
SQL> CREATE TABLESPACE TT_DATA
DATAFILE 'F:\ORACLE\ORADATA\ORCL\TT_DATA01.ORA' SIZE 50M;
SQL> CREATE TABLESPACE TT_INDEX
DATAFILE 'F:\ORACLE\ORADATA\ORCL\TT_INDEX01.ORA' SIZE 50M;
2. Create User.
SQL> create user ttbs identified by ttbs default tablespace tt_data temporary tablespace temp;
SQL> grant connect, resource to ttbs;
SQL> alter user ttbs quota unlimited on tt_index;
SQL> select name from v$tablespace where name like 'TT_%';
NAME
------------------------------
TT_DATA
TT_INDEX
SQL> select tablespace_name,plugged_in,status from dba_tablespaces
where tablespace_name like 'TEST%';
TABLESPACE_NAME PLU STATUS
------------------------------ --- ---------
TT_DATA NO ONLINE
TT_INDEX NO ONLINE
3. Create table and index
SQL> create table ttbs.testtable (sno number, name varchar2(10)) tablespace tt_data;
SQL> insert into ttbs.testtable values (1001, 'Doyensys');
SQL> commit;
SQL> create index ttbs.i_testtable on ttbs.testtabale(sno) tablespace tt_index;
SQL> select owner,count(*) from dba_segments
where tablespace_name in ('TT_DATA','TT_INDEX') group by owner;
OWNER COUNT(*)
------------------------------ ----------
TTBS 2
SQL> select tablespace_name,count(*) from dba_segments
where owner='TTBS' group by tablespace_name;
TABLESPACE_NAME COUNT(*)
------------------------------ ----------
TT_INDEX 1
TT_DATA 1
SQL> select segment_type,count(*) from dba_segments
where owner='TTBS' group by segment_type;
SEGMENT_TYPE COUNT(*)
------------------ ----------
INDEX 1
TABLE 1
4.Source tablespace change read-only mode.
SQL>alter tablespace TT_DATA read only;
SQL>alter tablespace TT_INDEX only;
SQL> execute dbms_tts.transport_set_check('TT_DATA,TT_INDEX', TRUE);
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
no rows selected
select file_name from dba_data_files where tablespace_name in ('TT_DATA','TT_INDEX');
SQL> select file_name from dba_data_files
where tablespace_name in ('TT_DATA','TT_INDEX');
FILE_NAME
--------------------------------------------------------------------------------
F:\ORACLE\ORADATA\ORCL\TT_DATA01.ORA
F:\ORACLE\ORADATA\ORCL\TT_INDEX01.ORA
5. Export the metadata using transportable tablespace
exp "'/ as sysdba'" file=exp_tts.dmp log=exp_tts.log transport_tablespace=y tablespaces=TT_DATA,TT_INDEX statistics=none
6. Copy TT_DATA01.ORA,TT_INDEX01.ORA datafiles and exp_tts.dmp to target server.
7 . Once copy is complete,Put source tablespace read-write mode.
SQL> alter tablespace TT_DATA read write;
SQL> alter tablespace TT_INDEX read write;
Target
7. create user.
create user ttbs identified by ttbs default tablespace user_data temporary tablespace temp;
grant connect, resource to ttbs;
8. import metadata
imp "'/ as sysdba'" file=exp_tts.dmp log=imp_tts.log fromuser=ttbs touser=ttbs transport_tablespace=y datafiles=F:\oracle\oradata\orcl\TT_DATA01.ORA,F:\oracle\oradata\orcl\TT_INDEX01.ORA
SQL>select tablespace_name,plugged_in,status from dba_tablespaces
where tablespace_name like 'TEST%';
TABLESPACE_NAME PLU STATUS
------------------------------ --- ---------
TT_DATA YES READ ONLY
TT_INDEX YES READ ONLY
9. target tablespace put read-write mode.
SQL> alter tablespace TT_DATA read write;
SQL> alter tablespace TT_INDEX read write;
SQL> select tablespace_name,plugged_in,status from dba_tablespaces
2 where tablespace_name like 'TEST%';
TABLESPACE_NAME PLU STATUS
------------------------------ --- ---------
TT_DATA YES ONLINE
TT_INDEX YES ONLINE
SQL> select owner,count(*) from dba_segments
where tablespace_name in ('TT_DATA','TT_INDEX') group by owner;
OWNER COUNT(*)
------------------------------ ----------
TTBS 2
SQL> select tablespace_name,count(*) from dba_segments
where owner='TTBS' group by tablespace_name;
TABLESPACE_NAME COUNT(*)
------------------------------ ----------
TT_INDEX 1
TT_DATA 1
SQL> select segment_type,count(*) from dba_segments
where owner='TTBS' group by segment_type;
SEGMENT_TYPE COUNT(*)
------------------ ----------
INDEX 1
TABLE 1
Source
1. Create tablespace.
SQL> CREATE TABLESPACE TT_DATA
DATAFILE 'F:\ORACLE\ORADATA\ORCL\TT_DATA01.ORA' SIZE 50M;
SQL> CREATE TABLESPACE TT_INDEX
DATAFILE 'F:\ORACLE\ORADATA\ORCL\TT_INDEX01.ORA' SIZE 50M;
2. Create User.
SQL> create user ttbs identified by ttbs default tablespace tt_data temporary tablespace temp;
SQL> grant connect, resource to ttbs;
SQL> alter user ttbs quota unlimited on tt_index;
SQL> select name from v$tablespace where name like 'TT_%';
NAME
------------------------------
TT_DATA
TT_INDEX
SQL> select tablespace_name,plugged_in,status from dba_tablespaces
where tablespace_name like 'TEST%';
TABLESPACE_NAME PLU STATUS
------------------------------ --- ---------
TT_DATA NO ONLINE
TT_INDEX NO ONLINE
3. Create table and index
SQL> create table ttbs.testtable (sno number, name varchar2(10)) tablespace tt_data;
SQL> insert into ttbs.testtable values (1001, 'Doyensys');
SQL> commit;
SQL> create index ttbs.i_testtable on ttbs.testtabale(sno) tablespace tt_index;
SQL> select owner,count(*) from dba_segments
where tablespace_name in ('TT_DATA','TT_INDEX') group by owner;
OWNER COUNT(*)
------------------------------ ----------
TTBS 2
SQL> select tablespace_name,count(*) from dba_segments
where owner='TTBS' group by tablespace_name;
TABLESPACE_NAME COUNT(*)
------------------------------ ----------
TT_INDEX 1
TT_DATA 1
SQL> select segment_type,count(*) from dba_segments
where owner='TTBS' group by segment_type;
SEGMENT_TYPE COUNT(*)
------------------ ----------
INDEX 1
TABLE 1
4.Source tablespace change read-only mode.
SQL>alter tablespace TT_DATA read only;
SQL>alter tablespace TT_INDEX only;
SQL> execute dbms_tts.transport_set_check('TT_DATA,TT_INDEX', TRUE);
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
no rows selected
select file_name from dba_data_files where tablespace_name in ('TT_DATA','TT_INDEX');
SQL> select file_name from dba_data_files
where tablespace_name in ('TT_DATA','TT_INDEX');
FILE_NAME
--------------------------------------------------------------------------------
F:\ORACLE\ORADATA\ORCL\TT_DATA01.ORA
F:\ORACLE\ORADATA\ORCL\TT_INDEX01.ORA
5. Export the metadata using transportable tablespace
exp "'/ as sysdba'" file=exp_tts.dmp log=exp_tts.log transport_tablespace=y tablespaces=TT_DATA,TT_INDEX statistics=none
6. Copy TT_DATA01.ORA,TT_INDEX01.ORA datafiles and exp_tts.dmp to target server.
7 . Once copy is complete,Put source tablespace read-write mode.
SQL> alter tablespace TT_DATA read write;
SQL> alter tablespace TT_INDEX read write;
Target
7. create user.
create user ttbs identified by ttbs default tablespace user_data temporary tablespace temp;
grant connect, resource to ttbs;
8. import metadata
imp "'/ as sysdba'" file=exp_tts.dmp log=imp_tts.log fromuser=ttbs touser=ttbs transport_tablespace=y datafiles=F:\oracle\oradata\orcl\TT_DATA01.ORA,F:\oracle\oradata\orcl\TT_INDEX01.ORA
SQL>select tablespace_name,plugged_in,status from dba_tablespaces
where tablespace_name like 'TEST%';
TABLESPACE_NAME PLU STATUS
------------------------------ --- ---------
TT_DATA YES READ ONLY
TT_INDEX YES READ ONLY
9. target tablespace put read-write mode.
SQL> alter tablespace TT_DATA read write;
SQL> alter tablespace TT_INDEX read write;
SQL> select tablespace_name,plugged_in,status from dba_tablespaces
2 where tablespace_name like 'TEST%';
TABLESPACE_NAME PLU STATUS
------------------------------ --- ---------
TT_DATA YES ONLINE
TT_INDEX YES ONLINE
SQL> select owner,count(*) from dba_segments
where tablespace_name in ('TT_DATA','TT_INDEX') group by owner;
OWNER COUNT(*)
------------------------------ ----------
TTBS 2
SQL> select tablespace_name,count(*) from dba_segments
where owner='TTBS' group by tablespace_name;
TABLESPACE_NAME COUNT(*)
------------------------------ ----------
TT_INDEX 1
TT_DATA 1
SQL> select segment_type,count(*) from dba_segments
where owner='TTBS' group by segment_type;
SEGMENT_TYPE COUNT(*)
------------------ ----------
INDEX 1
TABLE 1
Create Recovery catalog using RMAN
Create Recovery catalog using RMAN
1. Create tablespace for Catalog
CREATE TABLESPACE rman_data
DATAFILE '/u01/oracle/product/oradata/orcl/rman_data01.dbf' SIZE 50M;
2. Create user for RMAN
CREATE USER rman
IDENTIFIED BY rman
DEFAULT TABLESPACE rman_data
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON rman_data;
3. Grant user.
GRANT create session TO rman;
GRANT recovery_catalog_owner TO rman;
4. create catalog
rman catalog rman/rman
RMAN> create catalog tablespace rman_data;
5. Register target database.
rman target / catalog rman/rman@rman_cat_db
RMAN> register database;
1. Create tablespace for Catalog
CREATE TABLESPACE rman_data
DATAFILE '/u01/oracle/product/oradata/orcl/rman_data01.dbf' SIZE 50M;
2. Create user for RMAN
CREATE USER rman
IDENTIFIED BY rman
DEFAULT TABLESPACE rman_data
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON rman_data;
3. Grant user.
GRANT create session TO rman;
GRANT recovery_catalog_owner TO rman;
4. create catalog
rman catalog rman/rman
RMAN> create catalog tablespace rman_data;
5. Register target database.
rman target / catalog rman/rman@rman_cat_db
RMAN> register database;
ORA-29341: The transportable set is not self-contained
Transportable tablespace using export of index tablespace given error
H:\oracle\oradata\doyen\back_test_tt>exp "'/ as sysdba'" file=TT_INDEX.dmp
log=TT_INDEX.log transport_tablespace=y tablespaces=TT_INDEX statistics=none
Export: Release 10.2.0.3.0 - Production on Wed Oct 21 12:24:06 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29341 encountered
ORA-29341: The transportable set is not self-contained
ORA-06512: at "SYS.DBMS_PLUGTS", line 1387
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Solutions:
SQL> execute dbms_tts.transport_set_check('TT_INDEX', TRUE);
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
H:\oracle\oradata\doyen\back_test_tt>exp "'/ as sysdba'" file=TT_INDEX.dmp
log=TT_INDEX.log transport_tablespace=y tablespaces=TT_INDEX statistics=none
Export: Release 10.2.0.3.0 - Production on Wed Oct 21 12:24:06 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29341 encountered
ORA-29341: The transportable set is not self-contained
ORA-06512: at "SYS.DBMS_PLUGTS", line 1387
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Solutions:
SQL> execute dbms_tts.transport_set_check('TT_INDEX', TRUE);
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
ORA-27054: NFS file system where the file is created or resides
Starting backup at 21-OCT-09
no parent backup or copy of datafile 18 found
channel c1: starting datafile copy
input datafile fno=00018 name=/home/oracle/product/10.2.0/oradata/orcl/kkk.dbf
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 10/21/2009 21:26:48
ORA-19504: failed to create file "/data/files/kkk.dbf"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Solutions
Linux
Add the following entry in /etc/fstab
hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
no parent backup or copy of datafile 18 found
channel c1: starting datafile copy
input datafile fno=00018 name=/home/oracle/product/10.2.0/oradata/orcl/kkk.dbf
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 10/21/2009 21:26:48
ORA-19504: failed to create file "/data/files/kkk.dbf"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Solutions
Linux
Add the following entry in /etc/fstab
hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
