How to generate ER diagram using Oracle SQL developer

How to generate ER diagram using Oracle SQL developer

Tool Used : SQL Developer version 3.1.07 Schema Used : HR Tables Used : Countries, Departments, Employees, Job_History, Jobs, Locations, Regions Navigate the below path and step by step screen shots: File > Data Modeler > Import > Data Dictionary 1# Select DB Connection and click on next 2# Select Schema/DB you wish to import ... Read more How to generate ER diagram using Oracle SQL developer

Opnefire installation guide in Linux (Red Hat)

Opnefire installation guide in Linux (Red Hat)

Let me show you step by step installation guide for openfire in Red hat Linux 6.2 using Postgresql database. Make sure you have postgresql database and openfire rpm installed in your machine You can get openfire rpm package from the official site of openfire as shown below http://www.igniterealtime.org/downloads/ Installaing Pre-requisites Install the following packages for ... Read more Opnefire installation guide in Linux (Red Hat)

Fix "The TCP/IP connection to the host 127.0.0.1 , port 1433 has failed"

Fix "The TCP/IP connection to the host  127.0.0.1 , port 1433 has failed"

I was facing this error while trying to connect to my existing database during the upgrade of my vCenter Server from 5.0 to 5.1. So while trying to connect to my existing database during the installation of vCenter SSO every time it was throwing out this particular error. Error: The TCP/IP connection to the host ... Read more Fix "The TCP/IP connection to the host 127.0.0.1 , port 1433 has failed"

Oracle database 11gR2 installation in RedHat 6.2 (32-bit)

Oracle database 11gR2 installation in RedHat 6.2 (32-bit)

In my earlier post I showed you the steps to install Oracle database 10gR2 installation in RedHat 5.4 (64-bit). Now in this post I will guide with the steps and the pre-requisites required for the installation of Oracle 11gR2 in Red Hat 6.2 (32-bit) Pre-requisites before installing database   GUI Environment Make sure you have ... Read more Oracle database 11gR2 installation in RedHat 6.2 (32-bit)

Oracle database 10gR2 installation in RedHat 5.4

Oracle database 10gR2 installation in RedHat 5.4

In this post I'll show you the steps required to install Oracle Database 10g Release 2 on Red Hat Enterprise Linux 5.4 (64-bit) Assuming you have downloaded Oracle Database 10g R2 from their official website. If not you can get it from the below mentioned link Oracle Database 10g R2 for Linux 64-bit For my ... Read more Oracle database 10gR2 installation in RedHat 5.4