Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stuck on sql query to find parent records that have the same child records

John O'TooleAug 11 2010 — edited Oct 31 2010
Oracle 10gR2 Enterprise Edition.

Hi,

I'm trying to write some logic to look for records in a parent table, which have the exact same values in a child table.
This is part of a bigger query, but I'm stuck on this part for now, so I've mocked up some simplified tables below to capture the core of the
problem I'm stuck on.
Let say I've got a parent table Manager, a child table Employee and there's a many to many relationship between them.
The aptly named Join_Table handles the relationship between them. So one manager can manage many employees, one employee can be managed by
many managers.

I've a feeling this is stupidly easy, but I seem to be suffering from a bad bout of brain freeze today!
-- parent table
CREATE TABLE manager (
 id 	number primary key,
 name 	varchar2(100));

-- child table 
CREATE TABLE employee (
 id		number primary key,
 name 	varchar2(100));

-- link table
CREATE TABLE join_table (
 manager_id		NUMBER, 
 employee_id 	NUMBER,
 CONSTRAINT join_table_pk PRIMARY KEY (manager_id, employee_id),
 CONSTRAINT manager_fk FOREIGN KEY (manager_id) REFERENCES manager(id),
 CONSTRAINT employee_fk FOREIGN KEY (employee_id) REFERENCES employee(id) 
 );

-- Insert some managers
INSERT INTO manager (id, name) VALUES (1, 'John');
INSERT INTO manager (id, name) VALUES (2, 'Bob');
INSERT INTO manager (id, name) VALUES (3, 'Mary');
INSERT INTO manager (id, name) VALUES (4, 'Sue');
INSERT INTO manager (id, name) VALUES (5, 'Alan');
INSERT INTO manager (id, name) VALUES (6, 'Mike');

-- Insert some employees 
INSERT INTO employee (id, name) VALUES (101, 'Paul');
INSERT INTO employee (id, name) VALUES (102, 'Simon');
INSERT INTO employee (id, name) VALUES (103, 'Ken');
INSERT INTO employee (id, name) VALUES (104, 'Kevin');
INSERT INTO employee (id, name) VALUES (105, 'Jack');
INSERT INTO employee (id, name) VALUES (106, 'Jennifer');
INSERT INTO employee (id, name) VALUES (107, 'Tim');

-- Insert the links
-- John manages Paul, Simon, Ken
INSERT INTO join_table (manager_id, employee_id) VALUES (1, 101);
INSERT INTO join_table (manager_id, employee_id) VALUES (1, 102);
INSERT INTO join_table (manager_id, employee_id) VALUES (1, 103);
-- Bob manages Paul, Simon, Kevin, Jack
INSERT INTO join_table (manager_id, employee_id) VALUES (2, 101);
INSERT INTO join_table (manager_id, employee_id) VALUES (2, 102);
INSERT INTO join_table (manager_id, employee_id) VALUES (2, 104);
INSERT INTO join_table (manager_id, employee_id) VALUES (2, 105);
-- Mary manages Jennifer, Tim
INSERT INTO join_table (manager_id, employee_id) VALUES (3, 106);
INSERT INTO join_table (manager_id, employee_id) VALUES (3, 107);
-- Sue manages Jennifer, Tim
INSERT INTO join_table (manager_id, employee_id) VALUES (4, 106);
INSERT INTO join_table (manager_id, employee_id) VALUES (4, 107);
-- Alan manages Paul, Simon, Ken, Jennifer, Tim
INSERT INTO join_table (manager_id, employee_id) VALUES (5, 101);
INSERT INTO join_table (manager_id, employee_id) VALUES (5, 102);
INSERT INTO join_table (manager_id, employee_id) VALUES (5, 103);
INSERT INTO join_table (manager_id, employee_id) VALUES (5, 106);
INSERT INTO join_table (manager_id, employee_id) VALUES (5, 107);
-- Mike manages Paul, Simon, Ken
INSERT INTO join_table (manager_id, employee_id) VALUES (6, 101);
INSERT INTO join_table (manager_id, employee_id) VALUES (6, 102);
INSERT INTO join_table (manager_id, employee_id) VALUES (6, 103);

-- For sanity
CREATE UNIQUE INDEX employee_name_uidx ON employee(name);
So if I'm querying for manager John, I want to find the other managers who manage the exact same list of employees.
Answer should be Mike.
If I'm querying for manager Mary, answer should be Sue.

This query will give me the list of managers who manage some of the same employees as John, but not the exact same employees...
SELECT DISTINCT m.name AS manager
FROM manager m, join_table jt, employee e
WHERE m.id = jt.manager_id
AND jt.employee_id = e.id
AND e.id IN (
	SELECT e.id
	FROM manager m, join_table jt, employee e
	WHERE m.id = jt.manager_id
	AND jt.employee_id = e.id
	AND m.name = 'John')
ORDER BY 1;
I thought about using set operations to find managers whose list of employees minus my employees is null and where my employees minus their list of employees is null. But surely there's a simpler more elegant way.
Any ideas?
Btw, I need to run this as a batch job against tables with >20 million rows so query efficiency is key.
This post has been answered by munky on Aug 11 2010
Jump to Answer

Comments

Hi,

As it says "AdminServer Could Not Be Started", it is idle to verify the "/data/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out" file for any errors.

I would suggest to one follow the actions provided in the below document:

emctl start OMS failed (Doc ID 1495519.1)

Best Regards,

Venkat

Soulivong

Thanks for your reply, but I don't have account on oracle support

/data/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out

it shows no clue

<Jan 9, 2020 1:52:36 PM ICT> <INFO> <NodeManager> <Starting WebLogic server with command line: /data/gc_inst/user_projects/domains/GCDomain/bin/startEMServer.sh >

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: EMHOME=/data/13c>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: EM_REPOS_USER=SYSMAN>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: SNMO_PERL5LIB=/data/13c/perl/lib:/data/13c/perl/lib/site_perl:/data/13c/perl/libwww-perl/lib:/data/13c/perl/ext/POSIX:/data/13c/perl/URI:/data/13c/perl/HTML_Parser:/data/13c/perl/HTML-Parser/lib:/data/13c/sysman/admin/scripts:/data/13c/bin:/data/13c/bin:/data/13c/sysman/admin/scripts/Net-DNS-0.48/lib/:/data/13c/sysman/admin/scripts/libnet-1.19/>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: DYLD_LIBRARY_PATH=:/data/13c/instantclient:/data/13c/lib:/data/13c/perl/lib:/data/13c/oui/lib/intelsolaris>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: JAVA_HOME=/data/13c/oracle_common/jdk>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: SSH_CLIENT=10.2.139.51 62532 22>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: EM_CONSOLE_HTTPS_PORT=7799>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: EMCTLCFG_MODE=>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: JAVA_PROPERTIES=-d64 -Djava.security.egd=file:///dev/./urandom -Dweblogic.security.SSL.enableJSSE=true >

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: JAVA_VM=-server -d64>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: SERVER_NAME=EMGC_ADMINSERVER>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: PWD=/data/gc_inst/user_projects/domains/GCDomain/nodemanager>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: WEBLOGIC_CLASSPATH=/data/13c/oracle_common/jdk/lib/tools.jar:/data/13c/wlserver/server/lib/weblogic_sp.jar:/data/13c/wlserver/server/lib/weblogic.jar:/data/13c/oracle_common/modules/net.sf.antcontrib_1.1.0.0_1-0b3/lib/ant-contrib.jar:/data/13c/wlserver/modules/features/oracle.wls.common.nodemanager_2.0.0.0.jar>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: FMWLAUNCH_CLASSPATH=/data/13c/oracle_common/modules/features/cieCfg_cam_lib_12.1.3.jar>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: DERBY_OPTS=-Dderby.system.home=/common/db>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: OHS_ADMIN_PORT=9999>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: COMMON_JVM_ARGS=-Dweblogic.alternateTypesDirectory='/data/13c'/oracle_common/modules/oracle.ossoiap_12.1.3,'/data/13c'/oracle_common/modules/oracle.oamprovider_12.1.3,'/data/13c'/oracle_common/modules/oracle.jps_12.1.3>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: PERL_BIN=/data/13c/perl/bin>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: DERBY_CLASSPATH=:/data/13c/wlserver/common/derby/lib/derbynet.jar:/data/13c/wlserver/common/derby/lib/derbyclient.jar:/data/13c/wlserver/common/derby/lib/derby.jar>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: OMS_PERMGEN_MAX=768M>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: CLASSPATHSEP=:>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: MEM_ARGS=-Xms32m -Xmx200m -XX:MaxPermSize=128m>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: SHLIB_PATH=:/data/13c/perl/lib:/data/13c/instantclient:/data/13c/lib:/data/13c/lib32:/data/13c/oui/lib/intelsolaris:/data/13c/lib64>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: SNMO_SHLIB_PATH=:/data/13c/perl/lib:/data/13c/instantclient:/data/13c/lib:/data/13c/lib32:/data/13c/oui/lib/intelsolaris:/data/13c/lib64>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: CONSOLE_CFG=central>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: OMSNAME=EMGC_OMS1>

<Jan 9, 2020 1:52:36 PM ICT> <FINEST> <NodeManager> <Environment: PATH=/data/13c/wlserver/server/bin:/data/13c/oracle_common/modules/org.apache.ant_1.9.2/bin:/data/13c/oracle_common/jdk/jre/bin:/data/13c/oracle_common/jdk/bin:/data/13c/wlserver/server/bin:/data/13c/oracle_common/modules/org.apache.ant_1.9.2/bin:/data/13c/oracle_common/jdk/jre/bin:/data/13c/oracle_common/jdk/bin:/data/13c/bin:/data/13c/oracle_common/jdk/bin:/data/13c/perl/bin:/data/13c/wlserver/server/bin:/data/13c/oracle_common/modules/org.apache.ant_1.9.2/bin:/data/13c/oracle_common/jdk/jre/bin:/data/13c/oracle_common/jdk/bin:/usr/bin:/usr/sbin:/bin:/usr/bin:/data/13c/oracle_common/modules/org.apache.maven_3.0.5/bin>

Hi,

1. Stop OMS

$<OMS_HOME>/bin>./emctl stop oms -all -force

2. Get the process id of leftover processes

ps -ef | grep EMGC_ADMINSERVER

ps -ef | grep EMGC_OMS1

ps -ef | grep java

ps -ef | grep opmn  (This is only for 11g and 12c environments. For 13c, checking for OPMN is not required)

3. Kill the left over OMS java processes

$kill -9 <PID>

4. Delete the following files (if they exist):

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/data/store/default/_WLS_EMGC_OMS1000000.DAT

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/data/store/default/_WLS_EMGC_ADMINSERVER000000.DAT

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/config/config.lok

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/data/ldap/*

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/tmp/EMGC_OMS1.lok

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/data/ldap/*

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/tmp/EMGC_ADMINSERVER.lok

If the OEM is configured with BIP, remove the following files as well:

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/BIP/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/BIP/data/store/default/_WLS_BIP000000.DAT

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/BIP/data/ldap/*

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/BIP/tmp/BIP.lok

5. Delete ONLY *.lck, *.pid and *.state files in the following locations. Do NOT delete any other files. Do NOT delete the directories themselves:

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/data/nodemanager/*.lck, *.pid, *.state

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/data/nodemanager/*.lck, *.pid, *.state

$EM_INSTANCE_BASE/gc_inst/user_projects/domains/GCDomain/servers/BIP/data/nodemanager/*.lck, *.pid, *.state

6. Start OMS

$<OMS_HOME>/bin>./emctl start oms

Best Regards,

Venkat

Soulivong

Hi Venkat,

On step "3. Kill the left over OMS java processes" after killing the process it closes the Terminal, when I search again it creates a new process ID

another step everything is completed successfully

but I when I run command "$<OMS_HOME>/bin>./emctl start oms"

it's still show the same error message as before

Sincerely,

Soulivong

Hi Soulivong,

None of the out file outputs provided were full, so that gives no clue of issue evidence.

Try the following steps:

./emctl stop oms -all -force

./emctl start oms -admin_only

This above command will start the Admin Server alone and will not attempt to start the OMS.

If this command fails, then provide the end lines from the "EMGC_ADMINSERVER.out" file, which should actually give some clue.

+ Also would like to know if there were any user credentials changes attempted before you observed this issue? Like Sysman Password change OR Weblogic password change?

Best Regards,

Venkat

Soulivong

Hi Venkat,

this is the output of the command ./emctl stop oms -all -force

        

Oracle Enterprise Manager Cloud Control 13c Release 2

Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.

Stopping Oracle Management Server...

WebTier Successfully Stopped

Oracle Management Server Already Stopped

Oracle Management Server is Down

JVMD Engine is Down

BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command

Stopping BI Publisher Server...

BI Publisher Server is not running

AdminServer Already Stopped

BI Publisher Server is Down

BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command

this is the output of the command ./emctl start oms -admin_only

Oracle Enterprise Manager Cloud Control 13c Release 2

Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.

Starting Admin Server only...

Admin Server Could Not Be Started

Check Admin Server log file for details: /data/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out

this is the output of command vi  /data/gc_inst/user_projects/domains/GCDomain/servers/EMGC_ADMINSERVER/logs/EMGC_ADMINSERVER.out

<Jan 14, 2020 8:36:25 AM ICT> <INFO> <NodeManager> <Starting WebLogic server with command line: /data/gc_inst/user_projects/domains/GCDomain/bin/startEMServer.sh >

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: EMHOME=/data/13c>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: EM_REPOS_USER=SYSMAN>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: SNMO_PERL5LIB=/data/13c/perl/lib:/data/13c/perl/lib/site_perl:/data/13c/perl/libwww-perl/lib:/data/13c/perl/ext/POSIX:/data/13c/perl/URI:/data/13c/perl/HTML_Parser:/data/13c/perl/HTML-Parser/lib:/data/13c/sysman/admin/scripts:/data/13c/bin:/data/13c/bin:/data/13c/sysman/admin/scripts/Net-DNS-0.48/lib/:/data/13c/sysman/admin/scripts/libnet-1.19/>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: DYLD_LIBRARY_PATH=:/data/13c/instantclient:/data/13c/lib:/data/13c/perl/lib:/data/13c/oui/lib/intelsolaris>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: JAVA_HOME=/data/13c/oracle_common/jdk>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: SSH_CLIENT=10.2.139.51 49652 22>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: EM_CONSOLE_HTTPS_PORT=7799>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: EMCTLCFG_MODE=>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: JAVA_PROPERTIES=-d64 -Djava.security.egd=file:///dev/./urandom -Dweblogic.security.SSL.enableJSSE=true >

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: JAVA_VM=-server -d64>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: SERVER_NAME=EMGC_ADMINSERVER>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: PWD=/data/gc_inst/user_projects/domains/GCDomain/nodemanager>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: WEBLOGIC_CLASSPATH=/data/13c/oracle_common/jdk/lib/tools.jar:/data/13c/wlserver/server/lib/weblogic_sp.jar:/data/13c/wlserver/server/lib/weblogic.jar:/data/13c/oracle_common/modules/net.sf.antcontrib_1.1.0.0_1-0b3/lib/ant-contrib.jar:/data/13c/wlserver/modules/features/oracle.wls.common.nodemanager_2.0.0.0.jar>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: FMWLAUNCH_CLASSPATH=/data/13c/oracle_common/modules/features/cieCfg_cam_lib_12.1.3.jar>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: DERBY_OPTS=-Dderby.system.home=/common/db>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: OHS_ADMIN_PORT=9999>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: COMMON_JVM_ARGS=-Dweblogic.alternateTypesDirectory='/data/13c'/oracle_common/modules/oracle.ossoiap_12.1.3,'/data/13c'/oracle_common/modules/oracle.oamprovider_12.1.3,'/data/13c'/oracle_common/modules/oracle.jps_12.1.3>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: PERL_BIN=/data/13c/perl/bin>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: DERBY_CLASSPATH=:/data/13c/wlserver/common/derby/lib/derbynet.jar:/data/13c/wlserver/common/derby/lib/derbyclient.jar:/data/13c/wlserver/common/derby/lib/derby.jar>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: OMS_PERMGEN_MAX=768M>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: CLASSPATHSEP=:>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: MEM_ARGS=-Xms32m -Xmx200m -XX:MaxPermSize=128m>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: SHLIB_PATH=:/data/13c/perl/lib:/data/13c/instantclient:/data/13c/lib:/data/13c/lib32:/data/13c/oui/lib/intelsolaris:/data/13c/lib64>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: SNMO_SHLIB_PATH=:/data/13c/perl/lib:/data/13c/instantclient:/data/13c/lib:/data/13c/lib32:/data/13c/oui/lib/intelsolaris:/data/13c/lib64>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: CONSOLE_CFG=central>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: OMSNAME=EMGC_OMS1>

<Jan 14, 2020 8:36:25 AM ICT> <FINEST> <NodeManager> <Environment: PATH=/data/13c/wlserver/server/bin:/data/13c/oracle_common/modules/org.apache.ant_1.9.2/bin:/data/13c/oracle_common/jdk/jre/bin:/data/13c/oracle_common/jdk/bin:/data/13c/wlserver/server/bin:/data/13c/oracle_common/modules/org.apache.ant_1.9.2/bin:/data/13c/oracle_common/jdk/jre/bin:/data/13c/oracle_common/jdk/bin:/data/13c/bin:/data/13c/oracle_common/jdk/bin:/data/13c/perl/bin:/data/13c/wlserver/server/bin:/data/13c/oracle_common/modules/org.apache.ant_1.9.2/bin:/data/13c/oracle_common/jdk/jre/bin:/data/13c/oracle_common/jdk/bin:/usr/bin:/usr/sbin:/bin:/usr/bin:/data/13c/oracle_common/modules/org.apache.maven_3.0.5/bin>

Could you provide steps if password changed has been made.

Thanks and Best Regards,

Soulivong

Hi Soulivong,

Is this the end of the file? Were there any further entries in EMGC_ADMINSERVER.out file?

Could not find any error stack from this!!

Please provide the contents from bottom of the file.

Best Regards,

Venkat

Soulivong

Hi Venkat,

The log file just ended there.

Ultimately, I have asked the software provider company, they said the license is expired.

But I have no idea why the log files do not mention anything.

Thank you for your patience and answers, It helps me to know how to analyze the problem and possibly how to fix it,

hope this question and your answers will help others.

Best Regards,

Soulivong

Hi Soulivong,

Thanks for keeping the thread updated with confirmations!!

Best Regards,

Venkat

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2010
Added on Aug 11 2010
8 comments
4,359 views