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

3 comments:

  1. have you tried uploading a file using command line

    ReplyDelete
  2. working fine.. thank you so much

    ReplyDelete
  3. in OAS we need to do it online mode only.. since catalog is no more in physical location. this commands works just great.

    ReplyDelete

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...