Oracle database connection error with DBLoad

[Santiago Fernandez]

Hello Community,
We are upgrading from v12.3 to v24.
At this moment we are stopped, since we have an error message that prevents us from continuing (screenshots are attached).
We do not know if this is a configuration problem in Automic, the fact is that it does not connect to the database with the DBload,
but there is no problem when connecting with SQL Plus.

Attached error and specification data
Thanks in advance
Regards

------------------------------
Santiago Fernández
UC SOFTWARE
[e-mail]
------------------------------

Attachment(s)

Error cliente ORACLE-3.docx   512 KB 1 version

[Markus Embacher]

Hi Santiago,

with sqlplus it seems you are using /pcprd01 to specify the SERVICE_NAME, that's why it works with sqlplus.

Automic was just given pcprd01.imi.bcn, which it is now trying to resolve via tnsnames.ora.

Please check tnsnames.ora whether the entry there has either SID or SERVICE_NAME specified as part of CONNECT_DATA, if not, please add. 

Regards, Markus

[Santiago Fernandez]

As always, thank you very much for your help.
We have been able to move forward, but now we face another obstacle. I have the feeling with this upgrade, of being in a 1500 meter hurdles race.
Now (logs attached), I find that when the scripts are executed to update the database, it finds that certain duplicate objects already exist and we have errors.
Can you suggest what to do in this situation?
Thank you very much again

------------------------------
Santiago Fernández
UC SOFTWARE
[e-mail]
------------------------------

Attachment(s)

ucybdbld_trace_00.txt   63 KB 1 version

ucybdbld_log_00.txt   45 KB 1 version

[Markus Embacher]

Hi Santiago,

 

20240918/222840.499 - U00038091 Change application directory to '..\db\'.

20240918/222840.499 - U00038042 DB-Version = ???? /U

20240918/222840.656 - U00038042 *********************************************************

20240918/222840.656 - U00038042 *** No DB Schema was recognized                       ***

20240918/222840.656 - U00038042 *** DB will be built new                              ***

20240918/222840.656 - U00038042 *********************************************************

20240918/222840.656 - U00038042 new installation version 24.0

 

That doesn't look like an upgrade to me. It seems that the DBLoad is not able to see the tables in the database. It's trying to create all the tables from scratch as is it was a fresh and empty database. Pls double check your DB connection settings.