red1.org

[riche]

Please help me with re-installing compiere...I am getting a strange error when I runsetup and can't figure out why.

I had to reinstall a stable version of linux (I was running a beta version) and everything worked fine (Fedora Core 4 installed, Oracle installed, tnsping works, but when I run RUN_Setup, every checks out until it gets to Database Server, then I get an error that says "Error Database Port". I get the same error whether I run compiere setup as root or oracle. If you want to ssh into it, it has the same IP address and passwords (legacy400 for root/system and oracle for oracle) as the old build of the server. See below for the log. You will see that tnsping finds the database/server/port so I don't know what the problem is. The firewall is turned off and SELinux is in warning mode (doesn't do anything, just show messages):

[oracle@server1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 20-JUN-2005 18:42:26

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1.hutzlerco.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date 20-JUN-2005 18:42:26
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1.hutzlerco.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@server1 ~]$ dbstart

SQL*Plus: Release 10.1.0.3.0 - Production on Mon Jun 20 18:42:32 2005

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

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size 780320 bytes
Variable Size 170661856 bytes
Database Buffers 436207616 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Release 10.1.0.3.0 - Production

Database "tsh1" warm started.
[oracle@server1 ~]$ cd /u01/Compiere2
[oracle@server1 Compiere2]$ ls
build.xml install.html keystore rel251.html RUN_setup.bat
data InstallSteps.gif lib RUN_Compiere2.bat RUN_setup.sh
index.html jboss license.html RUN_Compiere2.sh utils
[oracle@server1 Compiere2]$ ./RUN_setup.sh
Install Compiere Server
===================================
Setup Dialog
===================================
Compiere(tm) Release 2.5.1g_2004-11-05 - Smart ERP & CRM - Copyright (c) 1999-2004 Jorg Janke/Compiere; Implementation: 2.5.1g 20041108-2252 - ComPiere Inc. (C) 1999-2004 Jorg Janke
18:44:03.472 Log: setTraceLevel - 10
/u01/Compiere2/CompiereEnv.properties - exists=false
Setting Defaults

** Test **
OK: JavaHome=/u01/j2sdk1.4.2_08
Java Version OK = 1.4.2_08
OK: CompiereHome = /u01/Compiere2
OK: AppsServer = server1.hutzlerco.com
ServerPort 0.0.0.0/0.0.0.0:1099
OK: JNPPort = 1099
URL=http://server1.hutzlerco.com:2005/
ServerPort 0.0.0.0/0.0.0.0:2005
OK: Web Port = 2005
URL=https://server1.hutzlerco.com:1443/
ServerPort 0.0.0.0/0.0.0.0:1443
OK: SSL Port = 1443
18:44:46.285 MyKeyStore: /u01/Compiere2/keystore/myKeystore
18:44:46.292 MyKeyStore: getKeyStore - loading /u01/Compiere2/keystore/myKeystore
18:44:46.306 MyKeyStore: KeyStore - Provider=SUN version 1.42 - Type=JKS
18:44:46.307 MyKeyStore: getCertificate - Alias=compiere
18:44:46.328 MyKeyStore: Certificate - Created=Mon Jun 20 12:18:37 EDT 2005
18:44:46.349 MyKeyStore: Certificate - Key=SunJSSE RSA private CRT key:
private exponent:
8eb9a65f bf5f3372 46d4f92d ebf5f3cb 319f08b8 125c7540 dc33872d 2c45c259
d4d7ed2e 0d036648 7f1b82fd e1a6a09d eb9dfb56 45bc6791 bfbb979c 8f78572f
446dc966 aa9e9a66 cd212033 59132ae2 7a9314a3 0fb17fe8 553db93e 013d9b75
543a9821 766bcc00 19af68d8 284cf646 334bbe11 f9f7664c 2fb194f6 ff0210f1
modulus:
cacac0a7 28568da8 a4751ba0 c418c092 e8a9b6c4 3c90e69a b669b455 55f8a204
6cae70de 0fdece68 b1c2814a e713c121 901eace3 5c98bf39 a80f5bf0 57f0fc28
95a0c3f7 7f9317a4 eb5851c7 07734844 c398b8a0 297f262a 7e528904 9e40b83a
5e2904ec 9f14db49 b2d976e1 df8e752a 10c15393 0b25bd8c 498484ae 341c2d83
public exponent:
010001
prime p:
e4e6506c 570ea3f9 bac99f2d b7f89309 b5b19639 7722a417 0665db95 3f4ecec2
e5a68313 3fb8ce58 a6d7bea2 0cb89cdd 7ff9ade3 fcff6d59 1de8e4ac d0a65cb9
prime q:
e2cd2528 10e7d686 85c4e051 79397e7b 05ca8003 b6b9e873 008a7165 2ac3c67e
e1c4bf00 0c5f5c94 bff8fb1a 64852a3a b24d91e7 998fb9bc ee287903 341c961b
prime exponent p:
8e50f051 dbf2db5a ca9acf20 52d0f742 c3380de9 debba800 34d721a6 72bd21ea
a57458ec 9fe2dc50 dc332970 81ae4ac1 a0eef101 de6c4565 722639ff 849edae9
prime exponent q:
9cae725b e289f747 09c4bfdf 292b11f8 b54076fd 99cf8709 63b740ad 4e44dfad
2a153c8a 3101f438 8302e39e 111179e2 00e9dbc1 2ef1feb3 c9a7c629 f367483f
crt coefficient:
2fbdd43d 656760ef eb83b49e ce35c550 8d786b9e 9570bcc0 20d01999 ee2ab98a
d13bda2c 8d1a7e5c ace72e3f 4a3d9a5c 621390f0 817bc1c3 2b490f3c 60bd7020
18:44:46.356 MyKeyStore: Certificate - [
[
Version: V1
Subject: CN=server1.hutzlerco.com, OU=oracle, O=CompiereUser, C=US
Signature Algorithm: MD5withRSA, OID = 1.2.840.113549.1.1.4

Key: SunJSSE RSA public key:
public exponent:
010001
modulus:
cacac0a7 28568da8 a4751ba0 c418c092 e8a9b6c4 3c90e69a b669b455 55f8a204
6cae70de 0fdece68 b1c2814a e713c121 901eace3 5c98bf39 a80f5bf0 57f0fc28
95a0c3f7 7f9317a4 eb5851c7 07734844 c398b8a0 297f262a 7e528904 9e40b83a
5e2904ec 9f14db49 b2d976e1 df8e752a 10c15393 0b25bd8c 498484ae 341c2d83
Validity: [From: Mon Jun 20 12:18:37 EDT 2005,
To: Sat Dec 17 11:18:37 EST 2005]
Issuer: CN=server1.hutzlerco.com, OU=oracle, O=CompiereUser, C=US
SerialNumber: [ 42b6ec5d]

]
Algorithm: [MD5withRSA]
Signature:
0000: 93 7A 56 50 92 7B 72 A0 66 9E CC 77 D5 83 39 FE .zVP..r.f..w..9.
0010: A8 3B DF 78 A1 9A 72 8F 2E A7 08 67 10 54 D3 AF .;.x..r....g.T..
0020: DA D3 1C 3C 3B 4D FB AE E4 E4 4F 7A 56 C2 92 70 ...<;M....OzV..p
0030: BC 68 80 6E A4 95 B4 CE C6 33 9C EA 67 C6 1C 81 .h.n.....3..g...
0040: 6A D8 24 F7 9B 29 58 BF CB 50 6D 33 BE E7 1C 29 j.$..)X..Pm3...)
0050: 38 D2 EC A5 05 17 C6 A4 2A A3 C8 A1 08 35 18 38 8.......*....5.8
0060: 79 F3 CA A0 2E 47 C1 35 57 AB D2 CD 63 8C 61 C9 y....G.5W...c.a.
0070: AB 89 4D 04 5F 80 E7 CC 43 F7 47 24 D2 ED 73 94 ..M._...C.G$..s.

]
OK: KeyStore = /u01/Compiere2/keystore/myKeystore
OK: Database Server = server1.hutzlerco.com
Open Socket server1.hutzlerco.com/192.168.1.10 on 1521: Invalid argument or cannot assign requested address
Not correct: DB Server Port = 1521
Error Database Port
(Not correct: DB Server Port = 1521)
===================================
Make .sh executable
===================================
./RUN_setup.sh: line 39: utils/RUN_UnixEnv.sh: No such file or directory
[oracle@server1 Compiere2]$ tnsping tsh1

TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 20-JUN-2005 18:51:13

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1.hutzlerco.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = tsh1)))
OK (0 msec)
[oracle@server1 Compiere2]$

[red1]

I went in using the old IP and oracle/oracle but cannot find Compiere2 under u01. Suresh said he will check last nite but no feedback from him. Will call him again by phone later.

Oh... now i see it! Will check... but response is so slow thru this putty.

[riche]

In the /u01/app/oracle/admin/tsh1/udump directory I was able to find the following trace error which was also listed in the trace in the bdump directory (so I am not including it):

/u01/app/oracle/admin/tsh1/udump/tsh1_ora_4000.trc
Oracle Database 10g Release 10.1.0.3.0 - Production
ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
System name: Linux
Node name: server1.hutzlerco.com
Release: 2.6.11-1.1369_FC4smp
Version: #1 SMP Thu Jun 2 23:08:39 EDT 2005
Machine: i686
Instance name: tsh1
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 4000, image: oracle@server1.hutzlerco.com (TNS V1-V3)

*** SERVICE NAME:(SYS$USERS) 2005-06-21 17:51:32.285
*** SESSION ID:(162.3) 2005-06-21 17:51:32.285
adbdrv: lang flag = 0
Error in executing triggers on database startup
*** 2005-06-21 17:51:33.125
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 7


-------------
Hope that helps.

-Rich

[red1]

Suresh told me over the phone that he believes that many Oracle DB setup has these problems and there is some workaround steps he is gonna do later tonight.

[sureshquest]

SOME HOW THE INSTALLATION IS MISSING A REQUIRED INITTSH1.ORA FILE, I TRIED TO CREATE IT MANUALLY , BUT STILL ORACLE REFUSES TO MOUNT THE DB, NEED TO INVESTIGATE FURTHER, I NEED SOME MORE TIME TO SOLVE THIS THING .

[sureshquest]

Okie guys, Finally found the real problem in the oracle.

1. Lessons:
When oracle been installed on unix consoles , REMEMBER***** to give the oracle SID in capital letters. Also REMEMBER , Unix terminals are case sensitive.

2. The Problem:
When the oracle was installed the sid given was 'tsh1' <---- (note all lower case). I would say this is a bug in oracle , bcoz by default oracle treats all tables , and objects in CAPITAL letters. Sooo , what happened is , it created the object TSH1 (<--- in CAPITAL) , but created the files as tsh1 (<--- in lower case). (Actually when i looked into the files i noticed both files, some with upper case and some with lower case, i dont understand what procedure they are following, anyhow.)

3. Further down:
When the database was created , oracle created the environment variable ORACLE_SID which is pointing to TSH1 (<--- in UPPER CASE) . but in reality, there is no such SID, since when installing the given name was tsh1 (<-- lower case). so when ever i tried to mount the database it failed.
And give me some unknown reasons rather than the real problem. So i was cracking my head to modify the init.ora parameters based on the nasty error messages the oracle log was throwing.

4. The Solution:
Finally i did a simple thing , that solved all of the problems and showed me the light. The thing i did is....

ORACLE_SID=tsh1;export ORACLE_SID

This command changed the oracle's system variable and showed oracle frm where to initialise the database. and i did a few queries , login to sql , all testing stuffs , everythg works fine after tht simple command. (NOTE** the lower case SID name in the command)

5. The Better Approach:

The command i did is a temporary solution. If u want i can make this changes to the SID permanent. But my suggestion on this is delete the database name tsh1, and recreate another instance with a ALL CAPS name. so tht we don have to worry about where to give lowercase where to give uppercase.

i did not try the compiere run_setup for oracle detection in that server. But i believe it should work now if u try with a lower case 'tsh1'.

Do ask me if you had any further questions on this.

Cheers...
--Suresh

[riche]

I thought I was careful about the case of everything the first time I installed it (definately didn't when I reinstalled it). Thanks for the help and I will delete and recreate the DB next week when I am back in the office.

-Rich

[riche]

Suresh-
So I tried to install properly on my home PC (using uppercase TSH1) and I still get the same error from Compiere. It's not that important, but I always like to make sure I can duplicate solutions. I tried setting the SID as you describe and let's me login to SQLPLUS, but compiere still gives me the same error on port 1521. Is there anything else I can do?

Note that I had to still set the SID variable even though I properly named the database. Is there a configuration file where the SID is normally set? Perhaps the whole file is missing and that is what is causing these other configuration problems. Any ideas?

Thanks,
Rich

[red1]

I wonder if it still ask u for the user/pass to login into the DB during SQLPLUS, which is similar to what i find happening in windows here when i m logged on. I have to logout internet to let the login or a DB import export to work without asking again for the pass. This is making me ponder over ports in use.

Its like the Listener is been held up by the web port.

On a more direct SID note, i believe there is a compiere.properties file in the root of Compiere2 that u can look at. But sometimes erasing them is better to redo the RUN_Setup.

Will talk to Suresh again later. Already SMS him this morning.

[sureshquest]

Quiet strange , yesterday i was able to login to sqlplus.
Today i can not login , did u recreate the db already ??

[riche]

I didn't even login today.

-Rich

[sureshquest]

Can i delete and recreate the db instance ?

[sureshquest]

The oracle needs a restart everytime, after set the environment variable to lower case tsh1. now i can connect back to sql * again.

i will try to make the lower case SID as permanent and can u try again and let me know.

[red1]

Yes, u can delete and recreate the DB instance, as it is not a live system.
Just update here whatever u do, so that we know.

This is just another Butterfly Effect

[sureshquest]

Hi red1,

I'm not gonna recreate the db. I made the SID variable as a permanent setting. And it works fine for my sql plus connections.

Hi Richie,

U mentioned to me , that u managed to connect to sql plus also, but still ur compiere can not connect. i think it is becoz of the lsnrctl start was not issued. we really need to monitor this db, i dono how the lsnrctl stops/crashes. Anyhow i started the lsnrctl now , i think now everythg should be ok , test and let me

[riche]

I think I issued lsnrctl start (always before dbstart). And yes, I was able to get into SQLplus once I made the oracle_sid= command, but still was not able to access port 1521 (when I ran compiere setup). Is there a way I can test this port? I will try using quantum to see if I can connect that way.

And feel free to recreate the db or make any other changes (just note them please). The server is in test at the moment. When it works, it will be the production server.

-Rich

[red1]

Login as root/legacy400
su - oracle
cd\Compiere2
./RUN_setup.sh

Install Compiere Server
===================================
Setup Dialog
===================================
Compiere(tm) Release 2.5.1g_2004-11-05 - Smart ERP & CRM - Copyright (c) 1999-2004 Jorg Janke/Compiere; Implementation: 2.5.1g 20041108-2252 - ComPiere Inc. (C) 1999-2004 Jorg Janke
X connection to localhost:10.0 broken (explicit kill or server shutdown).
===================================
Make .sh executable
===================================
./RUN_setup.sh: line 39: utils/RUN_UnixEnv.sh: No such file or directory
[oracle@server1 Compiere2]$


I hit the above error after getting into server via XStart from Netsarang. I wonder if its due to not setting the XWindows properly. Suresh asked me to do XClock, but I forgotten, hope to post here the exact steps to accomplish that. Will follow up later. Got a classroom of kids to handle now.

[red1]

Suresh told me that su - oracle will need to refresh the xterm so i relogin as oracle user instead of root this time and then RUN_setup.

Now the Setup Dialog opens.... some green lites then a red lite:

** Test **
OK: JavaHome=/u01/j2sdk1.4.2_08
Java Version OK = 1.4.2_08
OK: CompiereHome = /u01/Compiere2
OK: AppsServer = server1.hutzlerco.com
ServerPort 0.0.0.0/0.0.0.0:1099
OK: JNPPort = 1099
URL=http://server1.hutzlerco.com:80/
java.net.BindException: Permission denied
Not correct: Web Port = 80

Will try with other web ports then... the remote access is very very slow.. will update once gets thru.

[red1]

Now the port error seems to carry an earlier prompt:

OK: Database Server = server1.hutzlerco.com
Open Socket server1.hutzlerco.com/192.168.1.10 on 1521: Invalid argument or ca
nnot assign requested address
Not correct: DB Server Port = 1521
Error Database Port
(Not correct: DB Server Port = 1521)

According to suresh, the TNS name shuld drop out after the DB server name, which it doesnt now.

Now, the dialog box loads from CompiereEnv.properties of Compiere2. So perhaps checking that properties file can throw some more clues.

Also is this the 252d Compiere2 version? Cos in mine, the TNS field name is not in use or needed. I wonder if its only for Windows, but Rich can just check if he got the 252d version.

[red1]

It took almost an hour to get to each field needed and finally even toh i got tsh1 into the TNS and SID fields, i still got the not correct DB port 1521.

I m suggesting to create Oracle in that 'compiere' be used as SID name. I have always been using that. Not meant to impose, but i really dont know if namesake can be a potential issue, thus i factor off these issues by sticking to compiere/compiere/compiere naming for SID/user/pass as stated in compiere.org.

[sureshquest]

Hi richie,

Some forums talks abt the jdk version with FC4 may be a problem, can u try install jdk1.5 and change the java home and test with run_setup ?

don't use the rpm installer , install using the bin installer,

refer this website for details

http://forums.fedoraforum.org/showthread.php?t=59667

[red1]

but beware that Compiere is based on older JSDK and can have deprecated methods, but they re easily resolved if need be.

[riche]

Compiere setup doesn't like Java 1.5. I get the following error:

Error Java Home
(Wrong Java Version: Should be 1.4.2)

But I trick setup by changing the directory in the setup to be the old java directory even though I have JAVA_HOME pointed to 1.5. This seems to let setup work and I get all checks.

-Rich

[sureshquest]

Hmmm this is a complicated problem then,
It is not advicable to force compiere to work under JDK 1.5 ,

The other option is either disable SELinux or modify itz policy files to let java create network connections.

[riche]

SELinux is running only in warning mode. Feel free to disable. How is this done?

-Rich