Oracle forms 11g Admin server as a windows service

Oracle forms 11g

1. Admin server as a winservice

Step: 1

Take a backup copy of installSvc.cmd and save it as “classicdomain12_Adminserver_installSvc.cmd” which is available in the below location.

F:\Weblogic_MW_Home\wlserver_10.3\server\bin

Save the file as “classicdomain12_Adminserver_installSvc.cmd” in the same location.

Edit the newly created file

Add the below lines

>> 

set WL_HOME=F:\Weblogic_MW_Home\wlserver_10.3

set MYDOMAIN=F:\Weblogic_MW_Home\user_projects\domains\ClassicDomain12

call "%MYDOMAIN%\bin\setDomainEnv.cmd"

After the modification it will look like as below..

>> 

set WL_HOME=F:\Weblogic_MW_Home\wlserver_10.3

call "%WL_HOME%\common\bin\commEnv.cmd"

set MYDOMAIN=F:\Weblogic_MW_Home\user_projects\domains\ClassicDomain12

call "%MYDOMAIN%\bin\setDomainEnv.cmd"

Modify the below entry beasvc service entry in the same file “classicdomain12_Adminserver_installSvc.cmd”

Before Modification

rem *** Install the service

"%WL_HOME%\server\bin\beasvc" -install -svcname:"beasvc %DOMAIN_NAME%_%SERVER_NAME%" -javahome:"%JAVA_HOME%" -execdir:"%USERDOMAIN_HOME%" -maxconnectretries:"%MAX_CONNECT_RETRIES%" -host:"%HOST%" -port:"%PORT%" -extrapath:"%EXTRAPATH%" -password:"%WLS_PW%" -cmdline:%CMDLINE%

After Modification

rem *** Install the service

"%WL_HOME%\server\bin\beasvc" -install -debug -log:"C:\Temp\stdout.txt" -svcname:"beasvc %DOMAIN_NAME%_%SERVER_NAME%" -javahome:"%JAVA_HOME%" -execdir:"%USERDOMAIN_HOME%" -maxconnectretries:"%MAX_CONNECT_RETRIES%" -host:"%HOST%" -port:"%PORT%" -extrapath:"%EXTRAPATH%" -password:"%WLS_PW%" -cmdline:%CMDLINE%

Note : we can give the required log filename and respective path for our convenience

Step: 2

Create an install batch script that contains the domain, server details as below and save as a .cmd  like “createAdminserver.cmd” in “F:\Weblogic_MW_Home\user_projects\domains\ClassicDomain12\”

>> 

echo off

SETLOCAL

set DOMAIN_NAME=ClassicDomain12

set USERDOMAIN_HOME=F:\Weblogic_MW_Home\user_projects\domains\ClassicDomain12

set SERVER_NAME=AdminServer

set WL_HOME=F:\Weblogic_MW_Home\wlserver_10.3

set PRODUCTION_MODE=true

set WLS_USER=weblogic

set WLS_PW=xxxxxxxxxx

set MEM_ARGS=-Xms40m -Xmx250m

cd %USERDOMAIN_HOME%

call "F:\Weblogic_MW_Home\wlserver_10.3\server\bin\classicdomain12_Adminserver_installSvc.cmd"

ENDLOCAL 

Find out the missing table in all schema's query

select * from all_tables where table_name like '%XYZ%';

select * from recyclebin where original_name like '%XYZ%';