IT Solutions

Cloud Domain Controller for Branch office

noreply@blogger.com (Anonymous) — Thu, 04 Sep 2014 18:00:00 +0000

Plan for Cloud Domain Controller.

Setup Remote Domain Controller via Direct access

Following Ports need to be opened in Firewall or Router on both side.

NAT Local IP of Domain Controller to Public IP or Internet IP
A domain name will be register on godaddy.com or register.com or etc
Additional Domain Controller will be setup in branch office and both Server will replicate to each other
UDP Port 88 for Kerberos authentication
TCP Port 135 for domain controllers-to-domain controller and client to domain controller operations.
TCP Port 139 and UDP 138 for File Replication Service between domain controllers.
UDP Port 389 for LDAP to handle normal queries from client computers to the domain controllers.
TCP Port 445 for File Replication Service
TCP Port 464 for Kerberos Password Change
TCP Port 3268 and 3269 for Global Catalog from client to domain controller.
TCP Port 53 for DNS from client to domain controller and domain controller to domain controller.

Opening above ports in Firewall between client computers and domain controllers, or between domain controllers, will enable Active Directory to function properly.

Setup Remote Domain Controller via VPN.

A best solution to secure your domain traffic is Site-to-Site VPN.

On both side site-to-site vpn will create
No need to purchase or register a domain name from godaddy or register.com etc.
If a firewall installed in Cloud then need to allow ports in firewall to communicate Domain Server and Client machines.
UDP Port 88 for Kerberos authentication
TCP Port 135 for domain controllers-to-domain controller and client to domain controller operations.
TCP Port 139 and UDP 138 for File Replication Service between domain controllers.
UDP Port 389 for LDAP to handle normal queries from client computers to the domain controllers.
TCP Port 445 for File Replication Service
TCP Port 464 for Kerberos Password Change
TCP Port 3268 and 3269 for Global Catalog from client to domain controller.
TCP Port 53 for DNS from client to domain controller and domain controller to domain controller.

How to create CMAN listener

noreply@blogger.com (Anonymous) — Fri, 11 Jul 2014 17:13:00 +0000

Installation & Configuration of Connection Manager (CMAN) Oracle 10g

Just follow below steps and make your life easier.

Click start menu ===> Oracle-OraDb10g_home1 ===> click on Universal Installer

1. Run universal installer from installed oracle_home.

2. Click on Button “Next”.

3. Specify Setup files location and Click on Button “Next”.

4. Select option “Custom” and Click on Button “Next”.

5. Select installed DB oracle home and Click on Button “Next”.

6. Check both these boxes to be user verified and Click on Button “Next”.

7. Check “Oracle Connection Manager” and Uncheck “Oracle Services for Microsoft Transaction Server”. Click on Button “Next”.

8. Click on Button “Install”.

9. Click on Button “Exit”.

10. Copy this CMAN.ORA file from path “D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\SAMPLE” This file will auto creates just after CMAN installation. Make changes that are in red color and give following values.

cman <alias>

local IP of Database<192.168.1.54>

listener port <1620>

11.Open CMD and type follwing commands,

cmctl
administrator cman
startup

12. Change “Startup Type” of these services to Automatic.

How to delete Listener with Oracle

noreply@blogger.com (Anonymous) — Fri, 27 Jun 2014 15:23:00 +0000

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]

noreply@blogger.com (Anonymous) — Wed, 25 Jun 2014 17:12:00 +0000

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

noreply@blogger.com (Anonymous) — Wed, 18 Jun 2014 13:58:00 +0000

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

noreply@blogger.com (Anonymous) — Wed, 18 Jun 2014 13:03:00 +0000

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

noreply@blogger.com (Anonymous) — Mon, 16 Jun 2014 14:02:00 +0000

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

noreply@blogger.com (Anonymous) — Thu, 12 Jun 2014 15:32:00 +0000

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

noreply@blogger.com (Anonymous) — Tue, 10 Jun 2014 16:03:00 +0000

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.

noreply@blogger.com (Anonymous) — Tue, 10 Jun 2014 15:36:00 +0000

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

noreply@blogger.com (Anonymous) — Tue, 10 Jun 2014 13:17:00 +0000

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

noreply@blogger.com (Anonymous) — Wed, 04 Jun 2014 18:37:00 +0000

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

noreply@blogger.com (Anonymous) — Wed, 04 Jun 2014 17:58:00 +0000

Errors

Not enough server storage is available to process this command
Parameter is not valid
Out of memory
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

noreply@blogger.com (Anonymous) — Tue, 03 Jun 2014 11:37:00 +0000

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.

noreply@blogger.com (Anonymous) — Mon, 02 Jun 2014 11:09:00 +0000

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.

How to solve ora-06413

noreply@blogger.com (Anonymous) — Thu, 29 May 2014 15:07:00 +0000

Unable to open oracle connection (ora-06413)

Cause:

The problem scenario: some time oracle 10g could not open connection with applications like Microsoft Access, Visual Studio, and ODBC connections etc. Those applications are installed in C:\Program Files (x86). And cause is that oracle do not make connection with such these applications due to parentheses.

Solution:

Here's the real trick to making this all work; Set up a symlink to the c:\Program Files (x86) folder without the parentheses.

Open Command Prompt and "Run as administrator" At the command prompt, enter the following command;

mklink /D "C:\Program Files x86" "C:\Program Files (x86)”

Now to onwards run applications from C:\Program Files x86.

ORACLE user create

noreply@blogger.com (Anonymous) — Thu, 29 May 2014 15:00:00 +0000

How to create user in oracle;

CREATE USER TEST IDENTIFIED BY TEST;

DEFAULT TABLESPACE USERS;

TEMPORARY TABLESPACE TEMP;

PROFILE DEFAULT;

ACCOUNT UNLOCK;

How to grant access to user;

-----Role for USER----

GRANT DBA TO TEST;

ALTER USER TEST DEFAULT ROLE ALL;

-------System Privilege for USER------

GRANT UNLIMITED TABLESPACE TO TEST;

How to install IIS 8.5 Server 2012 R2

noreply@blogger.com (Anonymous) — Wed, 28 May 2014 18:50:00 +0000

Install IIS 8.5 in the Server 2012 R2

When the Web Server (UI) role is chosen for the first time in the Add Roles and Features Wizard in Server Manager, the basic components and services needed for IIS are automatically selected. The following procedure will install Internet Information Services on a running physical server when IIS has not already been installed. Open Server Manager by clicking the Server Manager icon on the desktop.

In the Server Manager window, with the Dashboard and Quick Start selected, click Add roles and features, or click the Manage menu, and then click Add Roles and Features. The Add Roles and Features Wizard will start with a Before You Begin page.
On the Before You Begin page, click Next.
On the Installation Type page, select Role-based or feature-based installation to configure a single server. Click Next.

On the Server Selection page, select Select a server from the server pool, and then select a server; or select Select a virtual hard disk server, select a server to mount the VHD on, and then select a VHD file. Click Next.

On the Server Roles page, select Web Server (IIS).

In the Add Roles and Features wizard, click Add Features if you want to install the IIS Management Console.

On the Server Roles page, click Next.
On the Features page, select any features that you would like to install, and then click Next. Note that you do not need to select any features on this page to install IIS. IIS setup will select the features that are required.

On the Web Server Role (IIS) page, click Next.
On the Role Services page, select any additional role services that you want to install.

If you selected a role service that requires other role services or features to be installed, a page will be opened indicating the role services or features to be installed. Leave Include management tools (if applicable) selected to select the install management tools associated with the server role. You may not need the management tools on the destination server if you plan to manage the role remotely. Click Add Features to add the required role services or features.
After you have added the role services that you need on the Role Services page, click Next.
On the Confirmation page, verify the role services and features that are selected. Select Restart the destination server automatically if required to restart the destination server if the settings need to take immediate effect. To save the configuration information to an XML-based file that you can use for unattended installations with Windows PowerShell, select Export configuration settings, move to the appropriate path in the Save As dialog box, enter a file name, and then click Save.

When you are ready to start the installation process on the Confirmation page, click Install.

The Installation Progress page is displayed. You can close the wizard without interrupting running tasks. You can view task progress or open the page again by clicking Notifications in the notification area, and then clicking Task Details.

On the Results page, verify that the installation succeeds, and then click Close.

IIS installation completed.

How to Migrate Virtual machine from VMWare to Hyper-V

noreply@blogger.com (Anonymous) — Wed, 28 May 2014 17:27:00 +0000

Please follow below steps;

Step 1: Shut down the VM

This is important – most developers that I know simply suspend their VMs when they shut down or reboot the host machine. You need to Shut down the virtual machine in VMWare Workstation before you begin the conversion.

Step 2: Convert virtual hard disk from VMDK to VHD

The main part of the process is to convert the virtual hard disk format from VMDK to VHD. There’s a variety of conversion tools available for this task – I picked the WinImage utility since, ironically, I’ve used it in the past to convert VHD images to VMDK and found it to be very reliable.
If your VMDK virtual hard disk consists of multiple files, I recommend that you execute the following command to generate a single VMDK image:

Then use below method to convert in single disk.

Step 3: Consolidating Multiple VMware VMDK Disk Files into One

In command prompt, navigate to where you have VMWare installed. For me it was
C:\Program Files (x86)\VMware\VMware Workstation
In that folder you can use the vmware-vdiskmanager.exe program to perform this operation
vmware-vdiskmanager -r MyVirtualMachineDisk.vmdk -t 0 SingleDiskFile.vmdk
Replace MyVirtualMachineDisk.vmdk with the full path and file name of the first file of your split VMware disk set.

The “-t 0” means to turn it into a “single growable virtual disk“. If you would rather pre-allocate all the storage for the disk, use “-t 2” instead, which means “preallocated virtual disk.”
You can view more command line options by running the vmware-vdiskmanager.exe with no parameters.

DownLoad WinImage Utility

http://www.winimage.com/download.htm

Download, install and start WinImage
In the Disk menu, select Convert Virtual Hard Disk Image…
In the Open file dialog, select VMWare VMDK (*.vmdk) as the file type and browse to your current VM location, select the file and press Open
In the Convert Virtual Hard Disk Image dialog, pick Create Fixed Size Virtual Hard Disk Size to make your new VHD fixed-size or pick Create Dynamically Expanding Virtual Hard Disk to make it dynamic. I prefer the dynamically expanding option.
In the Save As file dialog, browse to the location you’d like to save the VHD image and type in the File name and make sure the Save as type is set to Virtual Hard Disks (*.vhd), then press Save.

Step 4: Configure Hyper-V networking

If this is the first virtual machine on this Hyper-V host and you haven’t configured networking yet, follow the steps below to create a new virtual network:

Start the Hyper-V Manager
In the Action menu, select Virtual Switch Manager…
Select External and press Create Virtual Switch
Type in the Name, make sure that External network option is selected and pick the network card that provides Internet access in the dropdown, then press OK
Press Yes on the Apply Networking Changes dialog

Step 5: Create a new virtual machine in the Hyper-V Manager

You are now ready to create a new Hyper-V virtual machine using the VHD image created earlier in Step 1.

Open the Hyper-V Manager
In the Action menu, select New > Virtual Machine… to launch the New Virtual Machine Wizard
On the Before You Begin screen press Next
On the Specify Name and Location screen type in the virtual machine Name and select the Location, then press Next
On the Assign Memory screen enter the amount of Startup memory, then press Next
On the Configure Networking screen select the External virtual network created earlier in Step 3, then press Next
On the Connect Virtual Hard Disk screen select the Use an existing virtual hard disk option and browse to the location of the VHD created in Step 1
On the Summary screen press Finish
Select the newly created virtual machine in the Virtual Machines section, then bring up the Action > Settings… dialog for the VM
Select the Processor node and increase the Number of virtual processors to the desired value, then press OK
Make sure the VM is still selected in the Virtual Machines section, then use the Action > Start menu option to start the virtual machine
In the Action menu, select Connect… to bring up the Virtual Machine Connection window
Login to the VM
Make sure that remote connections are allowed by going to Control Panel > Remote settings and making sure that one of the Allow connections options is selected

Enjoy :)

Saeed