Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error in serverlog PPM8.0

SOLVED
Go to solution
Highlighted
mg_ITE
Regular Collector

Error in serverlog PPM8.0

Hi.
I've a problem. In my serverlog of PPM 8.0 I get messages like in attach...

What is worng... Is my java version OK??
12 REPLIES
Sascha Mohr
Esteemed Contributor

Re: Error in serverlog PPM8.0

Hi,
your java version and the db version are not supported for release 8.
You should run Java SDK 1.6.0_07 and Oracle 10.2.0.4. I'll attach the overview of supported versions.
Prior to digging deeper in the setup, I would make sure the different version are not the reason for the error messages.
Regards
Sascha
mg_ITE
Regular Collector

Re: Error in serverlog PPM8.0

Do You have any link to download JDK 1.6.0_7??
I've found only JRE in this version..
mg_ITE
Regular Collector

Re: Error in serverlog PPM8.0

What sould I put in:
CLASSPATH
PATH
JAVA_HOME
and ORACLE_HOME..

This variable didn't genrate automaticly!
Sascha Mohr
Esteemed Contributor
Solution

Re: Error in serverlog PPM8.0

You can get all the older versions of the JDK/JRE on Sun's page too:
http://java.sun.com/products/archive/j2se/6u7/index.html
Sascha Mohr
Esteemed Contributor

Re: Error in serverlog PPM8.0

I had a quick look at one of our systems. CLASSPATH and ORACLE_HOME were not set there, but you will need these two:

JAVA_HOME = C:\jdk1.6.0_07 <- wherever you installed the JDK
PATH = ... f:\oracle\10.2.0\bin;C:\jdk1.6.0_07\bin <- append to what is already in PATH
mg_ITE
Regular Collector

Re: Error in serverlog PPM8.0

What should I put in ORACLE_HOME?

E:\app\Administrator\product\11.1.0\db_1\BIN or E:\product\11.1.0\client_1???

After instaling Oracle client my Oracle TNS Listener service stopped..
mg_ITE
Regular Collector

Re: Error in serverlog PPM8.0

I get following state... after installing Oracle 11g Client.. (in attach)
Sascha Mohr
Esteemed Contributor

Re: Error in serverlog PPM8.0

Are you speaking about the system the Oracle db is on or the PPM system?
mg_ITE
Regular Collector

Re: Error in serverlog PPM8.0

I've one server.. AT this server I've installed PPM Server, Oracle 11g DB, Oracle 11g Client, Cygwin and Java JDK.

I've set variables:
JAVA_HOME: C:\Java\jdk1.6.0_07
ORACLE_HOME: E:\app\Administrator\product\11.1.0\
Path: E:\product\11.1.0\client_1;E:\app\Administrator\product\11.1.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\cygwin\bin

I first installed Oracle 11g, then Java, the next one was Cygwin, and next Oracle Client.
After I've installed Oracle Client my Oracle DB Listener is not starting..


Entries in listener.log are:
24-FEB-2010 10:14:49 * (CONNECT_DATA=(SID=ppm)(CID=(PROGRAM=E:\app\Administrator\product\11.1.0\db_1\bin\emagent.exe)(HOST=PPM)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.217.1.122)(PORT=1270)) * establish * ppm * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
Wed Feb 24 10:16:07 2010
Message 279 not found; No message file for product=NETWORK, facility=NL
Message 509 not found; No message file for product=NETWORK, facility=NL
Message 510 not found; No message file for product=NETWORK, facility=NL

Message 1081 not found; No message file for product=NETWORK, facility=TNS
Message 1074 not found; No message file for product=NETWORK, facility=TNS
Message 1050 not found; No message file for product=NETWORK, facility=TNS
Wed Feb 24 10:18:25 2010


I don't even install PPM Server yet.
Sascha Mohr
Esteemed Contributor

Re: Error in serverlog PPM8.0

Hi,
both on the same system then, I've never done that. The ORACLE_HOME should probably point to the location where the dbms is installed, not the client software. Is E:\app\Administrator\product\11.1.0\ the location where the DB is installed?
Also check the file tnsnames.ora for the correct connection description, there may be more than one occurence of this file. The error message looks like there may be something incorrect there.
mg_ITE
Regular Collector

Re: Error in serverlog PPM8.0

Yes this is the place where oracle db is installed. I've checked the tnsnames.ora and I've :


PPM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ppm.ppm)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ppm.ppm)
)
)

host name is ppm.ppm
Sascha Mohr
Esteemed Contributor

Re: Error in serverlog PPM8.0

Looks normal. Only thing different compared to my local tnsnames is the SERVICE_NAME. It's SID.host.domain in my config, that would translate to "PPM.ppm.ppm" in your case, but I don't think it would make a difference as everything is on the same machine anyway.
//Add this to "OnDomLoad" event