upload RPD Failed: Metadata Lock could Not be acquired. In OBIEE 12c

Issue: Not able to upload rpd in OBIEE 12c, throws an error upload RPD Failed: Metadata Lock could Not be acquired
in

OBIEE version : 12.2.1.0.160719
OBIEE Client tool : 12.2.1.1.0

Cause: Not included some class files.

Solution:

To work around this issue, you can replace the binaries in the 12.2.1.1.0 client from the 12.2.1.0.0 client to make it work successfully.

Steps:

Take a backup of the below files

1) Navigate to the location

 C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.commandline.tools\scripts

Rename datamodel to datamodel_12.2.1.1.0

2) Navigate to the location

 C:\Oracle\Middleware\Oracle_Home\bi\common\templates\wls

Rename: oracle.bi-commandline-tools-template to oracle.bi-commandline-tools-template_12.2.1.1.0

3) Navigate to the location

C:\Oracle\Middleware\Oracle_Home\bi\lib

Rename: bi-commandline-tools to bi-commandline-tools_12.2.1.1.0

Then copy the files  from the 12.2.1.0.0 client. To the above location

4) Navigate to the location

C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi1\bitools\bin

Take a backup of the file datamodel.cmd then edit datamodel.cmd file

Change the call statement as shown below

call "C:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.commandline.tools\scripts\data-model-cmd.cmd" %*

After this try to upload the RPD again 

After this step upload rpd successfully worked for me.

Than you .

Steps to import BISAMPLE Schema for OBIEE12c training.

1: Navigate to the lactation 

C:\app\OracleHomeUser1\product\12.1.0\dbhome_1\NETWORK\ADMIN

Open tnsnames.ora file and add the below tns entry and save the file

PDBORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = pdborcl)

    )

  )

2: Open your SQL Developer and run the below query as SYS user

ALTER PLUGGABLE DATABASE ALL OPEN;

3: Creating BISAMPLE user and gave privileges.

Connect as pdborcl and run the query attached (BISAMPLE_USER.SQL)  

For creating user and giving privileges

4: Unzip the dump files (Link) that you downloaded into the below location

C:\app\OracleHomeUser1\oradata\ForOBE

5: Query to create a directory that pointing to the dump files

Run the query from pdborcl

CREATE OR REPLACE DIRECTORY datapumpdir as 'C:\app\OracleHomeUser1\oradata\ForOBE';

To verify the directory is created use the below command

SELECT * from ALL_DIRECTORIES.

6: Command to import the schema.

Open command prompt and run the command.

impdp system/<Password>@pdborcl directory=datapumpdir dumpfile=BISAMPLE.dmp logfile=BISAMPLE.log

Now all the tables will be imported to the schema BISAMPLE. 

java.sql.SQLRecoverableException: ORA-01033: while starting OBIEE 12c

Issue: java.sql.SQLRecoverableException: ORA-01033: while starting obiee12c

Unable to start OBIEE 12c. When starting admin server the server failed.

Reason: The issue is related to DB, In OBIEE 12c we are installing our metadata in portable database that is PDBORCL. So while start up it will not start automatically we have to manually open the database.

Soultion:

Command to open the portable database.

ALTER PLUGGABLE DATABASE ALL OPEN;

after opening the database please start OBIEE 12c.