Archive for the ‘Windows’ Category

Installation Steps Of OAF or JDeveloper

May 7th, 2017, posted in Oracle, Windows
Share

If you want to do some OAF Development in JDeveloper for the first time, you will need to do the following things.

1] Download JDeveloper Patch

Based on your instance release level, check out the version of JDeveloper to use using below link.

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=416708.1

You can identify the OA Framework version in your instance by activating diagnostics and click the “About This Page” from any OAF page. Click the “Technology Components” tab. The OA Framework version in the top row of the table can then be matched to the JDeveloper Patch.

Download the JDeveloper Patch.

You can also use this query to find about your version :
SELECT release_name FROM fnd_product_groups;


2] Extract the JDeveloper patch in a directory say D:\DevSuiteHome_1\jdev

The patch actually contains below three directories

  • jdevbin – Includes an extended version of the Oracle JDeveloper 10g executable and OA Framework class libraries.
  • jdevhome – Includes the OA Framework Toolbox Tutorial source and developer working area.
  • jdevdoc – Contains documentation.

Installation Steps Of OAF or JDeveloper,Oracle DBA,Apps DBA,Application DBA,Oracle Installation,Installation of OAF,Installation JDeveloper

3] Define an environment variable

Define an environment variable JDEV_USER_HOME for your local machine. This has to be set to jdevhome\jdev directory. In above example it has to be D:\DevSuiteHome_1\jdev\jdevhome\jdev.

My Computer Properties Advanced tab Environment Variables New

Variable: JDEV_USER_HOME

Value: D:\DevSuiteHome_1\jdev\jdevhome\jdev

Installation Steps Of OAF or JDeveloper,Oracle DBA,Apps DBA,Application DBA,Oracle Installation,Installation of OAF,Installation JDeveloper,environment file,windows environment file

4] Create the shortcut of jdevW

Their you will find jdev and jdevW icons. The jdev is for UNIX environment and jdevW is for Windows environment.
Create the shortcut of jdevW. And send to desktop

Installation Steps Of OAF or JDeveloper,Oracle DBA,Apps DBA,Application DBA,Oracle Installation,Installation of OAF,Installation JDeveloper

Also can be check by this :
http://hostname.com:portnumber/OA_HTML/jsp/fnd/aoljtest.jsp

4] Move the DBC file

After creating the environment veriable we have to move the DBC file from Oracle Apps fnd top to jDeveloper patch.

Here we are using WinScp which connects to the server from our desktop system.
After finding where exactly the DBC file located go to that particular path and copy the DBC file.
(/oracle/apps/r12/inst/apps/visr12_ebsr12/appl/fnd/12.0.0/secure)

After copying, in your desktop system go to
Jdevhome–> jdev–> dbc_files–> secure
Here we will not find any files or documents the folder is empty now we need to paste the DBC file which we copied from the Oracle Apps Instance Server.

5] Now Test Database

After moving the DBC file now open the JDeveloper and create the Data Base Connection.

After opening the file it will ask for Configure File Type Associations, on check box check all the available types to associate with JDeveloper.

Go to Connections tab after that Right Click on Data Base folder and then select New Database Connection…

1

2 3 4 5

6] Set The Default Project Properties

After creating the DataBase Connections, Set the default project properties.

Go to Tools -> Default Project Properties

1

 

In that select Runtime connection, adjust the runtime connection information, necessary for the database and Oracle E-Business Suite.

Brows the DBC file from the jDeveloper patch where we moved from the server.
(Jdevhome–> jdev–> dbc_files–> secure)

Username: The user name is Oracle Apps instance User Name
Password:  Password is Oracle Apps instance Password.

Application Short Name: In which application u want to run give the Application Short Name of that application.
Responsibility key: Responsibility key of that application short name.

 Application DBA, APPS DBA, Installation JDeveloper, Installation of OAF, Installation Steps Of OAF or JDeveloper, Oracle DBA, Oracle Installation

Share

How To Migrate PUTTY Settings From One Windows Desktop/Laptop To The Other

March 13th, 2017, posted in Windows
Share

How To Migrate PUTTY Settings From One Windows Desktop/Laptop To The Other ?

Migrating putty settings from one desktop/laptop to the other box comes in handy when you had already customized your putty with saved sessions. The migration will also help a new member of an exisitng DBA support team.

Here are the steps

Start -> Run (or Windows Button + R)
Type in ‘regedit’ and press enter – this command will open the registry editor window
Go to HKEY_CURRENT_USER -> Software -> SimonTatham
Right Click on SimonTatham and select Export
Provide a file name and save the file.

Copy and execute the exported file on the new box – voila .. you are all set with the putty on the new box.





Note: this will only bring the putty configurations and NOT the putty executable
itself !!
Share

How To Upload Excel/Text File Data Into Oracle Table Using TOAD

February 27th, 2017, posted in Oracle, Windows
Share

n this we will explain how to put Excel or text file data into an Oracle table. You can do this easily in SQL Server with a Copy (Ctrl+C) of the data from Excel then open the target table into edit mode and Paste (Ctrl+V). Done.

But this will not work in Oracle.

In an Oracle database you can do it using the import command. I will show you each and every step with snapshots.

Step 1 : Open TOAD.

Step 2 : Write the following query to create a test table:

  1. Create table TESTTABLE
  2. (
  3. NAME varchar2(20),
  4. Address varchar2(100),
  5. RollNo integer
  6. )

Step 3 : Now my table is ready. It’s time to create the data in an Excel file.

Step 4 : Go to Database -> Import -> Table Data.

Step 5 : Select the table you want to import the Excel data to.

Step 6 : Click on show data. Now execute the data button to enable the use. Click on that.

Step 7 : After clicking on Execute Wizard the following screen will open:

Next ->

Step 8 : Now, browse to your Excel file – > Next ->

Next ->

Step 9 : Choose the sheet and click on AutoMap. The AutoMap button will automatically bind your Excel sheet column data with the Oracle table column.

Next ->

Next ->

Here your Excel data has been bound with the table columns. Next ->

Step 10 : Click on Execute to finish the process. It may ask for sheet selection. Click on Okay with the desired sheet.

Here is your uploaded data:

Step 11 : Commit the Task by clicking on the commit button.

Using the preceding procedure you can easily import Excel data. You can also import text flat files data. All steps are nearly the same. The only change is the following step. In this import I need to choose the separator for the flat file. Apart from any separators you can use fixed width. In the attached example I used a comma separator.

I think the procedure is very clear with snapshots. If you have found any mistake in concept, please do comment.

Your comments will make me perfect in the future.

Thanks for reading.

 

Share

Unprotect An Excel Sheet Without Password

December 6th, 2015, posted in Programming, Windows
Share

Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet ,Without Password,Unprotect An Excel Without Password,An Excel Without Password,Forgot Excel Sheet Password,Excel Sheet Password,Excel Sheet ,Password

This document will tel you how to unprotect an excel spread sheet without having the password

This procedure works in Excel 2010 and earlier but in Excel 2013 this will not work.

In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.

Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet ,Without Password,Unprotect An Excel Without Password,An Excel Without Password,Forgot Excel Sheet Password,Excel Sheet Password,Excel Sheet ,Password

Press ALT +  F11 or click on View Code in Developers Tabs

Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet ,Without Password,Unprotect An Excel Without Password,An Excel Without Password,Forgot Excel Sheet Password,Excel Sheet Password,Excel Sheet ,Password

 

In the Above White Space Enter the below Code. Do not change the code just copy paste:

 

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Now Click on the Run Button or press F5:

Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet ,Without Password,Unprotect An Excel Without Password,An Excel Without Password,Forgot Excel Sheet Password,Excel Sheet Password,Excel Sheet ,Password

 

And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.

This Message is contains the password which can be used to unprotect the other sheets in the same workbook.

On my modest PC it takes about 80 seconds to crack the password and it seems to come up with a password such as AABBAAABBB^ which isn’t the original password but nevertheless works. Spreadsheet is now unprotected. Try it for yourself.

Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet Without Password,How Unprotect An Excel Sheet ,Without Password,Unprotect An Excel Without Password,An Excel Without Password,Forgot Excel Sheet Password,Excel Sheet Password,Excel Sheet ,Password

 

(courtesy of University of Wisconsin-Green Bay)

Share

Enable Java in Google Chrome 45 : Solution for application/x-java-applet

October 11th, 2015, posted in Oracle, TEChNoLoGY, Windows
Share

Google released Chrome 45 on September 1, 2015. Unlike its predecessors, Chrome 45 does not support NPAPI plugins like Java and Silverlight. Although Chrome 42 to 44 provided the option for users to enable NPAPI plugins, the option was removed in Chrome 45. Quite simply, if you would like to know how to enable Java in Google Chrome 45 or later, you can’t — at least not directly.  But all hope is not lost!

Chrome users who encounter Java content will be greeted by a yellow notification bar at the top of the browser window that says, This site uses a plugin (Java TM)) that is unsupported. The notification also includes a link to more information about why Java is no longer supported by Chrome.

How to enable Java in Google Chrome 45

The Java content in the web page itself will display as a gray area with a puzzle piece. If you mouse over the puzzle piece, you will see This plugin is not supported.

How to enable Java in Google Chrome 45

If you right-click inside the Java content area, the right-click menu displays application/x-java-applet and an opportunity to Hide this plugin. It no longer includes the Run this pluginselection.

How to enable Java in Google Chrome 45

All in all, it is not tremendously helpful information apart from informing you of what is demonstrably obvious. A trip to the Java.com web site would seem to be in order. Perhaps they would know what to do.

How to enable Java in Google Chrome 45

Perhaps not. A notification confirms, “The Chrome browser does not support NPAPI plug-ins and therefore will not run all Java content.” For a deeper explanation, click the More info link to visit their Java and Google Chrome article.

View Java content in Chrome using the IE Tab extension

One method to view Java content in Chrome is to install the IE Tab extension. The “IE” in IE Tab is an abbreviation for Internet Explorer. Available for Chrome from the Chrome Web Store, IE Tab is used to emulate Internet Explorer within a Chrome browser window. The extension uses the Internet Explorer rendering engine so you can view Java content (as well as ActiveX and Silverlight content). It is easy to install, and even easier to use. It is important to note that IE Tab works on Windows only. Watch the Video.

Visit the IE Tab page in the Chrome Web Store. Click the blue Add To Chrome How to enable Java in Google Chrome 45 button. A dialog will display asking you if you want to Add IE Tab, accompanied by a list of functions it can perform. Click the Add extension button.

How to enable Java in Google Chrome 45

Once installed, the IE Tab icon How to enable Java in Google Chrome 45 will display next to the Chrome’s address bar. Click the icon to open an IE Tab. In the IE Tab, input the web address of the page that contains Java content. In the example below, we successfully verified our Java version, which uses a Java detection applet, using Google Chrome 45 using an IE Tab.

How to enable Java in Google Chrome 45

If you attempt the same verification process in a regular Google Chrome 45 tab, the notification that Chrome does not support NPAPI plugins displays instead.

How to enable Java in Google Chrome 45

View Java content using an alternate web browser

Alternatively, as suggested by Oracle, if you want to display Java content on your computer, you can also use an alternate web browser. The top-tier web browsers that support NPAPI plugins like Java are Firefox, Internet Explorer and Safari. Other alternate web browsers that continue to support Java are Opera and Torch. The web browsers that support Java are available for free. With at least five great web browsers from which to choose, your Java content is truly still readily accessible.

Share