Running 11g2 database on one Linux server and installed Oracle client and job scheduler agent on separate Linux (application) server sitting next to it. The connection betweeen them worked fine for years.

Then I changed the host names for the both the db and app servers.

Database Server Host Name Change:

host4.old_domainname.com --> host4.new_domainname.com

Application Server Host Name Change:

host3.old_domainname.com --> host3.new_domainname.com

I didn't change the IP addresses, nor the Oracle database SID or service name. I updated the schagent.cont file HOST_NAME appropriately, as well as /etc/hosts files on both servers. The tnsname.ora and listener.ora files assigned 'HOST=host4' so I didn't update them. Then I rebooted the servers and brought up the DB, listener and schagent, but get an error:

Thu Dec 31 21:54:00 2020
Errors in file /home/dbname/oracle/diag/rdbms/dbname/dbname/trace/dbname_j000_11467.trc:
ORA-12012: error on auto execute of job "schemaname"."jobname"
ORA-12537: TNS:connection closed
ORA-06512: at "SYS.DBMS_ISCHED", line 4966
ORA-06512: at "SYS.DBMS_ISCHED", line 6898
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-12541: TNS:no listener
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3975
ORA-06512: at line 1

Looking for hints how to troubleshoot/fix.

  • 1
    Oracle has a script you need to run when a host name changes. Jan 1 '21 at 2:46
  • Thanks - can you give me a little more detail?
    – user46688
    Jan 1 '21 at 2:47
  • Yep, it starts with ch or chg. Jan 1 '21 at 2:49
  • Is there instructions somewhere from Oracle or elsewhere?
    – user46688
    Jan 1 '21 at 2:50
  • Yes, Oracle has good documentation on this. You should have read it first. Jan 1 '21 at 2:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.