Error connecting: jdbc:oracle:thin:@//Idempiere-PC:1521/idempiere - as system/adempiere [34]

[Dxb_Programmer]

Dear Experts,

I am getting error as attached,

where i try to Run Install App from Eclipse.

Environment I am using Java 8.0 with With oracle 11g.

thanks in advance.

[Orlando Curieles]

Hi, on the database name you need set the Schema, try with xe if you are using Oracle 11G Express.

Regards.

[Anozi Mada]

What's your OS' default locale? It seems it's not recognized by the jdbc driver.
Try change the default locale to en_US or you can try adding "-Duser.language=en -Duser.country=US" to the JVM argument

Regards,
Anozi Mada

[Dxb_Programmer]

Hi Anozi Mada,

Thanks for your reply, 

I am very new to Oracle 11g setup and  I am using Win7 OS.

During Oracle Installation, I selected Advanaced option and Selected lanagues English US, English UK and Arabic from the language list.

and also set Chareter set as UniCode.

May be becuse of this ? please help me solve this issue and locale settings.

thanks agaian.

[Dxb_Programmer]

Hi Orlando Curieles,

Thanks for your reply.

I tried with your option, but, no luck.

[Anozi Mada]

I'm not knowledgeable in oracle also. In the past I tried to installed oracle xe 11 in ubuntu by following this guide http://meandmyubuntulinux.blogspot.co.id/2012/05/installing-oracle-11g-r2-express.html and one of the issue is about NLS_LANG. Basically it just trial and error for me.
If I were you I'm gonna try to change the OS default locale to en_US https://www.java.com/en/download/help/locale.xml
If the error still exists then try set the NLS_LANG to American_America.UTF8 http://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html
Make sure to reboot.

[Carlos Antonio Ruiz Gómez]

What is the oracle instance name?  And which is the password you assigned to SYSTEM when installing oracle?

Regards,

Carlos Ruiz

[Dxb_Programmer]

Hi Carlos,

Thanks for your reply.

The instance name I have given at the time of Installation is : EAIDempiere

and password is : adempiere.

[Dxb_Programmer]

Hi Anozi Mada,

Thanks for the valuable informtion,

let me read the documents and try it.

[Carlos Antonio Ruiz Gómez]

So, in the screenshot you provided you must fill the Database Server field with EAIDempiere (instead of Idempiere-PC)

[Dxb_Programmer]

Hi Carlos Ruiz,

Thanks for your help and information.

This issue solved by, re installing Oracle 11g wtihout selecting Advanaced option.

Now, I can do the setup and its woking fine.

thanks a lot of your effort and help.

[Faheem Raja]

Dear Experts,

idempiere 2.1 
oracle 11g

I am Facing the same issue to Run Install App from Eclipse.
Even the Idempiere server setup. running Properly.

Error is..

13:01:22.048-----------> ConfigOracle.testJDBC: java.sql.SQLRecoverableException: IO Error: Connection reset [15]

13:01:22.048-----------> ConfigurationData.test: Error connecting: jdbc:oracle:thin:@//localhost:5432/idempiere - as system/oracle [15]

13:01:22.063===========> ConfigurationPanel$1.finished: Error JDBC Connection 

(Error connecting: jdbc:oracle:thin:@//localhost:5432/idempiere - as system/oracle) [12]

13:01:22.063===========> ConfigurationPanel$1.finished: Error JDBC Connection 

(Error connecting: jdbc:oracle:thin:@//localhost:5432/idempiere - as system/oracle) [12] 

thanks in advance.

 

[Dirk Niemeyer]

hi,

your log shows port 5432 which is for postgres. It should be 1521 for
oracle.

Regards,

Dirk Niemeyer

[Faheem Raja]

yes its definitely a mistake
now the install.app is running properly 
but now the problem in server.product

Console...

*** 2018-11-06 13:50:43.343 idempiere Log (CLogFile) ***

13:50:43.342 Adempiere.startup: iDempiere(r) Release 2.1_2014-10-31 -Smart Suite ERP, CRM and SCM- (c) 1999-2013 iDempiere(r); Implementation: iDempiere - Supported by iDempiere community [11]

13:50:43.349 Ini.loadProperties: C:\idempiere\idempiere.properties #33 [11]

13:50:45.973===========> PreparedStatementProxy.init: SELECT * FROM AD_Table WHERE UPPER(TableName)=? [11]

java.lang.IllegalStateException: DB.getConnectionRO - @NoDBConnection@

at org.compiere.util.DB.createConnection(DB.java:471)

at org.idempiere.db.util.AutoCommitConnectionBroker.getConnection(AutoCommitConnectionBroker.java:48)

at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:64)

at org.compiere.db.PreparedStatementProxy.<init>(PreparedStatementProxy.java:45)

at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:56)

at org.compiere.util.DB.prepareStatement(DB.java:774)

at org.compiere.util.DB.prepareStatement(DB.java:743)

at org.compiere.model.MTable.get(MTable.java:110)

at org.compiere.model.Query.<init>(Query.java:124)

at org.adempiere.plugin.utils.AdempiereActivator.installPackage(AdempiereActivator.java:83)

at org.adempiere.plugin.utils.AdempiereActivator.access$4(AdempiereActivator.java:55)

at org.adempiere.plugin.utils.AdempiereActivator$2.stateChange(AdempiereActivator.java:189)

at org.compiere.Adempiere.fireServerStateChanged(Adempiere.java:737)

at org.compiere.Adempiere.startup(Adempiere.java:594)

at org.compiere.util.WebEnv.initWeb(WebEnv.java:170)

at org.compiere.util.WebEnv.initWeb(WebEnv.java:129)

at org.compiere.web.AdempiereMonitor.init(AdempiereMonitor.java:1095)

13:50:46.020===========> Msg.initMsg: No DB Connection [11]

13:50:46.316===========> PreparedStatementProxy.init: SELECT Name, PO_Name FROM AD_Element WHERE UPPER(ColumnName)=? [11]

java.lang.IllegalStateException: DB.getConnectionRO - @NoDBConnection@

at org.compiere.util.DB.createConnection(DB.java:471)

at org.idempiere.db.util.AutoCommitConnectionBroker.getConnection(AutoCommitConnectionBroker.java:48)

at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:64)

at org.compiere.db.PreparedStatementProxy.<init>(PreparedStatementProxy.java:45)

at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:56)

at org.compiere.util.DB.prepareStatement(DB.java:774)

at org.compiere.util.DB.prepareStatement(DB.java:743)

at org.compiere.util.Msg.getElement(Msg.java:500)

at org.compiere.util.Msg.translate(Msg.java:589)

at org.compiere.util.Msg.translate(Msg.java:632)

at org.compiere.util.Msg.parseTranslation(Msg.java:679)

[Flo Boj]

I think this log meaning is you still dont connect to your db properly.

Have you run the seeds ?

Im no pro, only Living Next door.
Greets Florian

[Faheem Raja]

thank you For Your reply Flo Boj

idempiere is connected and  running properly in idempiere server 
but facing this issue in  eclipse