Month: November 2013

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

On By windows7bugsIn Oracle related, Windows 8Leave a comment

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

Changing the Theme for Windows7bugs.wordpress.com

On By windows7bugsIn Offtopic1 Comment

We were using “contempt” another free theme available @ wordpress until today morning & coming across “http://oraclefinancial.wordpress.com/2010/10/14/general-ledger-calendar-setup-and-usage/” has changed our prospective about sticking to four years old “contempt” theme. We felt, the “Andreas09” gives us more “room” to post the “technical” contents by utilizing the maximum screen size available.

What you think about the theme change, if our change affects your reading experience, please do let us know with the comments session.

Advantages from our blogging prospects

Bigger images

Contempt image space

image

With “Andreas9” we have the advantage to have bigger images, which could avoid clicking and zooming

Image size: Medium

image

Image size: Large

image

Scripts lines are not anymore exceeding the available real estate

[sourcecode language="sql" padlinenumbers="true"]
SET SERVEROUTPUT ON SIZE UNLIMITED;
Declare
Cursor c1 is
Select distinct sold_from_org_id org_id, order_quantity_uom uom, inventory_item_id, 'O' line_source from oe_order_lines_all where sold_to_org_id = 3892
union all
Select distinct  odh.org_id,  odl.uom, odl.inventory_item_id, 'D' line_source from 
oms_dn_lines_all odl, oms_dn_headers_all odh
where 1=1
and odh.header_id = odl.header_id
and odh.customer_id = 3892 
and odl.inventory_item_id NOT IN (
Select inventory_item_id from oe_order_lines_all where sold_to_org_id = 3892)
and odl.inventory_item_id IS NOT NULL
union all
Select organization_id org_id, primary_uom_code uom, inventory_item_id, 'N' line_source from mtl_system_items where
1=1
and organization_id = 110
and inventory_item_id NOT IN (
Select inventory_item_id from oe_order_lines_all where sold_to_org_id = 3892
union all
Select inventory_item_id from oms_dn_lines_all where customer_id = 3892 and inventory_item_id IS NOT NULL)
order by inventory_item_id;
[/sourcecode]

regards,

for Windows7bugs

admin

Quest Toad or Oracle SQL developer 4.0 (Early build)

On By windows7bugsIn Oracle related1 Comment

 

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