Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c to OAS 2025 migration Error Import Bar file

Received Response
207
Views
17
Comments
2»

Answers

  • Joan Alvarado
    Joan Alvarado Rank 3 - Community Apprentice

    Hello,

    I have re-imported the .bar file, and although I still don’t see any logs in:
    server:~/app/oracle/product/domains/oas_domain/bilogs/metadata/importbar_20250627_160802_501945538> ls -l
    total 0
    server:~/app/oracle/product/domains/oas_domain/bilogs/metadata/importbar_20250627_160802_501945538> cd..
    server:~/app/oracle/product/domains/oas_domain/bilogs/metadata> ll
    total 0

    I have seen the log in bi_server1-diagnostic.log which records the entire snapshot import process.
    Here is the error message explaining why the .bar file import fails:

    Caused by: java.lang.UnsatisfiedLinkError: /oracle/oramid/app/oracle/product/wls12214/bi/bifoundation/web/bin/libsawjniapi643r.so: libclntshcore.so.19.1: cannot open shared object file: No such file or directory

    This is also reflected in the catalogmanager.0.0.log:
    server:~/app/oracle/product/domains/oas_domain/servers/obips1/logs/catalogmanager> cat catalogmanager.0.0.log
    [1][Fri Jun 27 16:08:33 CEST 2025][INFO]: Oracle Analytics Catalog Manager 22.4.0.0.4
    [1][Fri Jun 27 16:08:33 CEST 2025][INFO]: # Command : -cmd upgradeCatalog -migrateGroups withPrefix -offline /oracle/oramid/app/oracle/product/domains/oas_domain/tmp/metadata/importBAR/ssi/___67960723057091330278d6c2838-b6c2-4ba4-856e-3b271b967bbc/content/catalog
    [1][Fri Jun 27 16:08:33 CEST 2025][INFO]: /oracle/oramid/app/oracle/product/wls12214/bi/bifoundation/web/bin/libsawjniapi643r.so: libclntshcore.so.19.1: cannot open shared object file: No such file or directory
    [1][Fri Jun 27 16:08:33 CEST 2025][SEVERE]: #Exception:
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    com.siebel.analytics.web.catalogmanager.commands.Command.runCmd(Command.java:696)
    com.siebel.analytics.web.catalogmanager.commands.Command.processCmdLine(Command.java:994)
    com.siebel.analytics.web.catalogmanager.CatalogManager.main(CatalogManager.java:22)
    [1][Fri Jun 27 16:23:51 CEST 2025][INFO]: Oracle Analytics Catalog Manager 22.4.0.0.4

    Any idea or document that could help resolve the shown error?

    I appreciate your support

    regards
    Joan

  • Joan Alvarado
    Joan Alvarado Rank 3 - Community Apprentice

    Hi,

    I have performed the import of the .bar file again, and I was able to see the error in catalogmanager.0.0.log

    Error:

    [1][Mon Jun 30 11:50:05 CEST 2025][INFO]: Oracle Analytics Catalog Manager 22.4.0.0.4
    [1][Mon Jun 30 11:50:05 CEST 2025][INFO]: # Command : -cmd upgradeCatalog -migrateGroups withPrefix -offline /oracle/oramid/app/oracle/product/domains/oas_domain/tmp/metadata/importBAR/ssi/___8831167093358630791eabeec8b-2ea2-46f1-926b-31c5de19b2db/content/catalog
    [1][Mon Jun 30 11:50:06 CEST 2025][INFO]: /oracle/oramid/app/oracle/product/wls12214/bi/bifoundation/web/bin/libsawjniapi643r.so: libclntshcore.so.19.1: cannot open shared object file: No such file or directory
    [1][Mon Jun 30 11:50:06 CEST 2025][SEVERE]: #Exception:
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    com.siebel.analytics.web.catalogmanager.commands.Command.runCmd(Command.java:696)
    com.siebel.analytics.web.catalogmanager.commands.Command.processCmdLine(Command.java:994)
    com.siebel.analytics.web.catalogmanager.CatalogManager.main(CatalogManager.java:22)
    servidor:~/app/oracle/product/domains/oas_domain/servers/obips1/logs/catalogmanager>

    However, those libraries are present on my server.

    image.png image.png

    Has this happened to you as well? Does anyone know how to solve this? I would appreciate your support.

    regards,

    Joan

  • Gianni Ceresa
    Gianni Ceresa Mod

    Was your install of OAS 2025 done correctly? Supported OS and all the required dependencies installed? (there is quite a list of requirements depending on the OS selected)

  • Joan Alvarado
    Joan Alvarado Rank 3 - Community Apprentice

    Yes, the OAS installation finished without errors in a supported environment. We have a SUSE Linux Enterprise Server 15 SP6 operating system.

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Jun 30, 2025 3:16PM

    An install finished without errors sadly doesn't mean everything is right. A number of requirements are only involved when performing some activities, and therefore can generate issues later on.

    Did you install all the required packages listed in https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/sysrs/system-requirements-and-specifications.html#SYSRS-GUID-37C51062-3732-4A4B-8E0E-003D9DFC8C26 ? Often it is from that list that something is missing. Then there are the OAS requirements that comes on top of the FMW list.

    It's also possible that there is a bug, that is perfectly possible. But before to raise a SR, it's easier to make sure the obvious causes are covered.

  • Joan Alvarado
    Joan Alvarado Rank 3 - Community Apprentice

    Hi @Gianni Ceresa

    The error:
    libclntshcore.so.19.1: cannot open shared object file: No such file or directory

    I resolved it by first executing::~/app/oracle/product/domains/oas_domain/bin> source setDomainEnv.sh
    and then running the import: ./importarchive.sh ssi /path/ssi.bar nodatamodel encryptionpassword='password'
    This way, the library could be found and it finished successfully:

    Import Archive completed Successfully.

    Now, I’m facing an issue where Active Directory users can no longer connect because the roles were overwritten.

    However, according to the documentation, I ran the following command for the Administrator role:
    ./grantPermissionSetsToBIRole.sh -r BIAdministrator -p va.author,customScripts.admin

    But the users in that group still cannot connect.

    Did I miss running something else?

    regards,

    Joan

  • BrandonH
    BrandonH Rank 5 - Community Champion

    Those grants are not sufficient for Administrator to replicate pervious permissions. Here is an example that may help from an older version of OAS that may help but I would not reccomend:

    $DOMAIN_HOME/bitools/bin/grantPermissionSetsToBIRole.sh -r BIAdministrator -p bilifecycle.admin,bip.administrator,bisecurity.GBUAdmin,bisecurity.admin,customScripts.admin,infer.administrator,obips.administrator,obis.administrator,obisch.administrator,oracle.bi.dss.CustomKnowledge.admin,oracle.bi.dss.SystemKnowledge.admin,pod.admin,rdc.admin,rdc.monitor,sac.advanced.approle.administrator,sac.approle.administrator,sac.snapshot.administrator,va.admin,dataReplication.access

    You would likely be better off to instead manually add the previous members of BIAdministrator to the new admin role BIServiceAdministrator:

    $ORACLE_HOME/oracle_common/common/bin/wlst.sh <<EOI | tee -a $LOG

    connect('weblogic','******************', '${SHORTHOST}:9900')

    grantAppRole("obi","BIServiceAdministrator","weblogic.security.principal.WLSUserImpl","weblogic")

    or

    grantAppRole("obi","BIServiceAdministrator","weblogic.security.principal.WLSUserImpl","someAdministrator")

    The problems you mention have come up many times in the forums over the last 4 years.

    In general, I would strongly advise that no one imports security when upgrading from obiee 12c or earlier to OAS.

    If you import the bar file do not bring in your security. You will need to do some manual work to restore your security model in OAS but you will be better off in the long run, and you will come through the process with a better understanding of the current security setups.

    Once you have your admin accounts working, get familiar with the new dv security management pages. Things are somewhat easier now and you will have to rely on /em (enterprisemanager) less for role management.

    https://somebi_instance.com/dv/?pageid=usersandroles

    Keep in mind when you are working with groups to use the show indirect members option if you are troubleshooting access problems:

    image.png

    Build out wlst scripts to recreate your custom roles and permissions, some egs below:


    $ORACLE_HOME/oracle_common/common/bin/wlst.sh

    connect('weblogic','************', '${SHORTHOST}:9900')

    createAppRole(appStripe='obi', appRoleName='FinanceProjectAdmin')

    grantAppRole("obi","BIContentAuthor","weblogic.security.principal.WLSGroupImpl","STN Financial Author")

    atnr=cmo.getSecurityConfiguration().getDefaultRealm().lookupAuthenticationProvider("DefaultAuthenticator")
    cmo.getSecurityConfiguration().getDefaultRealm().lookupAuthenticationProvider("DefaultAuthenticator").createGroup('BIAdministrators','BIAdministrators')