Closed kuuyee closed 9 years ago
Hi,
I added a unix timezone parameter to the rcu command, can you update this vagrant box and try it again.
Thank you ever so much!
I had update this vagrant box, but not work!
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Orawls::Utils::Rcu[RCU_12c soa_domain]/File[/var/tmp/install/rcu_passwords_soa_create_TESTSOA.txt]/ensure: created
==> testsoa: Info: rcu for prefix TESTSOA execute SQL with /opt/oracle/middleware12c/oracle_common/common/bin/wlst.sh /var/tmp/install/checkrcu.py
==> testsoa: Problem invoking WLST - Traceback (innermost last):
==> testsoa: File "/var/tmp/install/checkrcu.py", line 7, in ?
==> testsoa: ORA-01882: timezone region not found
==> testsoa:
==> testsoa: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
==> testsoa: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
==> testsoa: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
==> testsoa: at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1018)
==> testsoa: at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:501)
==> testsoa: at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
==> testsoa: at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
==> testsoa: at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:437)
==> testsoa: at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:954)
==> testsoa: at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:639)
==> testsoa: at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
==> testsoa: at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
==> testsoa: at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
==> testsoa: at java.sql.DriverManager.getConnection(DriverManager.java:571)
==> testsoa: at java.sql.DriverManager.getConnection(DriverManager.java:215)
==> testsoa: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
==> testsoa: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
==> testsoa: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
==> testsoa: at java.lang.reflect.Method.invoke(Method.java:606)
==> testsoa:
==> testsoa: java.sql.SQLException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
==> testsoa: ORA-01882: timezone region not found
I guess,export TZ=GMT;
Don't take effect
I have fixed this bug.
but i get another error:
ns: Extend...osb domain with template /opt/oracle/middleware12c/osb/common/templates/wls/oracle.osb_template_12.1.3.jar
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Adding ApplCore Template
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Adding SOA Template
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Adding BAM Template
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Adding BPM Template
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Adding B2B Template
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Adding ESS Template
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns:
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Change AdminServer
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: change soa_server1
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: changeDefaultServerAttributes for server soa_server1
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: change bam_server1
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: changeDefaultServerAttributes for server bam_server1
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: change osb_server1
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: changeDefaultServerAttributes for server osb_server1
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: weblogic version1213
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: weblogic version1213
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Change datasources
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Change datasource LocalScvTblDataSource
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Change datasource LocalSvcTblDataSource
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Call getDatabaseDefaults which reads the service table
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Error: getDatabaseDefaults() failed. Do dumpStack() to see details.
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: Problem invoking WLST - Traceback (innermost last):
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: File "/var/tmp/install/domain_extension_soa_domain.py", line 175, in ?
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: File "/tmp/WLSTOfflineIni3362895124626810496.py", line 219, in getDatabaseDefaults
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:56)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2279)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3249)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: at java.lang.reflect.Method.invoke(Method.java:606)
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns:
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:
==> testsoa: Error: /opt/oracle/middleware12c/soa/common/bin/wlst.sh domain_extension_soa_domain.py returned 1 instead of one of [0]
==> testsoa: Error: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[execwlst soa_domain extension soa_domain]/returns: change from notrun to 0 failed: /opt/oracle/middleware12c/soa/common/bin/wlst.sh domain_extension_soa_domain.py returned 1 instead of one of [0]
==> testsoa: Notice: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[domain.py soa_domain extension soa_domain]: Dependency Exec[execwlst soa_domain extension soa_domain] has failures: true
==> testsoa: Warning: /Stage[main]/Domains/Orawls::Domain[soa_domain]/Exec[domain.py soa_domain extension soa_domain]: Skipping because of failed dependencies
This Error: getDatabaseDefaults() is because it can't connect to the rcu repository . So you got a working database with a repository? what did you fix?
Can you update virtualbox because somehow CentOS 6.5 is not working well
we have to replace the environment parameter
# create domain
exec { "execwlst ${domain_name} ${title}":
command => "${wlstPath}/wlst.sh domain_${domain_name}.py",
environment => ["JAVA_HOME=${jdk_home_dir}"],
unless => "/usr/bin/test -e ${domain_dir}",
creates => $domain_dir,
cwd => $download_dir,
require => [File["domain.py ${domain_name} ${title}"],
File['utils.py'],
File[$domains_dir],],
timeout => 0,
path => $exec_path,
user => $os_user,
group => $os_group,
}
if($extensionsTemplateFile) {
exec { "execwlst ${domain_name} extension ${title}":
command => "${wlstPath}/wlst.sh domain_extension_${domain_name}.py",
environment => ["JAVA_HOME=${jdk_home_dir}"],
cwd => $download_dir,
timeout => 0,
path => $exec_path,
user => $os_user,
group => $os_group,
require => [Exec["execwlst ${domain_name} ${title}"],
File["domain_extension.py ${domain_name} ${title}"],],
}
}
with this
environment => ["JAVA_HOME=${jdk_home_dir}",'TZ=GMT'],
can you also try this
Thanks!
line 44
this commit fix that got a working database with a repository.
and I add TZ=GMT
environment => ["JAVA_HOME=${jdk_home_dir}",'TZ=GMT'],
domain create is work ,but another error, updateDomain()
not work.
[oracle@testsoa ~]$ /opt/oracle/middleware12c/soa/common/bin/wlst.sh /var/tmp/install/domain_extension_soa_domain.py
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
changeDefaultServerAttributes for server AdminServer
Extend...osb domain with template /opt/oracle/middleware12c/osb/common/templates/wls/oracle.osb_template_12.1.3.jar
Adding ApplCore Template
Adding SOA Template
Adding BAM Template
Adding BPM Template
Adding B2B Template
Adding ESS Template
Change AdminServer
change soa_server1
changeDefaultServerAttributes for server soa_server1
change bam_server1
changeDefaultServerAttributes for server bam_server1
change osb_server1
changeDefaultServerAttributes for server osb_server1
weblogic version1213
weblogic version1213
Change datasources
Change datasource LocalScvTblDataSource
Change datasource LocalSvcTblDataSource
Call getDatabaseDefaults which reads the service table
Change datasource EDNDataSource
Change datasource wlsbjmsrpDataSource
Change datasource OraSDPMDataSource
Change datasource SOADataSource
Change datasource BamDataSource
end datasources
Add server groups WSM-CACHE-SVR WSMPM-MAN-SVR JRF-MAN-SVR to AdminServer
Add server group SOA-MGD-SVRS,ESS-MGD-SVRS to soa_server1
Add server group BAM12-MGD-SVRS to bam_server1
Add server group OSB-MGD-SVRS-COMBINED to osb_server1
end server groups
[EL Severe]: ejb: 2014-10-24 08:34:04.2--ServerSession(403432081)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Error Code: 12514
Error: updateDomain() failed. Do dumpStack() to see details.
Problem invoking WLST - Traceback (innermost last):
File "/var/tmp/install/domain_extension_soa_domain.py", line 213, in ?
File "/tmp/WLSTOfflineIni2957278715733893812.py", line 103, in updateDomain
Domain Location: /opt/oracle/wlsdomains/domains/soa_domain
Reason: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Error Code: 12514
Exception:
oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Error Code: 12514
at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:56)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2279)
at com.oracle.cie.domain.script.jython.WLScriptContext.updateDomain(WLScriptContext.java:827)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: Domain Extension Application Failed!
Domain Location: /opt/oracle/wlsdomains/domains/soa_domain
Reason: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Error Code: 12514
Exception:
oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Error Code: 12514
my domain py script
# load common defs
execfile('/var/tmp/install/utils.py')
WLHOME='/opt/oracle/middleware12c/wlserver'
DOMAIN_PATH='/opt/oracle/wlsdomains/domains/soa_domain'
DOMAIN='soa_domain'
APP_PATH='/opt/oracle/wlsdomains/applications/soa_domain'
JSSE_ENABLED=true
CUSTOM_IDENTITY_ENABLED=false
DEVELOPMENT_MODE=true
WEBLOGIC_VERSION=1213
WEBTIER_ENABLED=false
ADMIN_SERVER='AdminServer'
ADMIN_USER='weblogic'
ADMIN_PASSWORD='weblogic1'
JAVA_HOME='/usr/java/latest'
ADM_JAVA_ARGUMENTS='-XX:PermSize=256m -XX:MaxPermSize=512m -Xms1024m -Xmx1532m -Dweblogic.Stdout=/var/log/weblogic/AdminServer.out -Dweblogic.Stderr=/var/l
og/weblogic/AdminServer_err.out'
OSB_JAVA_ARGUMENTS='-XX:PermSize=256m -XX:MaxPermSize=512m -Xms1024m -Xmx1024m -Dweblogic.Stdout=/var/log/weblogic/osb_server1.out -Dweblogic.Stderr=/var/l
og/weblogic/osb_server1_err.out'
SOA_JAVA_ARGUMENTS='-XX:PermSize=256m -XX:MaxPermSize=752m -Xms1024m -Xmx1532m -Dweblogic.Stdout=/var/log/weblogic/soa_server1.out -Dweblogic.Stderr=/var/l
og/weblogic/soa_server1_err.out'
BAM_JAVA_ARGUMENTS='-XX:PermSize=256m -XX:MaxPermSize=512m -Xms1024m -Xmx1532m -Dweblogic.Stdout=/var/log/weblogic/bam_server1.out -Dweblogic.Stderr=/var/l
og/weblogic/bam_server1_err.out'
1,1 Top
changeDatasourceToXA('BamDataSource')
print 'end datasources'
print 'Add server groups WSM-CACHE-SVR WSMPM-MAN-SVR JRF-MAN-SVR to AdminServer'
serverGroup = ["WSM-CACHE-SVR" , "WSMPM-MAN-SVR" , "JRF-MAN-SVR"]
setServerGroups(ADMIN_SERVER, serverGroup)
if ESS_ENABLED == true:
print 'Add server group SOA-MGD-SVRS,ESS-MGD-SVRS to soa_server1'
cd('/')
delete('ess_server1', 'Server')
serverGroup = ["SOA-MGD-SVRS","ESS-MGD-SVRS"]
else:
print 'Add server group SOA-MGD-SVRS to soa_server1'
serverGroup = ["SOA-MGD-SVRS"]
setServerGroups('soa_server1', serverGroup)
if BAM_ENABLED == true:
print 'Add server group BAM12-MGD-SVRS to bam_server1'
serverGroup = ["BAM12-MGD-SVRS"]
setServerGroups('bam_server1', serverGroup)
print 'Add server group OSB-MGD-SVRS-COMBINED to osb_server1'
serverGroup = ["OSB-MGD-SVRS-COMBINED"]
setServerGroups('osb_server1', serverGroup)
print 'end server groups'
updateDomain()
closeDomain();
createBootPropertiesFile(DOMAIN_PATH+'/servers/soa_server1/security','boot.properties',ADMIN_USER,ADMIN_PASSWORD)
if BAM_ENABLED == true:
createBootPropertiesFile(DOMAIN_PATH+'/servers/bam_server1/security','boot.properties',ADMIN_USER,ADMIN_PASSWORD)
createBootPropertiesFile(DOMAIN_PATH+'/servers/osb_server1/security','boot.properties',ADMIN_USER,ADMIN_PASSWORD)
print('Exiting...')
exit()
strange it looks like the database or network is not working well. I am thinking there is something wrong with virtualbox, VM resources or your desktop.
it's still timezone not match, I set some env, all error is fixed!
1.
cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
2.
vi /etc/sysconfig/clock
ZONE=”Asia/Shanghai”
UTC=false
ARC=false
3.
date -s 10/27/2014
date -s 09:51:00
4.
reboot
Thanks again for your help!
Cool Good to know this, have fun with it
By the way
you can make your vagrant centos 6.5 box with the correct timezone etc https://github.com/biemond/packer-vagrant-builder
in the kickstart file you can change the timezone https://github.com/biemond/packer-vagrant-builder/blob/master/http/centos-6.5-x86_64/ks.cfg
for more info http://biemond.blogspot.nl/2013/11/creating-your-own-virtualbox.html