Oracle Weblogic 10.3.6, Recreating Node Manager Service, Weblogic Admin Console Services after Windows 8.1 upgrade

We have recently noticed something very interesting about Oracle’s services were absconding (means not to be seen) from Services listing, however the Oracle products are intact in all other means.

Earlier we shared a post explaining recreating the missing database services. Today we will try to explain how you can recreate missing Weblogic services. You MUST have Administrative access to the box, and en elevated command prompt (right click, start as administrator)

Assuming you have installed the Weblogic 10.3.6 server in the folder “D:\WebLogic\Middleware>” let us start

Start an elevated command prompt. Switch to “D:\WebLogic\Middleware>”

Let us do an old DOS trick to print all the .cmd files available with the repository

D:\WebLogic\Middleware>dir *.cmd /s > D:\weblogic_cmd_files.txt

Double click open the weblogic_cmd_files.txt file you just generated. The file must have following entries

Directory of D:\WebLogic\Middleware\modules\org.apache.ant_1.7.1\bin

04/04/2013  09:04 AM             2,857 ant.cmd
04/04/2013  09:04 AM             3,410 antenv.cmd
04/04/2013  09:04 AM             4,315 envset.cmd
04/04/2013  09:04 AM             1,817 runrc.cmd
4 File(s)         12,399 bytes

Directory of D:\WebLogic\Middleware\oracle_common\bin

02/09/2011  04:39 AM             2,002 copyBinary.cmd
02/09/2011  04:39 AM             1,995 copyConfig.cmd
11/23/2010  11:40 AM             2,071 extractMovePlan.cmd
02/09/2011  04:39 AM             3,237 pasteBinary.cmd
02/09/2011  04:39 AM             1,985 pasteConfig.cmd
5 File(s)         11,290 bytes

Directory of D:\WebLogic\Middleware\oracle_common\common\bin

01/20/2010  04:11 PM               663 config.cmd
04/02/2010  03:36 PM               596 getproperty.cmd
01/20/2010  04:11 PM               661 pack.cmd
01/20/2010  04:11 PM               783 setHomeDirs.cmd
11/08/2010  10:30 AM             2,143 setNMProps.cmd
12/13/2011  03:41 PM             5,066 setOjbstEnv.cmd
12/13/2011  03:41 PM               315 setWasConfigEnv.cmd
01/20/2010  04:11 PM                62 setWasHome.cmd
12/13/2011  03:41 PM                93 setWlstEnv.cmd
11/08/2010  10:30 AM             1,593 setWlstEnvExtns.cmd
12/13/2011  03:41 PM             5,490 setWsadminEnv.cmd
01/20/2010  04:11 PM               663 unpack.cmd
05/09/2011  04:51 PM             5,865 was_config.cmd
01/20/2010  04:11 PM             1,684 wlst.cmd
05/09/2011  04:51 PM             5,903 wsadmin.cmd
15 File(s)         31,580 bytes

Directory of D:\WebLogic\Middleware\oracle_common\rda

09/16/2011  05:40 PM             7,266 rda.cmd
1 File(s)          7,266 bytes

Directory of D:\WebLogic\Middleware\Oracle_FRHome1\BIN

10/12/2012  03:22 PM             2,408 shortenPaths.cmd
1 File(s)          2,408 bytes

Directory of D:\WebLogic\Middleware\Oracle_FRHome1\common\bin

01/20/2010  04:11 PM               663 config.cmd
01/20/2010  04:11 PM               661 pack.cmd
01/20/2010  04:11 PM               851 setHomeDirs.cmd
01/20/2010  04:11 PM               663 unpack.cmd
01/20/2010  04:11 PM               558 was_config.cmd
01/20/2010  04:11 PM             1,388 wlst.cmd
01/20/2010  04:11 PM               655 wsadmin.cmd
7 File(s)          5,439 bytes

Directory of D:\WebLogic\Middleware\Oracle_FRHome1\opmn\bin

05/01/2008  05:27 PM               228 opmnassociate.cmd
1 File(s)            228 bytes

Directory of D:\WebLogic\Middleware\Oracle_FRHome1\rda

09/16/2011  05:40 PM             7,266 rda.cmd
1 File(s)          7,266 bytes

Directory of D:\WebLogic\Middleware\user_projects\domains\appsdomain

04/05/2013  11:39 AM               381 InstallWindowsService_AdminServer.cmd
04/05/2013  11:50 AM               534 InstallWindowsService_WLS_FORMS.cmd
04/05/2013  12:43 PM               524 InstallWindowsService_WLS_REPORTS.cmd
04/04/2013  09:57 AM               319 startWebLogic.cmd
4 File(s)          1,758 bytes

Directory of D:\WebLogic\Middleware\user_projects\domains\appsdomain\bin

04/04/2013  09:57 AM            22,511 setDomainEnv.cmd
04/04/2013  09:57 AM             3,348 startManagedWebLogic.cmd
04/04/2013  09:57 AM             5,945 startWebLogic.cmd
04/04/2013  09:57 AM             2,525 stopManagedWebLogic.cmd
04/04/2013  09:57 AM             1,989 stopWebLogic.cmd
5 File(s)         36,318 bytes

Directory of D:\WebLogic\Middleware\user_projects\domains\appsdomain\bin\server_migration

04/04/2013  09:55 AM             6,521 wlsifconfig.cmd
1 File(s)          6,521 bytes

Directory of D:\WebLogic\Middleware\utils\bsu

04/04/2013  09:05 AM               330 bsu.cmd
1 File(s)            330 bytes

Directory of D:\WebLogic\Middleware\utils\clone

04/04/2013  09:04 AM               338 clone.cmd
04/04/2013  09:04 AM               311 restore.cmd
2 File(s)            649 bytes

Directory of D:\WebLogic\Middleware\utils\config\10.3

04/04/2013  09:05 AM               182 setHomeDirs.cmd
1 File(s)            182 bytes

Directory of D:\WebLogic\Middleware\utils\quickstart

04/04/2013  09:05 AM               735 quickstart.cmd
1 File(s)            735 bytes

Directory of D:\WebLogic\Middleware\utils\uninstall

04/04/2013  09:05 AM               811 uninstall.cmd
1 File(s)            811 bytes

Directory of D:\WebLogic\Middleware\wlserver_10.3\common\bin

04/04/2013  09:05 AM             9,132 commEnv.cmd
04/04/2013  09:05 AM             2,079 config.cmd
04/04/2013  09:05 AM             1,512 config_builder.cmd
04/04/2013  09:05 AM             1,666 pack.cmd
04/04/2013  09:05 AM             1,422 setPatchEnv.cmd
04/04/2013  09:05 AM             4,873 startDerby.cmd
04/04/2013  09:05 AM             3,909 startManagedWebLogic.cmd
04/04/2013  09:05 AM             1,851 stopDerby.cmd
04/04/2013  09:05 AM             1,780 unpack.cmd
04/04/2013  09:05 AM             3,288 upgrade.cmd
04/04/2013  09:04 AM               773 wlsifconfig.cmd
04/04/2013  09:05 AM               580 wlst.cmd
12 File(s)         32,865 bytes

Directory of D:\WebLogic\Middleware\wlserver_10.3\common\derby\bin

04/04/2013  09:05 AM               206 startNetworkServer.cmd
04/04/2013  09:05 AM               104 stopNetworkServer.cmd
2 File(s)            310 bytes

Directory of D:\WebLogic\Middleware\wlserver_10.3\common\quickstart

04/04/2013  09:05 AM               243 quickstart.cmd
1 File(s)            243 bytes

Directory of D:\WebLogic\Middleware\wlserver_10.3\server\bin

04/04/2013  09:05 AM             3,275 installNodeMgrSvc.cmd
04/04/2013  09:05 AM             6,309 installSvc – Backup.cmd
04/22/2013  09:16 PM             6,468 installSvc.cmd
04/05/2013  12:11 PM             6,269 installSvc_WLS_REPORTS.cmd
04/04/2013  09:05 AM             3,882 setWLSEnv.cmd
04/04/2013  09:05 AM             5,085 startNodeManager.cmd
04/04/2013  09:05 AM               701 uninstallNodeMgrSvc.cmd
04/04/2013  09:05 AM               992 uninstallSvc.cmd
8 File(s)         32,981 bytes

Directory of D:\WebLogic\Middleware\wlserver_10.3\uninstall

04/04/2013  09:05 AM               226 uninstall.cmd
1 File(s)            226 bytes

Total Files Listed:
75 File(s)        191,805 bytes
0 Dir(s)  97,695,387,648 bytes free

If you really know where exactly the .cmd files are, you may go ahead with the rest of the exercises. So the Node manager installer script is residing under D:\WebLogic\Middleware\wlserver_10.3\server\bin folder. Switch to the folder and execute the .cmd file

image

D:\WebLogic\Middleware>cd wlserver_10.3\server\bin

D:\WebLogic\Middleware\wlserver_10.3\server\bin>installNodeMgrSvc.cmd

Executing the .cmd file should create a new service and available to start within services console.

image

So once we created the Node Manager Service, we can start re-creating the optional service(s). We will limit ourselves to Weblogic Admin Console service, which is the maximum for our exercises. You may refer to our other post about installing & Configuring Weblogic 10.3.6 for details about creating individual services for Forms and Reports services.

Based on the application domain(the directory export will clearly give you an idea of the folders where components are installed) you have chosen during the installation, switch to the domain folder now

D:\WebLogic\Middleware\user_projects\domains\appsdomain

Here is where you will find the scripts you have modified earlier during an installation cycle (following our earlier posts)

D:\WebLogic\Middleware\user_projects\domains\appsdomain>InstallWindowsService_Ad
minServer.cmd

D:\WebLogic\Middleware\user_projects\domains\appsdomain>echo off

…………

…………

D:\WebLogic\Middleware\user_projects\domains\appsdomain>ENDLOCAL

D:\WebLogic\Middleware\user_projects\domains\appsdomain>

Check your Windows Services console, and you must find a new service “beasvc appsdomain_AdminServer” listed

Bravo, let us check whether the newly created services are REALLY working once after they were freshly created.

Weblogic Admin Console

image

So we are done, let us start the Forms & Reports Servers now.

image

We hope this helps :)

for Windows7bugs

raj

Quest Toad or Oracle SQL developer 4.0 (Early build)

 

There are no disputes, Quest Toad for Oracle is the BEST, for a programmer, DBA in an enterprise environment. Toad comes with a high price TAG, which makes many organizations which are not software development oriented, however do minor scale development to fill the business gaps, against Oracle databases, to make compromises and thus silently supporting pirated copies in distribution.

We were using Oracle SQL developer from last many years as our scenarios were mostly restricted to custom development and the DBA activities were managed by the console interactions itself.

From last few days we started checking out Oracle’s latest build (Early build) of SQL developer 4.0 and the first impression is quite fascinating. The prerequisites are limited to JDK 7.x which is becoming standard deployment in almost all scenarios.

A quick note about installing JDK7. Do not install JRE 7 yet, your ERP R12 instance may note support it, or minimum in our case. Install JDK always in a folder without spaces, like C:\JDK, D:\JDK7 etc

You can download the archive for the early build from Oracle download repositories

(JDK is not included, however from the same page you can download the installer)

Unzip the Developer archive (.zip) file to a local folder. The initial run will prompt for JDK location, which you can point to.

What is New

According to Oracle, these are the few new features added with SQL Developer 4.0

Oracle SQL Developer

New Features in Release 4.0

  • Database Performance Monitoring

    SQL Developer now provides a full interface for Oracle Database Enterprise Edition’s Diagnostic pack, including Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH). Accessible from the DBA panel, users can also manage their snapshots, baselines, and baseline templates.


  • Find Database Object – Search

    The database search is completely redesigned. The new tree layout allows for searches on multiple schema, object type, identifier types and usages. A history of your searches will be stored for later access. Search results can be viewed in a separate Editor where multiple search results can be pinned and displayed.

  • Command Line

    Command Line support has been extended to Reporting and to the Cart. You can run Reports and generate them into HTML format through the command line. The Cart  commands offer the ability to export objects and data. A set of predefined DDL generation options and data formats can be applied.


  • Cart

    The Cart has been greatly enhanced. You can create and work on multiple carts. The deployment of objects has been extended to give you more flexibility in selecting export DDL options and data formats. Export Object configurations can be saved and applied again. Compare Cart objects to another Cart or Connection with the Database Diff. Cart objects can also be copied with the Database Copy feature. Scripts are extended to include Before and After Data Load.

  • Reports

    Creating reports has never been easier. The create new report dialog has a tree layout for ease of navigation. An Advanced Option is available to instantly create Child and Drill Down type reports. Chart based reports include more chart types and you can test reports from anywhere within the report editor. Charts can be previewed in design mode. An HTML Report can be generated for any report. Enhancements in Database Doc generation include better layout and support for multiple threads to improve performance.


  • UI Enhancements

    The new UI changes in 4.0 enhances the overall look and feel of SQL Developer. A popular request on the Feature Exchange, a window border color can be dynamically set for a database connection. Useability improvements can be seen with with the new floating Editor and Navigation windows.

  • Data Modeler 4.0

    This version includes the new Data Modeler release 4.0. New features include 12c support for IDENTITY columns and masking of sensitive data with Redaction policy definitions at table and column level, create Transparent Sensitive Data Protection (TSDP) policies and associate it with sensitive types. See the full list of New Features here.

  • JDK 7
    JDK 7 Support

    This release supports JDK 7 and above. Download JDK 7 here.

 

Startup

Startup

Welcome screen

NWScreen

You will be asked whether the previous configurations should be migrated, incase if you were using previous versions of Oracle SQL developer. “Yes” will help you to save certainly a great amount of time, recreating the connections

The major difference between SQL developer and Quest Toad you may notice will be the look and feel, while Toad has a clear crisp interface to work with, which looks like earlier versions of Microsoft Office, the total look and feel of Oracle SQL Developer scores many less points. If you are from a pure #Linux environment, there is a high possibility that such look and feel experiences will not affect you much. On the other hand, sorry, your beauty expectations may be compromised to a certain extend.

As the name goes, SQL developer is mainly targeting SQL/PLSQL developers, hence if you are going to compare apple to apple, there are high chances that you will find Quest Toad a better partner, especially if you want to deal with the DBA activities also from the same console.

Memory consumption footprints

Let us look at a major concern for most of us, the memory consumption. Until recent days, laptops/notebooks were mostly equipped with decent 4GB memory, which was more than enough to do your stuff. However, with the emergence of 64Bit operating systems like Windows 7 & 8 the requirement for more memory has significantly changed and the latest default has become a minimum of 8GB.

MEMORY CON

TOAD MEM

A session with just connection established, SQL developer consumes 700 and more memory, while Quest Toad consumes less than 90MB the maximum, which could draw a line of concern, unless you have plenty of memory to spare. Please check the images above

DATAMANIPULATE

Other than the CPU & Memory demands, SQL developer provides almost all functionalities against populated data as in with Quest Toad.

Now, if you or your organization could afford to pay the high license fee Quest Toad demands,we will recommend Quest Toad as a primary choice as it comes with multiple flavors tailored for particular requirements like

  1. SQL/PLSQL development
  2. DBA Activities
  3. Performance monitoring

while Oracle SQL Developer is absolutely free, provide almost 70-80% of Toad’s functionality for a developer, at a high memory, CPU consumption compromise.

If you have thoughts, concerns, suggestions towards this post, please post them to us in the comments section.

regards,

for Windows7bugs

admin

Weblogic 10.3.6 Oracle Enterprise Manager(em) startup error “oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener”

 

Oracle Enterprise Manager(em) allows you to configure, re-configure multiple elements for Oracle forms and reports repositories as well as other deployed applications.

EM is the GUI tool provided by Oracle to configure, say, look and feel for your forms instance. Instead of manually editing formsweb.cfg, default.env, registry.dat files, using the GUI you can configure the elements related those whole configuration files, to say the least.

A default installation of Weblogic 10.3.6 does include Oracle Enterprise Manager, however if you created a service for the Weblogic Admin Server using installSvc.cmd at later stages to start the Weblogic Admin Server, most probably the Enterprise Manager will not start automatically as JAVA classpath variable misses out certain elements, thus throwing the error

“Error java.lang.ClassNotFoundException: oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener
Message icon – Warning Errors were encountered while performing this operation.”

After going through a number of OTN discussions, we managed to come up with a solution! by including “setDomainEnv.cmd” within installSvc.cmd batch file.

Please note, if you already created a windows service for Weblogic Admin Server, you must delete the service prior creating a new service. Once the service is gracefully stopped, go to elevated command prompt(Windows 8/ Windows Server 2008 Rx)  and type

SC DELETE “beasvc yourdomain_AdminServer”

Refresh the Services.msc console and make sure the service is deleted.

Now backup your installSvc.cmd file

We will modify the installSvc.cmd file (Location: example, D:\WebLogic\Middleware\wlserver_10.3\server\bin) like following (use a decent text editor like Notepad++ )

The following are the default entries you would find with “installSvc.cmd” file

[sourcecode language='text'  padlinenumbers='true']
@echo off
SETLOCAL


set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3

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

[/sourcecode]

Which we will modify like following

[sourcecode language='text' ]
@echo off
SETLOCAL


set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3

set ENV_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain\bin

call "%WL_HOME%\common\bin\commEnv.cmd"
call "%ENV_HOME%\setDomainEnv.cmd"
[/sourcecode]

Now go to folder, where you have created the .cmd file(s) for creating Windows services for

  1. Admin Server Console
  2. WLS_FORMS
  3. WLS_REPORTS

In our case we created all those “.cmd” files here

D:\WebLogic\Middleware\user_projects\domains\appsdomain

Now from the elevated command prompt

>InstallWindowsService_AdminServer.cmd (You can create the .cmd file with any name, we made it pretty descriptive for future references)

You may refer to our previous post, explaining how to install Weblogic Server 10.3.6 & Forms/Reports 11g for detailed explanation about creating Windows Services for Weblogic components.

Once the service is created, start it. Login to the console and check the status of “em” under deployments.

image

If the State is “Active” and Health is “OK”, your Enterprise manager is up and running. You can try to access the Enterprise manager from http://localhost:7001/em

image

You should provide the same credentials for the Weblogic Admin Console to login with EM.

image

From the EM Console, as said above, you can configure many parameters for Forms and Reports.

Even though you have managed to “fix” the EM access problem, there could be another issue, once after this exercise. You may not able to access the Forms or Report Server, though the Weblogic console shows them as running with Health being “Ok”

Stop the OPMN processes manually, and restart them and try again.

From elevated command prompt (if you haven’t sourced the environment variable for OPMN, change the working directory to, example: D:\WebLogic\Middleware\asinst_1\bin>)

and

  1. stop OPMN processes by issuing “opmnctl stopall”
  2. Check the status of the OPMN by issuing “opmnctl status”
  3. Wait until all the processes are stopped
  4. then restart the OPMN processes by issuing “opmnctl startall”
  5. Check the status and make sure all the processes are with a status “Alive”

That’s all guys. Hope you enjoyed our post.

regards,

Admin

Install & Configure Oracle Weblogic Server 10.3.6 & Forms & Reports 11g on Windows8/Windows 2008 R2

Hello guys, we just posted how to upgrade your existing  Forms & Reporots 32Bit 11.1.2.1.0  to 11.1.2.2.0. Why don’t check it out here?

We are running a blog explaining many workaround solutions for installing and configuring discontinued, uncertified Oracle software on Windows 7 & Windows 8 from last year onward.

Let us accept it, Developer 6i applications face multiple issues while used on both Windows 7&8 like:

  1. Intermittent crashes
  2. Rendering menu modules
  3. Stability
  4. Running products like Reports and Graphs

Usually a legacy application compiled using patch sets below 18 are less prone to above mentioned issues, however an application completely developed using patch 18 regularly get into issues on Windows 7 & 8 where hacks are used.

Recently we were forced to look towards a better environment for a new application, which by certain reasons cannot be accommodated and hosted within Oracle Application entity, and we started dwelling the possibilities of setting up a Weblogic server (old application server) for our forms and reports modules.

in short, we did it! and we are sharing the experience with you.

you need the following to carryout the installation and configuration

Windows 8/Windows 2008 R2 box (VM for testing)

Oracle Weblogic Server 10.3.6 (32Bit)

http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html

image

Oracle Forms and Reports 11g Release 2

http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html

image

(Hurry, you may not find the above software bundles with OTN after few weeks or months time)

Part 1 – Weblogic Server 10.3.6 Installation

Installation of Weblogic is pretty straight forward on Windows 8. Only once the compatibility issue is raised, which you can safely ignore by the click of a button.

The Weblogic 10.3.6 (wls1036_win32.exe) installation comes as a single .exe file, which you can start like any other installer.

Please have a look at the images

1

Choose a directory name without spaces, this is going to be your middleware home.

2

Uncheck the email notification, you don’t need it as far you don’t have a support from oracle

3

Select “Custom” installation type, as you can select which JDK to be selected and other components at later stages. We installed both JDK for our installation.

4

Click next to continue

5

Leave the selection as it is

6

Select Yes for “Node Manager Service”, it will make few things simpler at later stages, especially while you are using Admin Server for managing both forms and reports servers.

7

Select “All Users”

8

Clicking “Next” will start installing the Weblogic server 10.3.6 for you. Relax and wait until the installation completes.

9

10

Once installation has been done, you will be given an option to setup the Weblogic server with an instance, which we will do as a part of Forms & Reports 11g installation and configuration.

Part 2 – Installation of Oracle Forms and Reports 11g Release 2

Once you download the  Oracle Forms and Reports 11g Release 2, the zip archive must be unzipped to a folder, which will create Disk1, Disk2, Disk3 folders. You should start the “Setup.exe” from Disk1 folder. Once again the installation is straight forward, without requiring to make any specific hack to the installation media.

12

You must skip the “Software Update” option, unless you have the paid support from Oracle for the product you are installing.

3

Most important: You should select “Install Software – Do not configure” at this level, as the configuration will be done once after the installation completed.

4

On Windows 8 you will be notified about two vital check failures, however allowing you to continue the installation at own risk by clicking the “Continue” button.

5

Next page will clearly notify you that you must have an application server already installed. Application server akka Weblogic server. Without Weblogic server you cannot use Oracle Forms and Reports 11g Release 2 even for development purpose.

6

7

You can safely ignore being updated about the software updates once again

8

Once you say yes to software update related prompt, the installation will start

9

10

11

Now you have finished installing Oracle Forms and Reports 11g Release 2 on Windows 8/Windows 2008 R2

Part 3 – Configuring the Weblogic server with forms and reports 11g

As we have installed “Node Manager Service” prior configuring the forms and reports, we need to stop the Node Manager Service from Windows services console

Invoke “services.msc” and stop the following service “Oracle Weblogic NodeManager(D_Weblogic_Middleware_wlserver_10.3)

If you don’t stop this service, you are going to come across issues as discussed here

To configure the Weblogic server for forms and reports, you need to invoke the “Configure Classic Instance” cmd file from Windows menu folder “Oracle Classic 11g – Home1”

1

2

It may take couple of minutes until you are provided the installation application GUI as shown below. Click next

3

Select the option “Configure for Deployment”

4

Unless you are entitled for Oracle support ignore the email part

56

Now, choose a meaningful name for your Oracle instance.

7

Important: You must note down the following details for future references. We opted to use the username suggested by Oracle during the configuration which is “weblogic” and provide a password consist of alphabets and minimum one digit (number)

Domain is the node which will be setup with Weblogic for Administration server as well for both Forms and Reports Servers.

8

By default, Developer tools are not selected, you MUST select this node, incase if you are going to use the same machine for development (which is our objective with this exercise). You may uncheck the “Clustered” option, unless used in a production environment.

9

Select “Auto Port Configuration”

10

Try to avoid using Proxy. Microsoft ISA server can make the whole experience a parody, if used.

11

Use Identity management, only if already implemented and business mandatory. Else leave it unchecked

12

Click on “Configure” button and sit back, until the process is over!

13141516

You may save the installation responses for a future installation by clicking the Save button. Click “Finish” button to exit the configuration wizard

17

You can access the Weblogic Admin Server by visiting http://localhost:7001/console & the Enterprise manager through http://localhost:7001/em

You may run into issues accessing the Enterprise Manager, incase if you have automated the weblogic admin server startup part using services & we have another post explaining how to tackle it here

weblogic console

If the node manager service is installed you can start and stop various components for the domain through this console.

Part 4 – Starting and Stopping domain components AdminServer, WLS_FORMS(Forms Server), WLS_REPORTS(Reports server)

Oracle provides batch files to start and stop all the above mentioned components. You may start just WLS_FORMS and WLS_REPORTS services, unless planning to manage them through the Admin Server console.

Starting Weblogi Admin Server

AdminServer Start

Starting Forms Server

Forms Server Start

Starting Reports Server

Report Server Start

Part 5 – Automating Weblogic Admin Server, WLS_FORMS(Forms Server), WLS_REPORTS(Reports server) startup with Windows Services

Let us agree, the cmd windows look ugly, dangerous and a user can close them down, thus bringing the entire servers down unintentionally. A windows service looks much favorable under such scenarios and wise people from Oracle do provide solutions to create windows services for

  1. Weblogic Admin Server
  2. WLS_FORMS (Forms Server)
  3. WLS_REPORTS (Reports Server)

Creating Windows services for Admin Server and Forms server are pretty simple and straight forward business, while CMD command line length limitations will make Reports Server service creation a little difficult, don’t worry we have solution for it also.

Part 6 – Creating Windows Service for Weblogic Admin Server

Pre-requisite(s)

Notepad++ (or any decent text editor other than Windows notepad)

Create a .cmd file named “Install_AdminServer.cmd” with the following lines

[sourcecode language=”text” padlinenumbers=”true”]
echo off

SETLOCAL

set DOMAIN_NAME=appsdomain

set USERDOMAIN_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain

set SERVER_NAME=AdminServer

set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3

set WLS_USER=weblogic

set WLS_PW=pass123

set PRODUCTION_MODE=true

set MEM_ARGS=-Xms512m -Xmx512m

call "%WL_HOME%\server\bin\installSvc.cmd"

ENDLOCAL
[/sourcecode]

Please note, you must provide the absolute domain name and physical directory names based on your installation preferences!

Save the script to “USERDOMAIN_HOME” folder, ie, “D:\WebLogic\Middleware\user_projects\domains\appsdomain” in our case

From elevated command line, execute the batch file, and the Windows service for Admin Server must be created, unless there were mismatches with the information supplied

Part 7 – Creating Windows Service for WLS_FORMS(Forms Server)

Create a .cmd file “InstallWLS_FORMS.cmd” using Notepad++ with following lines

[sourcecode language=”text”]
echo off

SETLOCAL

set DOMAIN_NAME=appsdomain

set USERDOMAIN_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain

set SERVER_NAME=WLS_FORMS

set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3

set WLS_USER=weblogic

set WLS_PW=pass123

set PRODUCTION_MODE=true

set ADMIN_URL=http://localhost:7001

cd %USERDOMAIN_HOME%

call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd

rem *** call "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"

call "%WL_HOME%\server\bin\installSvc.cmd"

ENDLOCAL
[/sourcecode]

Save the script to “USERDOMAIN_HOME” folder, ie, “D:\WebLogic\Middleware\user_projects\domains\appsdomain” in our case

From elevated command line, execute the batch file, and the Windows service for WLS_FORMS must be created, unless there were mismatches with the information supplied

Part 8 – Creating Windows Service for WLS_REPORTS(Reports Server)

Create a .cmd file “InstallWLS_REPORTS.cmd” using Notepad++ with following lines

[sourcecode language=”text”]
SETLOCAL

set DOMAIN_NAME=appsdomain

set USERDOMAIN_HOME=D:\WebLogic\Middleware\user_projects\domains\appsdomain

set SERVER_NAME=WLS_REPORTS

set WL_HOME=D:\WebLogic\Middleware\wlserver_10.3

set WLS_USER=weblogic

set WLS_PW=pass123

set PRODUCTION_MODE=true

set ADMIN_URL=http://localhost:7001

cd %USERDOMAIN_HOME%

call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd

rem *** call "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"

call "%WL_HOME%\server\bin\installSvc.cmd"

ENDLOCAL
[/sourcecode]

Unfortunately, you cannot just run the .cmd file and create a service for WLS_REPORTS like other services, as the java CLASSPATH for reports server has more than 3000 character length, which is beyond 32Bit command line architecture.

Hence you have to do a minor hack, as provided as a solution by Oracle.

Go to “D:\WebLogic\Middleware\wlserver_10.3\server\bin” folder (equivalent on your machine) and make a backup for the file “InstallSvc.cmd”

If the report server is running, terminate it by using Ctrl+C within the open cmd window

Wait until the server shutdown. Check the status through Admin Console.

Now restart the Report Server, using the menu interface

Report Server Start

Mark and copy the CLASSPATH= output and paste it to a new text document. You have to spend few minutes to wrap up the text and make sure the entire text is wrapped into a single line (This is why we love Notepad++)

Marking_Classpath

Add “set” in front of CLASSPATH= and your txt file content should look something like below and save the text file as “myClasspath.txt”

[sourcecode language=”text”]
set CLASSPATH=D:\WebLogic\Middleware\Oracle_FRHome1\jdbc\lib\ojdbc6.jar;;;D:\WebLogic\MIDDLE~1\ORACLE~1\modules\oracle.jdbc_11.1.1\ojdbc6dms.jar;D:\WebLogic\MIDDLE~1\patch_wls1036\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\WebLogic\MIDDLE~1\JROCKI~1.0-1\lib\tools.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;D:\WebLogic\MIDDLE~1\modules\features\weblogic.server.modules_10.3.6.0.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\WebLogic\MIDDLE~1\modules\ORGAPA~1.1/lib/ant-all.jar;D:\WebLogic\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;D:\WebLogic\Middleware\wlserver_10.3\server\lib\weblogic.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.dms_11.1.1\dms.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jmx_11.1.1\jmxframework.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jmx_11.1.1\jmxspi.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.odl_11.1.1\ojdl.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\adf-share-mbeans-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\mdswlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\auditwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jps-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jrf-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamAuthnProvider.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\sslconfigwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\wsm-wlst.jar;D:\WebLogic\Middleware\wlserver_10.3\server\lib\weblogic.jar;D:\WebLogic\Middleware\Oracle_FRHome1\opmn\lib\nonj2eembeans.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jdbc\lib\ojdbc6.jar;D:\WebLogic\Middleware\Oracle_FRHome1\opmn\lib\optic.jar;D:\WebLogic\Middleware\Oracle_FRHome1\opmn\lib\iasprovision.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\adf-share-mbeans-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\lib\mdswlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\auditwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jps-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\jrf-wlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\oamAuthnProvider.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap_help.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\ossoiap.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\sslconfigwlst.jar;D:\WebLogic\Middleware\Oracle_FRHome1\common\wlst\resources\wsm-wlst.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.adf.share_11.1.1\commons-el.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\dfc.jar;D:\WebLogic\Middleware\Oracle_FRHome1\dvt\lib\dvt-jclient.jar;D:\WebLogic\Middleware\Oracle_FRHome1\dvt\lib\dvt-utils.jar;D:\WebLogic\Middleware\oracle_common\jlib\ewt3.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.iau_11.1.1\fmw_audit.jar;D:\WebLogic\Middleware\Oracle_FRHome1\oui\jlib\http_client.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.idm_11.1.1\identitystore.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.idm_11.1.1\identityutils.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jps_11.1.1\jaccprovider.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.jps_11.1.1\jacc-spi.jar;D:\WebLogic\Middleware\Oracle_FRHome1\ord\jlib\jai_codec.jar;D:\WebLogic\Middleware\Oracle_FRHome1\ord\jlib\jai_core.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.oc4j-obsolete_11.1.1\jazn.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.oc4j-obsolete_11.1.1\jazncore.jar;D:\WebLogic\Middleware\oracle_common\jlib\jewt4.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\jta.jar;D:\WebLogic\Middleware\oracle_common\modules\oracle.ldap_11.1.1\ldapjclnt11.jar;D:\WebLogic\Middleware\Oracle_FRHome1\lib\mail.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\netcfg.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\oracle_ice.jar;D:\WebLogic\Middleware\oracle_common\jlib\share.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\zrclient.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\aolj.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\confmbean.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\runtimembean.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwadmin.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwenv.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwrun.jar;D:\WebLogic\Middleware\Oracle_FRHome1\reports\jlib\rwxdo.jar;D:\WebLogic\Middleware\Oracle_FRHome1\jlib\rts2.jar;;D:\WebLogic\MIDDLE~1\ORACLE~1\soa\modules\commons-cli-1.1.jar;D:\WebLogic\MIDDLE~1\ORACLE~1\soa\modules\oracle.soa.mgmt_11.1.1\soa-infra-mgmt.jar;D:\WebLogic\MIDDLE~1\ORACLE~1\modules\oracle.jrf_11.1.1\jrf.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbyclient.jar;D:\WebLogic\MIDDLE~1\WLSERV~1.3\server\lib\xqrl.jar
[/sourcecode]

Now open the “InstallSvc.cmd” using Notepad++ and locate the line “set CLASSPATH=%WEBLOGIC_CLASSPATH%;%CLASSPATH%” and comment the same like

rem *** set CLASSPATH=%WEBLOGIC_CLASSPATH%;%CLASSPATH%

Now locate the line “set CMDLINE” within the “InstallSvc.cmd” and change the line like following

[sourcecode language=”text”]
set CMDLINE="%JAVA_VM% %MEM_ARGS% %JAVA_OPTIONS% -classpath @d:\myClasspath.txt -Dweblogic.Name=%SERVER_NAME% -Dweblogic.management.username=%WLS_USER% -Dweblogic.management.server=\"%ADMIN_URL%\" -Dweblogic.ProductionModeEnabled=%PRODUCTION_MODE% -Djava.security.policy=\"%WL_HOME%\server\lib\weblogic.policy\" weblogic.Server"
[/sourcecode]

There are two instances of set CMDLINE, you must change both lines, only replacing the “-classpath \”%CLASSPATH%\” part with -classpath @d:\myClasspath.txt

After the above, from elevated command line, execute the batch file, and the Windows service for WLS_REPORTS must be created, unless there were mismatches with the information supplied

Services

Change “Automatic” to “Manual” for better ease, at various situations. You may create a .cmd file for starting the services and another one for stopping them.

From our prospects, these services are just a facelift for the batch files, avoiding the immediate problems with accidental closure of cmd windows and thus causing serious issues to the instance. We came to this conclusion because, the service status are not updated incase if one of the services stopped by the Admin Server console at later stages, neither the service status update waits until the actual server starts to update  state of the service.

You can delete whole these service from command prompt, after stopping like following

>SC DELETE “service name”

We hope you will enjoy setting up Weblogic 10.3.6 and Oracle Forms and Reports 11g Release 2 on Windows 8/ Windows 2008 R2 following the instruction set provided above.

Regards,

admin

Install Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 (64Bit) on Windows 8 Professional 64Bit

 

Environment

  1. Windows 8 Professional – 64Bit (i5 Processor, 8GB memory)
  2. Database 11g Enterprise Edition Release 11.2.0.1.0 (64Bit)

Important

Once you finished downloading the installation source from Oracle, extract the files using any available unzip utility.

Copy all the folders from “win64_11gR2_database_2of2\database\stage\Components” to

“win64_11gR2_database_1of2\database\stage\Components” folder to avoid warnings about missing components during installation. Oracle should fix it, right?

If your computer is a domain member, then

    1. Create a local user
    2. Add the user to “Administrator” group
    3. Logon as local user
    4. If you are installing Oracle on D:\ , right click and assign full rights to your account on that particular drive. Only applicable with Window7 and Windows 8

Start the installation, and you will be provided a warning. Refer the image below

warning1

Ignore it

Proceed with the installation

Ignore the update related warning also

warning2

Just follow the prompts and complete the installation. It should be a smooth sailing.

Prior trying to access the database, make sure you changed the sqlnet.ora file following

# sqlnet.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install “Software Only”, this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

We will post more screen shots soon. Stay tuned!

regards,

admin

Windows 8, Should Microsoft enable the start menu?

Huge arguments everywhere! Being developers all around the clock, #windows7bugs believes, the choice should be left alone on individual user.

We are trying to demonstrate, how a classic menu approach would make things a bit better for developers, techies who have to browse through pool of sub-menu elements to do their everyday job!

Windows 8 new startup interface

start-menupng

Okay, we are techies and we will find out what we want from the tiled interface (after spending pretty decent time) pool and “try” to pretend that we are with the move

Worse scenarios, we just use classic shell and get straight on to our desired application. We are not ashamed to say we are from the ol ol schools Smile

classic_start

Bravo, now we can see Microsoft sending away few techies who thought they would be remembered for their “outstanding” visionary approaches with a no-harm meant “start” button elimination and easy access to applications through “metro” tiled application UI!

Yes, Microsoft, bring back what was there, let the users decide whether they want to change, finally like our employer always reminds us “Customer is the GOD”. So listen to customers and give them what they ask for.

for windows7bugs

admin

Windows 8, Classic Shell

Okay guys, after a week of “tolerating” windows 8 without a start button, being developers who are always trying to get “stuff” through start button –> programs, decided to go back to “Classic Shell” approach.

Neat and free, this small application could make a developer’s life pretty easier with a mouse click access to all programs! Give it a try and download it from here

for windows7bugs

admin

Windows 8, Antivirus solution(s)

Should you use a third party antivirus, anti-malware solution with your new Windows 8 OS is entirely a new debate, as Windows 8 comes with built-in solution for both antivirus, anti-malware.

Windows defender akka Microsoft security essentials in new shape should be more than enough to protect a normal user who doesn’t take risks by visiting websites known for spyware and other malicious codes.

We prefer to stay with Windows defender, as the complete solution is developed and maintained by Microsoft. Who knows the OS better than the them?

However, Avast suite (both free and paid editions) should give you a better level of peace of mind. We, as windows7bugs have already tried both scenarios (Windows defender and Avast paid edition) and opted to stay with Windows defender.

Now it is your turn to make a decision! The rule of thumb is, don’t take unwanted risks by visiting ill reputation sites and trying cracks, patches one use to “crack” legitimate software!

for windows7bugs

admin