4 Replies Latest reply on Nov 18, 2017 7:16 AM by Tuvshinbayar

    Problem of OBIEE 12c domain start

    Tuvshinbayar

      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.