longops.sql

 -- -----------------------------------------------------------------------------------

-- File Name    : longops.sql
-- Author       : Amir DBA
-- Description  : Displays information on all long operations.
-- Requirements : Access to the V$ views.
-- Call Syntax  : @longops
-- -----------------------------------------------------------------------------------

COLUMN sid FORMAT 999
COLUMN serial# FORMAT 9999999
COLUMN machine FORMAT A30
COLUMN progress_pct FORMAT 99999999.00
COLUMN elapsed FORMAT A10
COLUMN remaining FORMAT A10

SELECT s.sid,
       s.serial#,
       s.machine,
       ROUND(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,
       ROUND(sl.time_remaining/60) || ':' || MOD(sl.time_remaining,60) remaining,
       ROUND(sl.sofar/sl.totalwork*100, 2) progress_pct
FROM   v$session s,
       v$session_longops sl
WHERE  s.sid     = sl.sid
AND    s.serial# = sl.serial#;

Autoconfig-was-failing-on-adgendbc.sh

 

Autoconfig was failing on adgendbc.sh with Invalid Host error

Issue
++++

Unique constraint error (00001) is OK if key already exists
Invalid Host
Invalid Host

ADD call failed with exit code 1

Trying to update information ...

Invalid Host
Invalid Host

UPDATE call failed with exit code 1
Updating parameters:  fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5 fnd_jdbc_buffer_decay_interval=300
Invalid Host
Invalid Host

Updating parameters:  fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false fnd_jdbc_context_check=true
Invalid Host
Invalid Host

Updating parameters:  fnd_jdbc_plsql_reset=false
Invalid Host
Invalid Host

DBC generation failed with exit code 1

Updating Server Security Authentication
Invalid Host
java.sql.SQLException: Io exception: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.


Cause:
------- 
Server name was unresolvable due to which .dbc file wasn't generated under $FND_SECURE. In my case, it was issue with my server name which was unresolvable through DNS.

Solution:
-----------
In my case wrong domain name is assigned to the ebs hostname.

root@csddebsdev.csddtest.com # hostname csddebsdev.csdddev.com


After correcting domain name, I could able to run autoconfig successfully.