" /> Installation of DB Server & Configuration Server with Oracle 10g as DB. - Genesys CTI User Forum

Author Topic: Installation of DB Server & Configuration Server with Oracle 10g as DB.  (Read 18027 times)

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Advertisement
Hi,

Please check that the parameter "dbserver" is assigned valid Oracle TNS name in your "configserver.cfg"

[quote][dbserver]
host =WIN2003OS
port =4040
dbengine =oracle
[b]dbserver =WIN2003OS  <-- PUT VALID ORACLE TNS NAME[/b]
username =system
password =oracle10g
server =
reconnect-timeout = 10
response-timeout = 600[/quote]

DBServer reports error that WIN2003OS isn't valid TNS name.

[quote]MSG_ERROR status='30' msg='ORA-12514: TNS:listener does not currently know of service requested in connect descriptor[/quote]

R.

Offline Steve

  • Sr. Member
  • ****
  • Posts: 298
  • Karma: 11
I looks to me like the value

dbserver =WIN2003OS

is wrong. This should be the alias of your database as configured in the tnsnames.ora file, this is normally the SID, yours appears to be the server name.

This is a tnsnames extract -

GEN61.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = poller)(PORT = 1521))
    (CONNECT_DATA = (SID = gen61))

so the value of dbserver in the confserv.conf would be gen61 and to test it via SQLPLUS -
sqlplus user/pass@gen61

Prashant

  • Guest
Whole heartedly thanks you very much,
Now it is started properly.
Problem was with TNS NAME not specified in confserv.cfg.
Great thanks, once again.
Have a wonderful time.

Warm Regards,
Prashant.