How to check Stuck Threads in logs
At the time of stuck threads we will get alerts we can see the servers are in warning state at the the time we can login to the particular warning…
Read MoreEXPORT AND IMPORT DATAPUMP IN DATABASE_LINK PARAMETER
In this blog we are going to learn about the export and import in datapump using database link. DESCRIPTION: A database link , is a schema object in one database that…
Read MoreORACLE DATABSE CLONING USING COLD BACKUP
ORACLE DATABSE CLONING USING COLD BACKUP DESCRIPTION: The Cold database backup is, while taking backup or doing cloning, we need to shutdown the source database. This method is usually used for test server when database is in no archive log mode. First we want to take a backup of control file, note down the data file location, and finally shut down the database in source database side. Second. Transfer the data file, temp file to target database, create a pfile(init.ora) for target database. Then start the target database in no mount stage, then in there recreate a control file, then open the database in reset logs. Send the datafile,log files and control files to target destination: [oracle@oracle trainee]$ scp -r *.log oracle@192.168.1.122:/u01/shan The authenticity of host ‘192.168.1.122 (192.168.1.122)’ can’t be established. RSA key fingerprint is 9b:35:ae:ab:bf:6b:33:b4:43:86:f5:98:8b:bb:11:1c. Are you sure you want to continue connecting (yes/no)? oracle Please type ‘yes’ or ‘no’: yes oracle@192.168.1.122’s password: redo01.log 100% 200MB 3.1MB/s 01:05 redo02.log 100% 200MB 4.0MB/s 00:50 redo03.log 100% 200MB 3.5MB/s 00:58 [oracle@oracle trainee]$ scp -r users01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: users01.dbf 100% 5128KB 5.0MB/s 00:01 [oracle@oracle trainee]$ scp -r undotbs01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: undotbs01.dbf 100% 70MB 3.7MB/s 00:19 [oracle@oracle trainee]$ scp -r temp01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: temp01.dbf 100% 32MB 2.9MB/s 00:11…
Read MoreWeblogic boot.properties
Setting up boot.properties While starting weblogic server [including AdminServer], it will check for a file called boot.properties in <domain_home>/servers/AdminServer/security. This file can hold the property values for username and password…
Read Morecreate a domain by using console mode
Steps to create a domain by using Console mode:– Go to <WL_HOME>/common/bin (WL_HOME=”D:\Oracle_Jun\Middleware\wlserver_10.3″> Execute config.sh -mode=console Provide domain name, location, username, passord and necessary parameters 4. Once domain is…
Read MoreCreation of Domain GUI mode
Steps to create a domain by using GUI Mode Go to <WL_HOME>/common/bin (WL_HOME=”D:\Oracle_Jun\Middleware\wlserver_10.3″> Execute config.sh Provide domain name, location, username, passord and necessary parameters Once domain is created successfully we…
Read MoreInstall WLS by using Silent Mode
Steps to install WLS by using Silent Mode:- Download sample silent.xml file Specify the values for the parameters BEAHOME, WLS_INSTALL_DIR and specify the neccessary components to be installed Check the…
Read MoreInstall WLS by using Console Mode
Steps to install WLS by using Console Mode:- Check the prerequisites like disk space, file permissions and compatibility Execute Weblogic setup executable file by using…
Read More