FORCE SHUTDOWN OF WEBLOGIC IN OBIEE 11G WHEN SERVICES STARTED

Solution :

Navigate to “boot.properties”  and change with your new password as below.
Admin Server boot.properties path :<BIEE_HOME>\user_projects\domains\bifoundation_domain\servers\AdminServer\security

Note : The User name and Password is already in encrypted format , just remove that and change the entry .
password=welcome1234
username=weblogic

Similarly do the same for bi_server1

If you do not find the bi_server ,then please create a folder as bi-server

BI Server boot.properties path:
 <BIEE_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\security
password=welcome1234
username=weblogic

Save these files and start the services again. You should be able to start the server

In such cases there is another alternative go to the config. xml location in the Path folder location
OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\domain_bak\config_prev

In this find for the node
  <node-manager-username>weblogic</node-manager-username>
<node-manager-password-encrypted>{AES}bllAojyeSO8rBPboZ78IoHF4lRl9Aqq64RzL/erty23=</node-manager-password-encrypted>

OBIEE 11G: ERROR: “ERROR CODE: OPR4ONWY:U9IM8TAC:OI2DL65P … ORA-12154: TNS COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED” WHEN TRYING TO CONNECT TO ANALYTICS

ERROR:

Error

View Display Error

Odbc driver returned an error (SQLExecDirectW).

Error Details

Error Code: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] nQSError: 10058] A general error has occurred. [nQSError:

43113] [Messgage returned from OBIS. [nQSError: 17001] Oracle error code: 12154, message: ORA-12154: TNS:could not resolve

the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)

Solution: Check the data source in connection pool of using RPD.( which subject area is trying to open in Analytics)

There are 2 solutions here:

1. Edit the Connection Pool in the BI Admin Tool and enter the full connect string for the database like:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID = orcl)))

2. Set the OBIEE Mid Tier environment variable TNS_ADMIN to the path of the tnsnames.ora file and use the net service name in the Connection Pool -> Data Source Name.

Back again