OraFAQ Forum: Weblogic & Application Server » weblogic server starting problem

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » weblogic server starting problem (Weblogic )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

weblogic server starting problem [message #675015]

Sun, 03 March 2019 11:25

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 5202 times)

Report message to a moderator

Re: weblogic server starting problem [message #675019 is a reply to message #675015]

Mon, 04 March 2019 04:10

John Watson
Messages: 8960
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.

Report message to a moderator

Re: weblogic server starting problem [message #675020 is a reply to message #675019]

Tue, 05 March 2019 00:12

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>

Report message to a moderator

Re: weblogic server starting problem [message #675026 is a reply to message #675020]

Tue, 05 March 2019 13:21

BlackSwan
Messages: 26766
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>

Report message to a moderator

Re: weblogic server starting problem [message #675059 is a reply to message #675026]

Wed, 06 March 2019 23:58

oramoin
Messages: 9
Registered: June 2008

Junior Member

You can find my user connection in an attached file.

Attachment: Screenshot.png
(Size: 45.54KB, Downloaded 4058 times)

Report message to a moderator

Re: weblogic server starting problem [message #675065 is a reply to message #675059]

Thu, 07 March 2019 08:12

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: weblogic server starting problem [message #684737 is a reply to message #675019]

Fri, 06 August 2021 06:37

tsk_18
Messages: 1
Registered: August 2021

Junior Member

How did you resolve this problem?

Report message to a moderator

Previous Topic:	Weblogic RMI slows down over vpn
Next Topic:	auto start wls_forms,wls_reports in weblogic

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 12:04:41 CST 2024