Recent Comments

Archives

Categories

Where can you find Enterprise Manager (EM) Database Control URL / Link. In-order to open Oracle EM you need the correct URL.

You can find the correct link by opening the read-me file in the oracle home folder

For example: ORACLE_HOME/install/readme.txt

Just search readme.txt file in the folder where oracle is installed or browse manually to the folder where oracle is installed. For example, I installed oracle in C:/app/Anish(your computer name)/product/11.2.0/dbhome_1/install/readme.txt

When you open the readme file you will find the correct link. Check the below screenshot

Installing Oracle Database 10g Release 2 on Linux

Installing oracle 10G on windows in very simple. By following the prompts correctly you can install Oracle on Windows with ease as there are no prerequisite actions before installation. But same is not the case in Linux as you need to follow some prerequisite actions as well. Assumptions: You have already downloaded CentOS from www.centos.org and you also have VMware 1.0.4. In this tutorial, I will guide you to install oracle database on CentOS. This whole installation would be done on VMware 1.0.4 hence make sure you have downloaded VMware on your computer as well

Installing CentOS on VMware – Step by Step Instructions

Go to File –> New –> Virtual Machine

Click on Next

Select Custom and Click Next

Select Linux and Choose ‘RED HAT LINUX’ as the version

Type in the Virtual Machine Name and select the location of the Virtual Machine.– Click Next

Leave the box unticked if you want this installation to work on other computers that have VMware installed on it and click Next

Click Next

Select the number of processors as per your requirement and proceed

Set the Memory for the Virtual Machine – Note: Oracle 10g requires at least 1 GB of RAM

Select the Network type as per your choice and click next

Choose LSI Logic as the SCSI Adapter –> Next

Choose ” Create a New Virtual Network” and click Next

Under Virtual Disk Type select IDE –> Next

Enter disk size as per your choice but don’t tick on allocate all disk space now as this option will reserve the selected space even if its not used. Hence its always recommended to leave it unticked unless you have a lots of free space

Click Next and Finish

Now Click on Edit Virtual Machine Settings, Click on CD- ROM —> Select use ISO Image (Browse and specify the location of the CentOS ISO file) –> Then press OK

Now its time to start the Virtual Machine

Hit the Enter Key to install CentOS in graphical mode

Now you need to click on SKIP

Press Next

Select your preferred language and then click next

Click on Yes and proceed

Don’t make any changes, just click next again

Now it will give you a message ” You have chosen to remove all linux partitions on the following drives: Are you sure you want to do this” just click on YES

You may now have to configure IP address, just select “Automatically via DHCP” or You can also configure IP address manually

Now select your location and press next

Enter the root password and confirm it by retyping it and then click next

Now you need to select customize now and then next

Select Desktop Environments and choose GNOME Desktop Environments

Go to Applications and then choose Graphical Internet and leave all other options as it is

Go to Development and then choose GNOME Software Development, Java Development, X Software Development, Development Tools, Development Libraries and Legacy Software Development

Finally go to Base System and choose Base, Java, Legacy Software Support, System Tools, X Window System and Administration Tools and then click Next

Click Next again and Reboot

After its rebooted ,click the forward button

Change the Firewall state to Disabled and click forward

Disable SELinux too and click forward

Don’t make any changes on the next screen (Keep the Kdump disabled) and click Next

Set the date and time and click forward

Create a new user by filling the details (you can also skip this step)

Click Forward and then click Finish. Now click ok so that the system would reboot

Once restarted, it will ask you to enter username and password, hence enter the correct details

Once logged in you would see the below screen

This is the end of PART 1 . In my next post I will cover Installing RPM packages which are required for Oracle Installation , Configuring Kernel Parameters, creating groups and users for Oracle Installation etc. Till then stay tuned

In the previous post we learned to create a table in oracle. Today lets insert data into the table we created. Below is the format of the table we created. first_name, last_name, sex and age are the columns in our table.

So to insert data into these columns type :

insert into team values(‘Anish’,’Sangamam’,’male’,23);

Here team is the table name. Similarly, insert into team values(‘anish’, ‘last’, ’20’, 10);

Insert Values into the Table at Run-time

Inorder to insert values at run time you need to add the amperand sign before the column names and instead of putting in the values you simply type ampersand followed by the column name.

Insert into team values(‘&first_name’,’&last_name’,’&sex’,’&age’);

When you run the query it will ask you for the firstname, lastname,sex and age.

Today, I would like to share what I have learned while studying oracle. I’m not going by the books right now as in the books you would learn on how to fetch data from the data base using the select statement but I’m starting of with creating a table.

Before we start, you need to have knowledge about the commonly used data types. They are char, varchar, number and date. To get more information on data types and their size read Oracle Data Types.