If you face this error below:
./ggsci: error while loading shared libraries: /ora01/F2C/F2CDEV1/db/tech_st/10.2.0/lib/libclntsh.so.10.1: cannot restore segment prot after reloc: Permission denied
Execute the following steps as root user:
getenforce
setenforce 0
getenforce
And try again.
You will need to change it permanently in your GRUB boot adding this
kernel /vmlinuz-2.6.18-8.EL ro root=/dev/VolGroup00/LogVol00 rhgb quiet enforcing=0
Oracle, RAC,Exadata, SRVCTL, Cluster, Streams, XStream, TimesTen, Data Guard, Replication , Security, Database Vault, FGA, RLS, Backup and Recovery, RMAN, Performance and Tuning, Flashback, OID, BPEL, OTM, EBS, E-Business, Certification, OCP, OCM, Opatch, SRVCTL, Oracle Golden Gate
Amazon books
Thursday, March 4, 2010
Wednesday, March 3, 2010
Some GoldenGate Tips
Here is a review of some commands used to install and administer Oracle Golden Gate on Unix.
##############################################################
--GG Installations
--GG Command line
./ggsci
--Create directories
CREATE SUBDIRS
--Add Manager default port
EDIT PARAMS MGR
--insert port value 7809 and save
--Change recyclebin initialization parameters to off
alter system set recyclebin=off scope=spfile;
shutdown immediate
startup
--Login / as sysdba and run the following script
SQL>@marker_setup.sql
SQL>@ddl_setup.sql (Specify schema, INITIALSETUP (for first installation),YES to purge recyclebin)
SQL>@role_setup.sql
--Grant the GG role to Extract users
SQL>GRANT GGS_GGSUSER_ROLE TO GG;
--Enable triggers
SQL>@ddl_enable.sql
--Enable Supplemental Data on Database
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
--Create GG Server user
SQL> create user GGSERVER identified by ggserver123;
SQL> grant dba to GGSERVER;
--Start Manager
GGSCI (dbms.f2c.com.br) 2> START MANAGER
--Stop Manager
GGSCI (dbms.f2c.com.br) 2> STOP MANAGER [!]
--Start all extract groups
START EXTRACT *X*
--Show history of last commands
HISTORY
--Execute a command sequence
OBEY file_name_commands
--Example
ADD EXTRACT myext, TRANLOG, BEGIN now
START EXTRACT myext
ADD REPLICAT myrep, EXTTRAIL /ggs/dirdat/aa
START REPLICAT myrep
INFO EXTRACT myext, DETAIL
INFO REPLICAT myrep, DETAIL
--Create GLOBALS file
EDIT PARAMS ./GLOBALS
--Insert the line below to set GG schema user
GGSCHEMA gg
--Login on Database
DBLOGIN USERID gg, PASSWORD gg
##############################################################
I will post more ASAP!
Best Regards,
Paulo Portugal
##############################################################
--GG Installations
--GG Command line
./ggsci
--Create directories
CREATE SUBDIRS
--Add Manager default port
EDIT PARAMS MGR
--insert port value 7809 and save
--Change recyclebin initialization parameters to off
alter system set recyclebin=off scope=spfile;
shutdown immediate
startup
--Login / as sysdba and run the following script
SQL>@marker_setup.sql
SQL>@ddl_setup.sql (Specify schema, INITIALSETUP (for first installation),YES to purge recyclebin)
SQL>@role_setup.sql
--Grant the GG role to Extract users
SQL>GRANT GGS_GGSUSER_ROLE TO GG;
--Enable triggers
SQL>@ddl_enable.sql
--Enable Supplemental Data on Database
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
--Create GG Server user
SQL> create user GGSERVER identified by ggserver123;
SQL> grant dba to GGSERVER;
--Start Manager
GGSCI (dbms.f2c.com.br) 2> START MANAGER
--Stop Manager
GGSCI (dbms.f2c.com.br) 2> STOP MANAGER [!]
--Start all extract groups
START EXTRACT *X*
--Show history of last commands
HISTORY
--Execute a command sequence
OBEY file_name_commands
--Example
ADD EXTRACT myext, TRANLOG, BEGIN now
START EXTRACT myext
ADD REPLICAT myrep, EXTTRAIL /ggs/dirdat/aa
START REPLICAT myrep
INFO EXTRACT myext, DETAIL
INFO REPLICAT myrep, DETAIL
--Create GLOBALS file
EDIT PARAMS ./GLOBALS
--Insert the line below to set GG schema user
GGSCHEMA gg
--Login on Database
DBLOGIN USERID gg, PASSWORD gg
##############################################################
I will post more ASAP!
Best Regards,
Paulo Portugal
Subscribe to:
Posts (Atom)