How to Update Datasource Connect String ?

Scenario 1) Updating all datasource with same connect string 

===============================================

step a) create updateds.py file at $DOMAIN_HOME

dsURL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))"
print("*** Wait for a moment trying to connect *****")
connect('weblogic','xxxxxxx','t3://localhost:7001')
print("*** Connected *****")
cd('Servers/AdminServer')
edit()
startEdit()
cd('JDBCSystemResources')
for tmpDS in allDS:
  dataSourceName=tmpDS.getName();
  print  'changing datasource connect string for', dataSourceName
  cd('/JDBCSystemResources/' + dataSourceName + '/JDBCResource/' + dataSourceName + '/JDBCDriverParams/' + dataSourceName)
  cmo.setUrl(dsURL)
  print("*** connect string changed for your: ", dataSourceName)
  print ('')
  print ('')
save()
activate()


step b) Execute updateds.py script using below commands

cd $DOMAIN_HOME/bin
. ./setDomainEnv.sh
java weblogic.WLST updateds.py

Scenario 2) Updating Single datasource(ex: SOADS) with specified connect string(ex: dsURL)

=========================================================

step a) create updateds.py file at $DOMAIN_HOME

dsURL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))"
print("*** Trying to Connect.... *****")
connect('weblogic','xxxxxxx','t3://localhost:7001')
print("*** Connected *****")
cd('Servers/AdminServer')
edit()
startEdit()
dsName="SOADS"
cd('JDBCSystemResources')
print  'changing datasource connect string for', dsName
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName)
cmo.setUrl(dsURL)
print("*** connect string changed for your: ", dsName)
print ('')
print ('')
save()
activate()

Step b) Execute updateds.py script using below commands

cd $DOMAIN_HOME/bin
. ./setDomainEnv.sh
java weblogic.WLST updateds.py

Comments

Post a Comment

Popular posts from this blog

How To Recover Custom Identity And Custom Trust Keystore Password

Image
==> Password information are stored in security data file  SerializedSystemIni.dat which cannot be readable like text files. ==> Encrypted passwords are stored in config.xml, boot.properties And DataSource-jdbc.xml file can be visible to user. ==> Using Encrypted password and SerializedSystemIni.dat file we can recover passwords ==> Using this method one can recover password for  weblogic Admin Console KeyStore password Data source Password  1) Create a file DecryptTest.py  with below content in $DOMAIN_HOME/security directory from weblogic.security.internal import * from weblogic.security.internal.encryption import * #This will prompt you to make sure you have SerializedSystemIni.dat file under #current directory from where you are running command raw_input("Please make sure you have SerializedSystemIni.dat inside the current directory, if yes press ENTER to continue.") # Encryption service encryptionService = Seri...
Read more

How To Install Oracle WebLogic Server 12.2.1.1.0 Using Silent Mode ?

Image
Summary       1) Create OS User and Group      2) Create Required Directories      3) Assign The Ownership and Permission To Directories      4) Install the JDK and Export The JAVA_HOME in .bash_profile      5) Prepare The Response file.      6) Create The File oraInst.loc And add inventory_loc and inst_group      7) Start The WebLogic Server Binaries Installation Using Silent Mode      8) Create WebLogic Domain Using WLST. 1. Create OS User and Group        groupadd -g 54321 oinstall        useradd -u 54322 -g oinstall oracle        passwd oracle 2. Create Required Directories         mkdir -p /oracle/Middleware        mkdir -p /jdk/jvm 3. Assign The Ownership and Permission To Directories...
Read more

Cannot load /etc/httpd/modules/mod_wl_24.so into server: libopmnsecure.so: cannot open shared object file: No such file or directory

Image
Issue Definition:-    ==> All plugin files are copied to the apache module folder /etc/httpd/modules   ==> In httpd.conf below line is added     LoadModule weblogic_module  /etc/httpd/modules/mod_wl_24.so   ==> Below issue occurs while loading WebLogic Pxoy Plugin 12.2.1.2.0             While executing " httpd -t "  OR ". /apachectl -t " [root@test2 conf]# httpd -t httpd: Syntax error on line 60 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/modules/mod_wl_24.so into server: libopmnsecure.so: cannot open shared object file: No such file or directory [root@test2 conf]# Cause:-  This issue occurs because link to shared library are not present Solution :-   a) Edit the file  ld.so.conf by adding plugin module path /etc/httpd/modules    vi /etc/ld.so.conf    /etc/httpd/modules   b) Execute below command    ldco...
Read more