---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL=''
Trying to get
connection using SID based connect descriptor
getConnection() -->
sDbHost : devc
sDbDomain : hinopak.com
sDbPort : 1522
sDbSid : DEVC
sDbUser : APPS
Trying to
connect using SID...
getConnectionUsingSID() -->
JDBC URL:
jdbc:oracle:thin:@devc.hinopak.com:1522:DEVC
Exception
occurred: java.sql.SQLException: ORA-00604: error occurred at recursive SQL
level 1
ORA-01882: timezone region not found
Trying to
connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=devc.hinopak.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEVC)))
Exception
occurred: java.sql.SQLException: ORA-00604: error occurred at recursive SQL
level 1
ORA-01882: timezone region not found
Trying to
connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=devc.hinopak.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEVC.hinopak.com)))
Exception
occurred: java.sql.SQLException: Listener refused the connection with the
following error:
ORA-12514, TNS:listener does not currently know of
service requested in connect descriptor
Connection
could not be obtained; returning null
-------------------ADX Database Utility
Finished---------------
Verifying
connection to the Database : Could not
be stablished
No Restore
Profile file created.
Restore Profile utility ran successfully
===========================================================================
adcvmlog.xml renamed to /u01/applmgr/prodappl/inst/apps/DEVC_devc/admin/log/04051526/adcvmlog.xml.04051530
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered
during each
phase of its execution.
Errors are grouped by directory and phase.
The report format is:
<filename>
<phase> <return code
where appropriate>
[SETUP PHASE]
AutoConfig could
not successfully execute the following scripts:
Directory:
/u01/applmgr/prodappl/inst/apps/DEVC_devc/admin/install
adgendbc.sh INSTE8_SETUP 1
AutoConfig is exiting with status 1
AutoConfig execution completed on Wed Apr 5 15:30:27 2017
Time taken for AutoConfig execution to complete : 4
mins 4 secs
Solution:
0 1- Set the time
zone parameter in user .bash_profile
[oracle@devc bin]$ cat /home/oracle/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export TZ=/usr/share/zoneinfo/Asia/Karachi
export PATH
[oracle@devc bin]$
02- Run Adconfig.sh on both first Database and second Application
For Database:
[oracle@devc bin]$ cd
/u02/oracle/proddb/11.2.0/appsutil/bin/
[oracle@devc bin]$ pwd
/u02/oracle/proddb/11.2.0/appsutil/bin
[oracle@devc bin]$
[oracle@devc bin]$ ./adconfig.sh
Enter the full path to the Context file:
/u02/oracle/proddb/11.2.0/appsutil/DEVC_devc.xml
Enter the APPS user password:
For Application:
[oracle@devc bin]$ pwd
/u01/applmgr/prodappl/apps/apps_st/appl/ad/12.0.0/bin
[oracle@devc bin]$
[oracle@devc bin]$ ./adconfig.sh
Enter the full path to the Context file: /u01/applmgr/prodappl/inst/apps/DEVC_devc/appl/admin/DEVC_devc.xml
Enter the APPS user password:
No comments:
Post a Comment