Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » weblogic server starting problem (Weblogic )
weblogic server starting problem [message #675015] Sun, 03 March 2019 11:25 Go to next message
oramoin
Messages: 9
Registered: June 2008
Junior Member
Hi everyone,


I have a problem with my weblogic server during startup, can anyone help me, you can find an error in an attached file.

Below is environment detail:
Red Hat Enterprise Linux Server release 6.6 (Santiago)
WebLogic Server for FMW 12.2.1.2.0
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit


Regards
  • Attachment: COM_Admin.log
    (Size: 474.14KB, Downloaded 426 times)
Re: weblogic server starting problem [message #675019 is a reply to message #675015] Mon, 04 March 2019 04:10 Go to previous messageGo to next message
John Watson
Messages: 8023
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read


Have you looked at the log you posted? Perhaps these lines would give you a clue:

 Could not create connection for datasource 'oms_pool'.

 The returned message is: ORA-01017: invalid username/password; logon denied

 It is likely that the login or password is not valid.
 It is also possible that something else is invalid in
 the configuration or that the database is not available.
Re: weblogic server starting problem [message #675020 is a reply to message #675019] Tue, 05 March 2019 00:12 Go to previous messageGo to next message
oramoin
Messages: 9
Registered: June 2008
Junior Member
Watson,

Thanks for the response, database is up and running and I didn't change the password, password is still the same which I had set at the time of installation, I don't know how it is changed.

below is file where 'osm_pool' datasource details is available, the password is encrypted how do I reset it do you have any idea?


[osmadm@OSMVM jdbc]$ cat CP-oms_pool-1530-jdbc.xml

<?xml version='1.0' encoding='UTF-8'?>
<jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd">
<name>oms_pool</name>
<jdbc-driver-params>
<url> jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.232.157)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=osmdb)(INSTANCE_N AME=osmdb))) </url>
<driver-name>oracle.jdbc.OracleDriver</driver-name>
<properties>
<property>
<name>user</name>
<value>ordermgmt</value>
</property>
</properties>
<password-encrypted>{AES}yicef4lmJWC/uSNqhb53Q3dT7s46NJUbs7iT1gozlBc=</password-encrypted>
</jdbc-driver-params>
<jdbc-connection-pool-params>
<initial-capacity>15</initial-capacity>
<max-capacity>54</max-capacity>
<capacity-increment>1</capacity-increment>
<shrink-frequency-seconds>0</shrink-frequency-seconds>
<test-frequency-seconds>0</test-frequency-seconds>
<test-connections-on-reserve>false</test-connections-on-reserve>
<test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
<statement-cache-size>10</statement-cache-size>
<remove-infected-connections>false</remove-infected-connections>
</jdbc-connection-pool-params>
<jdbc-data-source-params>
<jndi-name>mslv/oms/oms1/internal/jdbc/DataSource</jndi-name>
<row-prefetch>true</row-prefetch>
<row-prefetch-size>200</row-prefetch-size>
<global-transactions-protocol>LoggingLastResource</global-transactions-protocol>
</jdbc-data-source-params>
</jdbc-data-source>
Re: weblogic server starting problem [message #675026 is a reply to message #675020] Tue, 05 March 2019 13:21 Go to previous messageGo to next message
BlackSwan
Messages: 26607
Registered: January 2009
Location: SoCal
Senior Member
while logged onto the DB Server system itself do as below but use your USERNAME & PASSWORD
please use COPY & PASTE to post the results back here

[oracle@localhost ~]$ sqlplus scott/tiger

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 5 14:19:27 2019

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Sat Mar 02 2019 08:08:20 -05:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>
Re: weblogic server starting problem [message #675059 is a reply to message #675026] Wed, 06 March 2019 23:58 Go to previous messageGo to next message
oramoin
Messages: 9
Registered: June 2008
Junior Member
You can find my user connection in an attached file.
Re: weblogic server starting problem [message #675065 is a reply to message #675059] Thu, 07 March 2019 08:12 Go to previous message
BlackSwan
Messages: 26607
Registered: January 2009
Location: SoCal
Senior Member
oramoin wrote on Wed, 06 March 2019 21:58
You can find my user connection in an attached file.

c/o Michel Cadot
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover) 
- SYS/SYSDBA is special 
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer) 
- SYS/SYSDBA does not act like any other user 
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others 
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user. 

NEVER EVER use SYS/SYSDBA for anything that can be done by another user. 
Use SYS/SYSDBA ONLY for something that can't be done by someone else.

Posted example is inconclusive since it shows connecting to LOCAL database;
whereas weblogic will only connect to DB over the network & abuse of SYS account requires different password file.
Previous Topic: UNABLE TO INSTALL WEBLOGIC
Next Topic: WebLogic Messaging Store-and-forward service not working
Goto Forum:
  


Current Time: Wed Oct 23 17:04:45 CDT 2019