INSTALLATION DOCUMENTS BY RAVI

Sunday, April 9, 2017

Archiving web catalog through command prompt obiee 12c


1. Open the command prompt and navigate to the below path

On Windows :

cd %ORACLE_HOME%\user_projects\domains\bi\bitools\bin

On Linux :

cd $ORACLE_HOME/user_projects/domains/bi/bitools/bin


2. Create a file called boot.txt. this directory for ./runcat.sh or runcat.cmd

The format used with in the file is simply:
login=weblogic
pwd=password


3. The following formats were successful (this was used to create an archive 'online'):

4. Full Archive:

On Windows:
./runcat.sh -cmd archive -online https://hostname:portno/analytics/saw.dll -credentials boot.txt -forceOutputFile \path\to\fullcatalog.archive

On Linux:
runcat.cmd -cmd archive -online https://hostname:portno/analytics/saw.dll -credentials boot.txt -forceOutputFile /path/to/fullcatalog.archive

5. Partial archive (refined statement above to include /shared subfolder in archive only:

On Windows:
./runcat.sh -cmd archive -folder /shared -online https://hostname:portno/analytics/saw.dll -credentials boot.txt -forceOutputFile \path\to\partialcatalog.archive

On Linux:
runcat.cmd -cmd archive -folder /shared -online https://hostname:portno/analytics/saw.dll -credentials boot.txt -forceOutputFile /path/to/partialcatalog.archive


Unarchiving:
The following command worked for unarchiving online (restored /shared folder under the catalog root location (/)):

On Windows:
./runcat.sh -cmd unarchive -inputFile \path\to\partialcatalog.archive -folder / -overwrite all -online https://hostname:portno/analytics/saw.dll -credentials boot.txt

On Linux:
./runcat.sh -cmd unarchive -inputFile /path/to/partialcatalog.archive -folder / -overwrite all -online https://hostname:portno/analytics/saw.dll -credentials boot.txt

No comments:

Post a Comment

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...