ATG FULL deployment process

Need to  do the following steps before starting the full deployment.

1.  Enable the  useDirectSQLReplication property value at DeploymentServer component and the component path at BCC dyn admin is atg/epub/DeploymentServer/useDirectSQLReplication=true
2. Then go topology mappings then give the cata and catb and /or core schema names with in the prefix form files with . also as schemaName. (.estore_prod.)
3. While doing any deployment errors occur, the execute the following script at the BCC schema. delete from epub_deployment.  (before exceute select * from epub_deployment).
4. Need to provide the CATA previliage access to PUB schema.So need to execute the following script at catA to grant the access to PUB  schema.

Begin
FOR x IN (SELECT table_name FROM user_tables)
LOOP
EXECUTE IMMEDIATE 'GRANT all ON ' || x.table_name || ' TO BCC_schema_name';
END LOOP;
END;
/

The whole process time depends on system configuration and data. If the data is 4 lakhs, it will  take around 5 to 6 hrs.


PUB Schema and CATA schema are on different machines(hosts). 

Even though DB link is created between these two, full deployment is not working. We will get the following error on querying at SQL developer.

Error:
 ORA-22992: cannot use LOB locators selected from remote tables
22992. 00000 -  "cannot use LOB locators selected from remote tables"
*Cause:    A remote LOB column cannot be referenced.
*Action:   Remove references to LOBs in remote tables.

How to Query using DB link on different schema

select * from table1@temp_remote;
temp_remote is DB link.

Error: delete all deployment meta-data on each

agent server before attempting to re-use it as a part of a new target.

Snapshot ID '11906' is not valid for target 'Production'. Please verify that each agent server in target '11906' has a valid snapshot, or delete all deployment meta-data on each

agent server before attempting to re-use it as a part of a new target. 

Solution:

1. you need to delete the files under data folder - home server (store and pub)

Ex(home\servers\local-pub-xx\Publishing\deployment\data)