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
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
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.
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.