\n
The below WLST script will help as to create a GridLink datasource in weblogic server.<\/p>\n
GridLinkDataSource.properties<\/b>
\n
\n<\/b>dbURL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)HOST=dbhost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SERVICENAME)))<\/p>\n
connectionpool.test.query=SQL SELECT * FROM DUAL
\nconnectionpool.driver.class=oracle.jdbc.OracleDriver
\nconnectionpool.username=SOA_EAIOWNER
\nconnectionpool.password=orasoa11g
\nconnectionpool.initCapacity=10
\nconnectionpool.maxCapacity=60
\ndatasource.name=EAISOAMetadataSource
\ndatasource.jndi.name=eai\/ds\/EAISOAMetadataSource
\ndatasource.target=Servers\/AdminServer<\/p>\n
domain.AdminIP=localhost
\ndomain.AdminPort=8000<\/p>\n
domain.AdminPasswd=welcome1<\/p>\n
GridLinkDatasourceCreation.py<\/b><\/p>\n
from java.io import FileInputStream<\/p>\n
def createGridLinkJDBCResources(configProps):
\nedit()
\nstartEdit()
\n\u00a0<\/span>
\nserver=’AdminServer’
\ncd(“Servers\/”+server)
\ntarget=cmo
\ncd(“..\/..”)
\nprint ‘=========================================’
\nprint ‘Creating GridLink DataSource….’
\nprint ‘=========================================’
\ndsTestQuery=configProps.get(“connectionpool.test.query”)
\ndsDriverName=configProps.get(“connectionpool.driver.class”)<\/p>\ncd(‘\/’)
\ndsURL= configProps.get(“dsURL”) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/span>
\ndsUserName = configProps.get(“connectionpool.username”)
\ndsPassword = configProps.get(“connectionpool.password”)
\ninitCapacity = configProps.get(“connectionpool.initCapacity”)
\nmaxCapacity = configProps.get(“connectionpool.maxCapacity”)
\ndsName = configProps.get(“datasource.name”)
\njndiname = configProps.get(“datasource.jndi.name”)
\ndatasourceTargets = configProps.get(“datasource.target”).split(“,”)<\/p>\nprint ‘dsUserName’,dsUserName
\nprint ‘dsPassword’,dsPassword
\nprint ‘initCapacity’,initCapacity
\nprint ‘maxCapacity’,maxCapacity
\nprint ‘dsName’,dsName
\nprint ‘jndiname’,jndiname
\nprint ‘datasourceTargets’,datasourceTargets<\/p>\n
print ‘Creating DataSource: ‘,dsName,’ ….’
\n\u00a0<\/span>
\nmyResourceName = dsName \u00a0\u00a0<\/span>
\njdbcSystemResource = create(myResourceName,”JDBCSystemResource”)
\nmyFile = jdbcSystemResource.getDescriptorFileName()
\njdbcResource = jdbcSystemResource.getJDBCResource()
\njdbcResource.setName(myResourceName) \u00a0\u00a0<\/span>
\n\u00a0<\/span>
\n\u00a0<\/span><\/p>\n# Create the DataSource Params
\ndpBean = jdbcResource.getJDBCDataSourceParams()
\nmyName=jndiname
\ndpBean.setJNDINames([myName])\u00a0<\/span>
\ndpBean.setGlobalTransactionsProtocol(‘TwoPhaseCommit’)<\/p>\n# Create the Driver Params
\ndrBean = jdbcResource.getJDBCDriverParams()
\ndrBean.setPassword(dsPassword)
\ndrBean.setUrl(dsURL)
\ndrBean.setDriverName(dsDriverName)<\/p>\n
#Create the Oracle params
\norapr=jdbcResource.getJDBCOracleParams()
\norapr.setFanEnabled(true)
\norapr.setOnsNodeList(‘node1:6200,node2:6200’)
\npropBean = drBean.getProperties()
\ndriverProps = Properties()
\ndriverProps.setProperty(“user”,dsUserName)
\ne = driverProps.propertyNames()
\nwhile e.hasMoreElements() : \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/span>
\n\u00a0<\/span>\u00a0 propName = e.nextElement() \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/span>
\n\u00a0<\/span>\u00a0 myBean = propBean.createProperty(propName)
\n\u00a0<\/span>\u00a0 myBean.setValue(driverProps.getProperty(propName)) \u00a0\u00a0<\/span>
\n\u00a0<\/span>
\n# Create the ConnectionPool Params
\nppBean = jdbcResource.getJDBCConnectionPoolParams()
\nppBean.setInitialCapacity(int(initCapacity))
\nppBean.setMaxCapacity(int(maxCapacity))
\nppBean.setTestConnectionsOnReserve(true)
\nppBean.setTestTableName(‘SQL SELECT 1 FROM DUAL’)<\/p>\nxaParams = jdbcResource.getJDBCXAParams()
\nxaParams.setKeepXaConnTillTxComplete(1) \u00a0\u00a0<\/span><\/p>\n# Add Target
\nfor datasourceTarget in datasourceTargets:
\nprint ‘DataSourceTargets’,datasourceTargets
\nprint ‘DataSourceTarget’,datasourceTarget
\nif datasourceTarget==”:
\n\u00a0<\/span>\u00a0 print ”
\nelse:
\n\u00a0<\/span>\u00a0 jdbcSystemResource.addTarget(getMBean(datasourceTarget)) \u00a0\u00a0<\/span> \u00a0<\/span>
\n\u00a0<\/span><\/p>\nprint ‘DataSource: ‘,dsName,’, has been created Successfully !!!’
\nprint ‘=========================================’<\/p>\n
save()
\nactivate() \u00a0\u00a0<\/span><\/p>\ndef main():
\npropInputStream1 = FileInputStream(“GridLinkDataSource.properties”)
\nconfigProps = util.Properties()
\nconfigProps.load(propInputStream1)<\/p>\n
adminURL=’t3:\/\/’+configProps.get(‘domain.AdminIP’)+’:’+configProps.get(‘domain.AdminPort’)
\nadminUserName=’weblogic’
\nadminPassword=configProps.get(“domain.AdminPasswd”)
\nconnect(adminUserName, adminPassword, adminURL)<\/p>\n
createGridLinkJDBCResources(configProps);<\/p>\n
print ‘Successfully created JDBC resources for SOACoreDomain’<\/p>\n
disconnect()<\/p>\n
\u00a0<\/span>
\nmain()<\/p>\nChange the values accordingly in the property file and execute the \u00a0$WLSHOME\/common\/bin\/wlst.sh GridLinkDatasourceCreation.py<\/p><\/div>\n
![\"weblogicssrrerew-14\"](\"http:\/\/rmohan.com\/wp-content\/uploads\/2015\/04\/weblogicssrrerew-14.jpg\")
<\/a><\/div>\n<\/div>\n
After the successful execution of the script login to console and verify the Gridlink datasource created.<\/div>\n
![\"weblogicssrrerew-15\"](\"http:\/\/rmohan.com\/wp-content\/uploads\/2015\/04\/weblogicssrrerew-15.jpg\")
<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Oracle Real Application Clusters (RAC) is a software component you can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance. RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology.<\/p>\n<\/p>\n
[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4646"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4646"}],"version-history":[{"count":4,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4646\/revisions"}],"predecessor-version":[{"id":4657,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4646\/revisions\/4657"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"weblogicssrrerew-12\"](\"http:\/\/rmohan.com\/wp-content\/uploads\/2015\/04\/oracle.jpg\")
<\/a><\/p>\n