Archive for the ‘Windows’ Category

Network Unauthenticated 2 Icon Showing On Network Card Limited connectivity

August 21st, 2017, posted in Windows
Share

Network disconnected automatically and showing “Network Unauthenticated” on the “Local Area Connection”

Follow below steps to get the issue resolve :
Steps: 1
  • Go To The services.msc > Right Click on “Network Location Awareness” and Open Propertiesin General tab > change Startup Type as “Automatic (Delayed Start)” and Restart the Services
  • Follow same procedures for “Network List Services” ( Dependency on above service)

Steps: 2 

  • Go To the Command Promptand type below commands & hit Enter after each and every command

netsh
winsock
reset
Once the winsock reset you Must be Restart the System

Steps: 3

  •  Try to Enable/Disabled Network Card

Steps: 4

  • Right Click on Network icon and Open Network & sharing centerclick on Change Adapter settingsRight Click on Local Area Connection and open PropertiesClick on configure button > Select Power Management Tab > and Unchecked Allow the computer to turn off this device to save power (Same for all option available in below)
  • Restart the System/Computer

Steps: 5

  • Unjoin/Remove the workstation/machine from the Domain then delete All computer account from the Active Directory and rejoin or re-welcome in Domain

Steps: 6

  • E.g. – If  the Domain name is “CYBTEST.COM” and you find the name on the Network Card is changed as CYBTEST.COM 2” then edit and change as “CYBTEST.COM” in Registry as follows.
  • Open registry editor using regedit command > click on Edit > Findtype CYBTEST.COM  2
  • Find all changed entries and edit as normal CYBTEST.COM

Steps: 7 Change the NIC Dynamic port using batch file or below command line )

  • @echo off
    color 02
    netsh int ipv4 show dynamicport tcp
    pause
    echo “Dynamic port WILL SET as starting from 1025 to num=64510”
    pause
    netsh int ipv4 set dynamicport tcp start=1025 num=64510
    pause
    netsh int ipv4 show dynamicport tcp
    pause
    shutdown -r -t 05
Share

Ways to Open the Windows Task Manager

May 17th, 2017, posted in Windows
Share

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,

Bringing up Windows Task Manager is not much of a task itself, but when a virus disables Ctrl+Alt+Del and takes it hostage, how else are you going to open task manager? Or maybe you’re just looking for some diversity in your life, so here are six different ways to open Windows Task Manager.


1) Ctrl+Alt+Del

Readers will probably be most familiar with the three-finger salute (AKA Ctrl+Alt+Del). Up until Windows Vista was released, pressing Ctrl+Alt+Del brought you directly to Windows Task Manager. Since Windows Vista, Ctrl+Alt+Del now brings you to the Windows Security screen which provides users with five different options including Windows Task Manager.

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,


2) Right-Click Taskbar

Arguably the fastest way to bring up Windows Task Manager is by right-clicking the taskbar and choosing the Start Task Manager option. It’s just two clicks and voilà! You’re staring at Task Manager in no time! Of course, you could always create an AutoHotKey script to bring up Windows Task Manager even faster with a click of a button

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,

 

3) Run taskmgr

The Run command is a great tool for accessing shared folders, but you can also use it quickly up programs such as Registry Editor or a Command Prompt. Click the Start button then the All Programs folder. Under the Accessories folder click the Run command. You can also press they Windows Key + R on your keyboard or enable the Run command in your Start Menu. Finally, simply type “taskmgr” and hit Enter.

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,taskmgr,dos command

 

4) Ctrl+Shift+Esc

Another quick keyboard shortcut to bring up Windows Task Manager is Ctrl+Shift+Esc. Besides bringing up Windows Task Manager while using Remote Desktop, you can also use Ctrl+Shift+Esc to bring up the task manager while working locally.

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,taskmgr,dos command

 

5) Browse to taskmgr.exe

This is definitely the longest way of opening the task manager, but if it’s your only option then it’s better than nothing at all. Open up Windows Explorer and navigate to C:\Windows\System32. The location of taskmgr.exe should be the same in all recent versions of Windows. Scroll down (or search) for taskmgr.exe and double click it.

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,taskmgr,dos command


6) Create taskmgr.exe Shortcut

And last on our list is creating a nice, accessible shortcut to the Task Manager on your desktop. Right-click on your desktop and choose New then click Shortcut. A new window will pop up. Browse to the same path as above, C:\Windows\System32. Scroll down until you see taskmgr.exe, highlight it, and then click OK. Click Next, type a name for your shortcut, and finally click Finish.

Ways to Open the Windows Task Manager,Open the Windows Task Manager,Ways to Open,Windows Task Manager,Windows,Task Manager,Windows 10,Windows XP,Windows 7,Windows Server 2012,taskmgr,dos command

Share

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