How to delete Listener with Oracle

If you want to delete listener then just follow below steps and complete your task  very easily.

1. Window+R and "netca" and press enter. A configuration window will apear,

2. Select "Listener Configuration" and click next

3. Select delete and click next.

4. Click Next

5. A warning message will appear at your screen,

6. Click on "YES"

7. It will start deletion and new screen will appear "LISTENER WAS DELETED" and then click next

8. Click next and new window will apear with that message "Listener configuration complete" now click next.

9. Click on Finish button,

Cheer's

BI Unable to connect to port 9705 on machine error [nQSError: 12008]

How to resolve [nQSError: 12008] Unable to connect to port 9705 on machine with OBIEE

Whenever facing following error;

Oracle BI Scheduler Error: [nQSError: 12008] Unable to connect to port 9705 on machine test-pc. [nQSError: 12010] Communication error connecting to remote end.

Point:  address = test-pc; port = 9705. [nQSError: 12002] Socket communication error at call=: (Number=-1)

Go to services and make sure the Oracle BI Scheduler Service is up and running.

localhost does not work

Question: localhost does not work but website can be viewed both internally and externally.

Answer:

If you bind website with localhost then it will browse.

If you bind website with another static IP then website will browse with its static IP but not with localhost.

If you want to browse website via localhost then follow below steps;

• Open IIS
• Right click on website
• Then click on Edit Bindings
• Assign localhost or IP: 127.0.0.1
• Click ok and close window
• Now browse your website.

How to Create /Drop /DB link in oracle

Two way to create DB link in oracle Database

1. With TNS entry in tnsnames.ora

2. TNS entry given at the time of db link creation.

Create DB link

1st method: Create DBLINK with TNS entry name made in tnsnames.ora

Put a TNS in tnsnames.ora file with name like “TEST”

CREATE PUBLIC DATABASE LINK 'TEST'

 CONNECT TO 'USER Name'

 IDENTIFIED BY 'Password'

 USING 'TEST'

TNS entry like;

TEST=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=hostname)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SERVER=dedicated)

      (SERVICE_NAME=test)

    )

  )

2^nd method with full TNS

CREATE PUBLIC DATABASE LINK “TEST”

 CONNECT TO “USER Name”

 IDENTIFIED BY “Password”

 USING TEST=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=hostname)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SERVER=dedicated)

      (SERVICE_NAME=test)

    )

  )

DROP DBLINK:

DROP PUBLIC DATABASE LINK ‘TEST’

What is DNS

Domain Name Service (D.N.S)

The DNS (Domain Name Service) is a standard technology for managing the names of Websites and other Internet domains. DNS technology allows you to type names into your Web browser like (solutions-ever.blogspot.com) and your computer to automatically resolve that address on the Internet. A key element of the DNS is a worldwide collection of DNS servers.

DNS server is any computer registered to join the Domain Name System. A DNS server runs special purpose networking features public IP addresses and contains a database of network names and addresses for other Internet hosts.

DNS Root Server

DNS servers communicate with each other using private network protocols. All DNS servers are organized in a hierarchy. At the top level of the hierarchy, so-called root servers store the complete database of Internet domain names and their corresponding IP addresses.

DNS Hierarchy

The DNS is a distributed system, meaning that only the 13 root servers contain the complete database of domain names and IP addresses. All other DNS servers are installed at lower levels of the hierarchy and maintain only certain pieces of the overall database.

Lower level DNS servers are owned by businesses or ISP’s. For example, yahoo maintains various DNS servers around the world that manage the yahoo.com, and other domains. Your ISP also maintains DNS servers as part of your Internet connection setup.

DNS networking is based on the Client/Server architecture. Your Web browser functions as a DNS client and issues requests to your Internet provider's DNS servers when navigating between Web sites.

When a DNS server receives a request not in its database, it temporarily transforms from a server to a DNS client. The server automatically passes that request to another DNS server or up to the next higher level in the DNS hierarchy as needed. Eventually the request arrives at a server that has the matching name and IP address in its database and the response flows back through the chain of DNS servers to your client.

Hyper v Technology

What is hyper v Technology?

Virtualization technology have become a part of our life. In this article, I’m going to give a detailed explanation virtualization. I will take a look at Microsoft Hyper-V technology and examine it by performing the initial steps of configuration Installation and virtual machine deployment.

What is Virtualization?

Virtualization is the creation of a virtual version of an IT environment, including an operating system, a storage device. Hyper-v is a best tool for virtualization.

What is Microsoft Hyper-v?

Microsoft introduced Hyper-V as a virtualization platform in 2008, and it continued to release new Hyper-V versions with new Windows server versions, including Windows Server 2012 R2, Server 2012, Server 2008 R2 and Windows Server 2008.

How to install and configure Hyper-v?

Very simple and the same as any typical program installation. Check and see which Windows version you have. If it’s Windows Server OS you should activate the Hyper-V role through the Server Manager, and then perform the installation. Once the installation is complete, the computer will reboot. After it has rebooted, you will notice additional services have been installed, including Hyper-V Manager.

Next Hyper-V Manager to find out what you can do with this installation.

All Hyper-v management can control from Hyper-v Manager.

Since Hyper-V role is also integrated into the Server Manager tool, you can find some useful information there, services related to Hyper-V and see recommended configurations, tasks, best practices, and online resources.

With Hyper-V Manager, anyone can create, change and delete VM machines; tune virtual networking and perform additional dependent operations.

Right-click the server node in the main window, point to New, and select Virtual Machine. You will then see the new Virtual Machine starting.

You must then enter a name for the virtual machine, find a place to store it and specify the amount of memory to allocate.

Next you will select a network adapter for VM use, create a virtual hard disk (every VM needs a disk HDD) and then define how you are going to install an operating system to VM. You should then click Finish and your VM will be created.

To check if the VM is working, right-click on the name of the virtual machine and then click Connect, once the VM is initialized, the operating system installation should start automatically.

Now you can install VMs and can manage here.

How to Kill All Tasks of Specific User in Terminal Server

Open CMD

Execute Command in MS DOS:

taskkill /F /FI "USERNAME eq XYZ"

Comment: "XYZ" will be the Username of which all tasks needs to be killed!

Enjoy with tricks

How to create application pool in IIS through batch file.

Run notepad and type following commands

cd %windir%\system32\inetsrv

appcmd add apppool /name:Pool_Name1 /managedRuntimeVersion:v4.0 /managedPipelineMode:Classic

appcmd set apppool /apppool.name:Pool_Name1 /processModel.identityType:NetworkService

appcmd set apppool /apppool.name:Pool_Name1 /enable32BitAppOnWin64:True

Save notepad file as batch file like (Pool.bat) in C: drive at any location. Run this batch file on server where you want to create application pool

Note:

Define the attributes as per the requirements.

For example:

• If you are using framework 4 then put following value (managedRuntimeVersion:v4.0) and if you want to use framework 2 then put following value (managedRuntimeVersion:v2.0) in batch file.
• If you want to use identityType (NetworkService) then put (processModel.identityType:NetworkService) and if you want to use any other user you can change the value like this (processModel.identityType:administrator)

Now open IIS and see you will find your application pool there. enjoy with little bit practice.

How to create oracle listener

Press window+R and type “NETCA” and press enter

Oracle Net Configuration Assistant Welcome window will be opened

Select “Listener Configuration” and click next

Select “Add” and click next, and at this window you can manage already exist Listener.

Type here Listener name as you want. If not then remain as default like “LISTENER” and click next

At this window select Available protocol like “TCP” and click next

Oracle Listener use 1521 standard port to communicate with networks and applications. If you want to use standard port (1521) then click next otherwise you can change another port here. And click next

At this point select option “No” and click next

Listener configuration complete window will open and then click next

And click finish.

How to install Oracle Client 10g

Please follow the below mentioned steps to install Oracle Client Version 10g

Run the Setup application

Oracle Universal Installer initial window will be opened

 Setup will install. Please click Next from Oracle Universal  Installer window

Check the option Custom  from Select installation type window

After selecting the option click” Next”

Specify the  Following Name and path as mentioned below and click Next

Name: OraClient10g_home1

Path : D:\oracle\product\10.2.0\client_1

Check all the components from Available Product Components window and click Next

Click Next if you see the message “Passed (Shows that  your system meets the prrequisites for installation)

Enter the port number “2030” and click “Next”

Installer will show Summary , Click “Next” to proceed further

Installation Process will continue

Oracle Net Configuration will start

Please check the box “Perform typical configuration “and click “ Next”

Click exit to end to close the installation window

**********END**********

Microsoft Windows update KB2670838 issues

Errors

1. Not enough server storage is available to process this command
2. Parameter is not valid
3. Out of memory
4. Red X line

Cause: 

Due to Microsoft window update KB2670838 installed on your system.

Resolution:

Follow the below mentioned steps:                                     

1.      Click “Start”

2.      Run “Windows Update” from “Start Menu>All Programs

3.   Go to “Installed Updates”

4.      In Search Box type “internet explorer”

If you find Windows Internet Explorer 10 after search, click uninstall.

5.                     Go back to installed updates again.

1.                  In Search Box type “KB2670838”

2.                       Select the update “Update for Microsoft Windows (KB2670838)”

3.                       Click “Uninstall” and then Yes 

4.                     Go back to installed updates again.

5.                     In Search Box type “Kb2709981”, this update should be installed.

6.                     If not check in “ Optional Windows Update Available”

Select the Update kb2709981 from optional updates and click “ok”

After selecting this update click install updates

After update installation Open Window update options and

Select the option Never Check for Updates from drop down .

Now enjoy without windows buggy updates :P 

How to send Email using CMD

Sending email with telnet can be very easy if you know how to do it.

Send email with 9 easy steps,

1.       Open command prompt.

2.       Type” telnet mail.server.com 25” and press enter, where mail.server.com is the name of smtp server and 25 is the port of smtp server.

3.       Type “HELO mail.server.com” and press enter, you should receive a reply like this: “250 mail.server.com 250 OK”

4.       Type” MAIL FROM: example@example.com press enter

5.       Type” RCPT TO: friend@friend.com” and press enter

6.       Type” DATA” and press enter

7.       In next row type” SUBJECT: (your subject here) and press enter

And continue type your message like this:

Hi, Saeed

Sample text

Regards,

Admin

8.       To end your message put a single (.) on a line by itself and press enter

You should see something saying “Message accepted for delivery”

9.       Type” QUIT” to exit and press enter

Screen Shot Attached. with all steps:

How to uninstall oracle completely.

How to uninstall oracle completely. 

1.       Uninstall all Oracle components using the Oracle Universal Installer (OUI), click on remove button.

2.       If your OS is 32 bit then follow this Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entries for all Oracle products.
3.       If your OS is 64 bit then follow this Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ Wow6432Node/ORACLE key. This contains registry entries for all Oracle products.
4.       Delete any references to Oracle services left behind in the following part of the registry:
5.       HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*
6.       Reboot your machine.
7.       Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_HOME.
8.       Delete the "C:\Program Files\Oracle" directory.
9.       Empty the contents of your "c:\temp" directory.
10.   Empty your recycle bin.

At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.

Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.