Home » SQL & PL/SQL » SQL & PL/SQL » DB Port Error (Oracle 11 G, Suse Linux)
DB Port Error [message #670042] Thu, 31 May 2018 01:00 Go to next message
chrisindya
Messages: 33
Registered: July 2017
Member
/foru/forum/fa/13851/0/Iam getting, DB Port error, while connecting oracle from Compiere ERP application.
Iam using Oracle DB Port 1521.
Kindly help to resolve the same.

Please find the attachment for more details

[Updated on: Thu, 31 May 2018 02:00]

Report message to a moderator

Re: DB Port Error [message #670044 is a reply to message #670042] Thu, 31 May 2018 02:06 Go to previous messageGo to next message
John Watson
Messages: 8137
Registered: January 2010
Location: Global Village
Senior Member
You may need to configure your database listener to listen on the ip address of the the database server, not on 127.0.0.1.
Also, you may need to change the Databse Name you are providing from orcl to orcl.ec2.internal.

In general you might be better off asking the Compiere people for advice on this, you know.
Re: DB Port Error [message #670045 is a reply to message #670044] Thu, 31 May 2018 06:20 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
Ok Thank You

Now we are getting ORA-01882 - timezone region not found, please help to solve this error.

Find the attached screnshot
  • Attachment: Timezone.png
    (Size: 232.68KB, Downloaded 310 times)
Re: DB Port Error [message #670046 is a reply to message #670045] Thu, 31 May 2018 06:25 Go to previous messageGo to next message
John Watson
Messages: 8137
Registered: January 2010
Location: Global Village
Senior Member
How did you fix the previous error? You should give the solution, it may help other people using this Compiere product.

Then create a new topic for the new problem.
Re: DB Port Error [message #670047 is a reply to message #670046] Thu, 31 May 2018 06:33 Go to previous message
chrisindya
Messages: 33
Registered: July 2017
Member
For the DB Port error, we have changed the IP Address(System IP) in the DB Listner and reboot the system.
DB Port error got resolved. Thanks
Previous Topic: cannot use UTL_SMTP on Windows 10 pro from machine at home
Next Topic: Hierarchy problem
Goto Forum:
  


Current Time: Wed Jan 29 01:54:05 CST 2020