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

Problem of OBIEE 12c domain start

Received Response
12
Views
4
Comments
Tuvshinbayar
Tuvshinbayar Rank 2 - Community Beginner
edited Aug 13, 2024 5:54PM in Oracle Analytics Cloud and Server

Problem of OBIEE 12c domain start.

I have 1 database server and one obiee server. So i am created schemas via RCU. but my DEV_* user's password has been expired.

I am forgotten password of RCU schemas. so i did those steps on database server.

1)

select spare4 from sys.user$ where name='DEV_OPSS';

select spare4 from sys.user$ where name='DEV_OPSS';

select spare4 from sys.user$ where name='DEV_MDS';

select spare4 from sys.user$ where name='DEV_BIPLATFORM';

select spare4 from sys.user$ where name='DEV_STB';

select spare4 from sys.user$ where name='DEV_WLS_RUNTIME';

2)

alter user DEV_OPSS identified by values 'S:3A93D2F35B347E41D1B44A4C5D19BAFD5E6C6FBD36931147A51CDD94B78B;H:E3F9E5517DCCB806315ADDD3442ACD3E;T:53AC1FD8B8A5886400CDAF56B21CA5D827BE15CF5B314BBEEF0932C1FED3976ED02AE11893FEF5CC2CB1390C9D90595CFA2E3D191570AF41C659718DB721A2603C566D1830057E1245E3BE8E9A8AFE0A';

alter user DEV_MDS identified by values 'S:521DCCF7B7444958458A33C6994BEBCB5F8C240444F41F184E5C28BB5151;H:4D19FD54B2E11791416804BF954403C2;T:4D234BD59191CF60536777282F35A111FCD5A2F713EDBC553D61AB62EDF39440103FD099793B0C01998A76C3EDD38F881ACC06319AEC28A3BB56299B9ED3A3AE876554128A1D2D6E26918B504E60BBE4';

alter user DEV_BIPLATFORM identified by values 'S:3824DCAB101EDFA8AB874FF0E912A6FB55AC176E18B3D1E3D7FAC6B77225;H:A00907551699A5750495ADB6599B7676;T:95B340D7DAB8701AA8B601F29D9B18396ECBBBB826BE62EE1C71C8CF178BCE6B96C1C0FD3143B3A9D21C423D364EBAA99EA3090243556829CF8247432CF506DB434D701A8E47269CC6B0B60BD34FF586';

alter user DEV_STB identified by values 'S:4470EB1C631A4A36995F4611511201C947C18F6135A9ACFC65E7953C4510;H:D5C0290B8379783D97C2601A3AAB04BB;T:26253BA2066AC12168A4166905A47EB9A60D1E744C0A0CB2B35BD252796204106FF30D95269F3EDFB04466E67B7806B64C2BB04CAC3C75569EC94FE722A82F4190A37AAF0A722952382DC48E0B49AAEC';

alter user DEV_WLS_RUNTIME identified by values 'S:43EAF974F0859CC847C49F868D9ABBBD2DC929CBC86A8D2B124392263EF7;H:CF56FA4DFFC1240DDD38EC2D09651275;T:E0E7A998F9BD82C6D300FDAEDA4B3AD12C401594F930FC0C93451021B387E21E9FA9BB90F95A4D0EC457715BECE09F6C907BB3E5A768C83EB042A4B75951380BFA9EB824DD044B74FBA4CFF79739DF13';

Updated only 11G, 12c values;

3)

then i am started obiee domain via

./start.sh

========================RESULT=======================

Status of Domain: /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi

NodeManager (obiee.localdomain:9506): RUNNING

Name            Type            Machine                   Status      

----            ----            -------                   ------      

AdminServer     Server          obiee.localdomain         RUNNING     

bi_server1      Server          obiee.localdomain         RUNNING     

obips1          OBIPS           obiee.localdomain         SHUTDOWN    

obijh1          OBIJH           obiee.localdomain         RUNNING     

obiccs1         OBICCS          obiee.localdomain         RUNNING     

obisch1         OBISCH          obiee.localdomain         SHUTDOWN    

obis1           OBIS            obiee.localdomain         SHUTDOWN  

4)

Logs

obips1          OBIPS           obiee.localdomain         SHUTDOWN    

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <QTDIR=/usr/lib64/qt-3.3>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <ANT_CONTRIB=/home/oracle/Oracle/Middleware/Oracle_Home/wlserver/../oracle_common/modules/net.sf.antcontrib_1.1.0.0_1-0b3>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <ORACLE_BI_SECURITY_SOAP_URLS=http://obiee.localdomain:9505/bi-security/service>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <ODBCINI=/home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/config/fmwconfig/bienv/core/odbc.ini>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <QTLIB=/usr/lib64/qt-3.3/lib>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <HOME=/home/oracle>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <PROFILE_CLASSPATH=/home/oracle/Oracle/Middleware/Oracle_Home/wlserver/server/lib/weblogic.jar>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <UTILS_MEM_ARGS=-Xms32m -Xmx1024m>

<Nov 16, 2017 3:14:28 PM ULAT> <INFO> <NodeManager ComponentManager> <ORACLE_OBICCS_HOSTS=obiee.localdomain:9508>

<Nov 16, 2017 3:14:30 PM ULAT> <INFO> <NodeManager ComponentManager> <The server 'obips1' with process id 15267 is no longer alive; waiting for the process to die.>

<Nov 16, 2017 3:14:30 PM ULAT> <FINEST> <NodeManager ComponentManager> <Process died.>

<Nov 16, 2017 3:14:30 PM ULAT> <INFO> <NodeManager ComponentManager> <Server failed during startup. It may be retried according to the auto restart configuration.>

<Nov 16, 2017 3:14:30 PM ULAT> <FINEST> <NodeManager ComponentManager> <get latest startup configuration before deciding/trying to restart the server>

<Nov 16, 2017 3:14:30 PM ULAT> <INFO> <NodeManager ComponentManager> <Server failed but will not be restarted because the maximum number of restart attempts has been exceeded>

<Nov 16, 2017 3:14:30 PM ULAT> <FINEST> <NodeManager ComponentManager> <runMonitor returned, setting finished=true and notifying waiters>

obis1           OBIS            obiee.localdomain         SHUTDOWN    

<Nov 16, 2017 3:14:17 PM ULAT> <INFO> <NodeManager ComponentManager> <PROFILE_CLASSPATH=/home/oracle/Oracle/Middleware/Oracle_Home/wlserver/server/lib/weblogic.jar>

<Nov 16, 2017 3:14:17 PM ULAT> <INFO> <NodeManager ComponentManager> <UTILS_MEM_ARGS=-Xms32m -Xmx1024m>

<Nov 16, 2017 3:14:17 PM ULAT> <INFO> <NodeManager ComponentManager> <ORACLE_OBICCS_HOSTS=obiee.localdomain:9508>

errCode:1017 errSQLStateBuf:28000 errMsg:[Oracle DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied

errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open

Oracle BI Server starting...

errCode:1017 errSQLStateBuf:28000 errMsg:[Oracle DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied

errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open

Oracle BI Server startup failed.

nqsserver: Oracle BI Server shutdown.

<Nov 16, 2017 3:14:20 PM ULAT> <INFO> <NodeManager ComponentManager> <The server 'obis1' with process id 15170 is no longer alive; waiting for the process to die.>

<Nov 16, 2017 3:14:20 PM ULAT> <FINEST> <NodeManager ComponentManager> <Process died.>

<Nov 16, 2017 3:14:20 PM ULAT> <INFO> <NodeManager ComponentManager> <Server failed during startup. It may be retried according to the auto restart configuration.>

<Nov 16, 2017 3:14:20 PM ULAT> <FINEST> <NodeManager ComponentManager> <get latest startup configuration before deciding/trying to restart the server>

<Nov 16, 2017 3:14:20 PM ULAT> <INFO> <NodeManager ComponentManager> <Server failed but will not be restarted because the maximum number of restart attempts has been exceeded>

<Nov 16, 2017 3:14:20 PM ULAT> <FINEST> <NodeManager ComponentManager> <runMonitor returned, setting finished=true and notifying waiters>

obisch1         OBISCH          obiee.localdomain         SHUTDOWN

<Nov 16, 2017 3:14:39 PM ULAT> <INFO> <NodeManager ComponentManager> <UTILS_MEM_ARGS=-Xms32m -Xmx1024m>

<Nov 16, 2017 3:14:39 PM ULAT> <INFO> <NodeManager ComponentManager> <ORACLE_OBICCS_HOSTS=obiee.localdomain:9508>

errCode:1017 errSQLStateBuf:28000 errMsg:[Oracle DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied

errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open

<Nov 16, 2017 3:14:42 PM ULAT> <INFO> <NodeManager ComponentManager> <The server 'obisch1' with process id 15364 is no longer alive; waiting for the process to die.>

<Nov 16, 2017 3:14:42 PM ULAT> <FINEST> <NodeManager ComponentManager> <Process died.>

<Nov 16, 2017 3:14:42 PM ULAT> <INFO> <NodeManager ComponentManager> <Server failed during startup. It may be retried according to the auto restart configuration.>

<Nov 16, 2017 3:14:42 PM ULAT> <FINEST> <NodeManager ComponentManager> <get latest startup configuration before deciding/trying to restart the server>

<Nov 16, 2017 3:14:42 PM ULAT> <INFO> <NodeManager ComponentManager> <Server failed but will not be restarted because the maximum number of restart attempts has been exceeded>

<Nov 16, 2017 3:14:42 PM ULAT> <FINEST> <NodeManager ComponentManager> <runMonitor returned, setting finished=true and notifying waiters>

============================================= END=======================================

somebody help me.

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    You need to update the data sources connection details if you have changed the RCU schemas password.

    Take a look at this MOS document: here

  • Tuvshinbayar
    Tuvshinbayar Rank 2 - Community Beginner

    Capture.PNG

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    I wouldn't suggest changing password using the encoded  password values in DB server.Better off setting new passwords (and store them somewhere safe) and then update data sources from console.

  • Tuvshinbayar
    Tuvshinbayar Rank 2 - Community Beginner

    Thank you Sherry, i am resolved this problem.

    1)

    updated passwords of dev_* shcemas on database server

    2)

    updated new passwords of datasources via weblogic console.

    3) executed sync_midtier_db.sh