Automatic snapshot in OAS

mchorazy

Hi,

Is it possible to create automatically snapshot in OAS or schedule it?

Gianni Ceresa

You can create BAR files by command line and schedule that. The front-end snapshop doesn't have a scheduler.

[Deleted User]

+1 to Gianni scheduler and command line. Same approach that works since more than a decade.

mchorazy

Ok.

I have problem with export bar from OAS 5.9.0

I use code:

export_service_instance.cmd ssi 202203.bar

And get error:

E:\OAS\user_projects\domains\bi\bitools\bin>export_service_instance.cmd ssi 202203.bar

Oracle BI ServiceLCM CLI Tools

Copyright ? 2014, 2015, 2016, 2017 Oracle and/or its affiliates. All rights reserved.

Exception in thread "main" java.lang.IllegalStateException: Required system property not set: oracle.bi.servicelcm.producthome

    at oracle.bi.servicelcm.cli_v2.ImplicitParameters.getStringParameter(ImplicitParameters.java:46)

    at oracle.bi.servicelcm.cli_v2.ImplicitParameters.getFileParameter(ImplicitParameters.java:40)

    at oracle.bi.servicelcm.cli_v2.ImplicitParameters.getImplicitParametersFromEnvironment(ImplicitParameters.java:34)

    at oracle.bi.servicelcm.cli_v2.LcmCli.main(LcmCli.java:10)

I set variable like DOMAIN_HOME, ORACLE_HOME, BI_PRODUCT_HOME in windows env variables and check in cmd like echo %VARIABLE_NAME% and it's ok.

What's wrong?

mchorazy

Ok, I add line: -Doracle.bi.servicelcm.producthome=%PRODUCT_HOME% in scripts: E:\OAS\bi\modules\oracle.bi.servicelcm\scripts\export_service_instance.cmd and it's working.

I have another question:

1. How can I put in script password for rpd? I want run it's from ODI in aotumatic process.

User_FWMIG

Hello,

I do not have "export_service_instance.cmd" in my folder. I can only create archives by using "D:\Oracle\Middleware\oas59\bi\bitools\bin\runcat.cmd -cmd archive". But this is not the same.

Can i just add this command somehow and it works or do i need some kind of version upgrade?

Br.

Gianni Ceresa

A catalog archive isn't the same thing as a BAR. You can for sure do catalog archives, as long as you don't expect to get a BAR as result but a real catalog archive.

Gianni Ceresa

https://community.oracle.com/tech/apps-infra/discussion/comment/16832366#Comment_16832366

Going into more details, you must have that script if you are in the right place. The script is on the server, not on the client installation. You should go on the server and run it from there.

User_FWMIG

Yes, sorry. I was looking out for this script in the wrong location. I have found it and already created my first Snapshot/.BAR file.

Thanks :P

Br.