In Weblogic Sometimes when you try add datasource to cluster group it fails with following error, which might be due to process limit on database side. WLS Console Error ============== Caused by: java.lang.Throwable: Substituted for the exception oracle.net.ns.NetException which lacks
Continue readingTag: datasource
WLST Script to start and stop Datasource
Script to start Datasource connect('weblogic','weblogic123','t3://localhost:7001') domainRuntime() cd('ServerRuntimes/AdminServer/JDBCServiceRuntime/AdminServer/JDBCDataSourceRuntimeMBeans/PegaRULES') objArray = jarray.array([], java.lang.Object) strArray = jarray.array([], java.lang.String) invoke('start', objArray, strArray) exit() Script to stop Datasource connect('weblogic','weblogic123','t3://localhost:7001') domainRuntime() cd('ServerRuntimes/AdminServer/JDBCServiceRuntime/AdminServer/JDBCDataSourceRuntimeMBeans/PegaRULES') objArray = jarray.array([], java.lang.Object) strArray = jarray.array([], java.lang.String) invoke('shutdown', objArray, strArray) exit()
Continue readingCreating Datasource using WLST
connect(‘weblogic’,’weblogic’,’t3://localhost:7001′) edit() startEdit() cd(‘/’) cmo.createJDBCSystemResource(‘PegaRULES’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES’) cmo.setName(‘PegaRULES’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDataSourceParams/PegaRULES’) set(‘JNDINames’,jarray.array([String(‘jdbc/PegaRULES’)], String)) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES’) cmo.setUrl(‘jdbc:sqlserver://localhost:1433’) cmo.setDriverName(‘com.microsoft.sqlserver.jdbc.SQLServerDriver’) cmo.setPassword(‘pega612’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCConnectionPoolParams/PegaRULES’) cmo.setTestTableName(‘SQL SELECT 1rnrn’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES’) cmo.createProperty(‘user’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES/Properties/user’) cmo.setValue(‘pega612’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES’) cmo.createProperty(‘databaseName’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES/Properties/databaseName’) cmo.setValue(‘prpc612’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDataSourceParams/PegaRULES’) cmo.setGlobalTransactionsProtocol(‘OnePhaseCommit’) cd(‘/SystemResources/PegaRULES’) set(‘Targets’,jarray.array([ObjectName(‘com.bea:Name=AdminServer,Type=Server’)], ObjectName)) activate() dumpStack() exit()
Continue reading