Skip to main content

Installing Oracle 10g Database


Once you have downloaded the software from www.oracle.com/downloads, following steps can be used to install the software.

1. Unzip the dump downloaded from oracle.com




2. Once Unzipped, click on setup.exe to run Oracle Universal Installer Program. This will open a window as shown below.




3. After few seconds, this will open up Oracle Universal Installer screen.


4. Enter the password as desired and click next. If required you can change the database name, by default its 'orcl'.



Installer performs few tests checking the system stability, just have to wait till then.











5. Check the report, it says failed. Looking at it closely since the system on which the database was installed was not on network. This is not mandatory. You can click and proceed further.



6. Once the checks are done click next which will take you to summary screen, you can browse through the products which will be installed along with your database. Check for SQL*Plus client.



7. After Review, click on install to install the database along with the products listed in the summary page.


8. Sit back and relax till the time dabase gets installed. Following screen changes occur during the installation process.





9. Once the Installation is complete, it gives some basic information about the database installed and the URL for EM -- Enterprise Manager. Click OK to proceed to next screen.







10. If you reach this screen then it means that you have been successfull in installing the database. Just Click on exit and start using your database.

To open SQL Plus use the following Navigation,

Go to  --> Start --> Programs --> Oracle - OraDb10g_home2 --> Application Development --> SQL Plus

11. First time you try to login as scott/tiger, it would throw an error as shown below,


To get rid of this error, login as SYSTEM for password use the password that was speficied during step3 of this installation process.

Once logged in, use the sql statement below to unlock scott user.

Once this is done, login as scott tiger and it should work. It might as to change the old password with a new one, In this case use "tiger" as old password.

Comments

Monalisa Singh said…
This comment has been removed by the author.
Rajani kanth said…
hi sir what is metadata. metadata and data are same or different...
Anonymous said…
Metadata can simply be defined as data for a data.
Anonymous said…
Hello Sir the protocol that will be used during pinging from client to server is point-point protocol.
Anonymous said…
Done with the installation of 10G, video waso helpful.
I didn't encounter any errors :)
Mine is Windows 7 Ultimate.

Why should we run it with compatibility mode for Xp, Why not Win 7.
Thanks.
Anonymous said…
Now waiting for queries to be taught in class.
Query retrieval etc..
Namrata Yadav said…
I am unable to use SQL* Plus. Error is thrown as table or view or object does not exist while executing a simple sql statement as desc emp; Please help me out to resolve this query - Namrata BCE 2 batch Qspiders
fancy said…
Rahul:i installed oracle software and wen it asked for password n user name i gave scott and tiger but window jst disappeared.. den i again went to programs and right clicked on sql plus and gave run as admin.. den again gave same username n password but after window appeared but was nt responding
fancy said…
Rahul:software is working fine.. i had skipped to change compatibility mode... video was helpful thanx mithun sir
Mithun Ashok said…
Hi Rajani Kanth,

Yes even metadata is data, but this data is not user data. Metadata is databases data.

Regards,
Mithun
Mithun Ashok said…
Hi Anonymous,

You should run it in compatible mode set to XP because on some versions of Win 7 has issues with installation.

Regards,
Mithun
Mithun Ashok said…
Namratha,

You should login as user SCOTT only then you will be able to see table emp.

Regards,
Mithun
Anonymous said…
I had disabled oracle services and had kept it in manual mode.After manually starting the services, i started using oracle SQL * Plus, but in the user name & password prompt i typed Scott & tiger respectively, but its saying invalid username & password, why is that so, this was not throwing error when oracle services used to load automatically.
Mithun Ashok said…
Hi Anonymous,

You must have entered the password wrong. I would suggest you try to login again. Between scott user does not exist in Express Edition.

Regards,
Mithun
Anonymous said…
No i had installed the Enterprise edition.
After i was manually starting the service of Oracle, i am facing this problem.
I entered the correct password instead its throwing error of Account locked.
aDDEr said…
Hello sir,
thIS IS rAVI rAnJAN,It's really very helpful for beginer.thnks a lot for helping me out.
Mithun Ashok said…
Youre Welcome Ravi. :)
Anonymous said…
hello how to resolve error while logingim getng fatal error
sindhiya said…
Hi sir,
This is sindhiya currently attending your SQL classes, i had installed oracle 10g in my PC but i couldn't use SQL*plus after entering username&password the window disappears.. my OS is windows vista.. pls tel me the process..
Avinash KB said…
Hi Mithun, I installed Oracle 10g in Windows 7. For the first time, scott and tiger accepted and i worked for a while. i logged out. For the 2nd time wen i tried to login with scott and tiger, its not working :-( Window is getting disappeared after entering 3 times. What to do??????
Mithun Ashok said…
Hi Anonymous,

Can you pls send a screenshot of fatal error to my mail id.

Regards,
Mithun
Mithun Ashok said…
Hi Sindhiya,

Right click on sql*plus and click on Run As administrator.

Regards,
Mithun
Sindhiya said…
Hi.....Mithun Sir.......ThanKs for your quick response.....It is working now..I got it...
sreedevi said…
Hi sir,
I installed oracle 10g successfully.. video was so helpful.. thanq..
sreedevi said…
Hi sir,
I installed oracle 10g successfully.. video was so helpful.. thanq..
Anonymous said…
Hi sir,
I tried this query..
select sal,lpad(sal,5,'*'),rpad(sal,5,'*'),trim('*' from lpad(sal,5,'*')),trim('*' from rpad(sal,5,'*')) from emp;
the o/p is..
SAL LPAD( RPAD( TRIM( TRIM(
---------- ----- ----- ----- -----
800 **800 800** 800 800
1600 *1600 1600* 1600 1600
1250 *1250 1250* 1250 1250
2975 *2975 2975* 2975 2975
1250 *1250 1250* 1250 1250
2850 *2850 2850* 2850 2850
2450 *2450 2450* 2450 2450
3000 *3000 3000* 3000 3000
5000 *5000 5000* 5000 5000
1500 *1500 1500* 1500 1500
1100 *1100 1100* 1100 1100

SAL LPAD( RPAD( TRIM( TRIM(
---------- ----- ----- ----- -----
950 **950 950** 950 950
3000 *3000 3000* 3000 3000
1300 *1300 1300* 1300 1300
i found there is no difference in the alignment of triming lpad & rpad..
could you explain me why?
Mithun Ashok said…
Hi Anonymous,

This is because you are just using 5 character length to display the numbers, try using 10 instead of 5 and you will see the difference.

Regards,
Mithun
savita said…
hello sir,after installation home2 is not displaying so in this case can i work with home1 in oracle, or i've done wrong installation.
Mithun Ashok said…
Hi Savitha,

Yes you can work with home1 no problem.

Regards,
Mithun
baba said…
can u tell me the difference between subquery and joins
baba said…
tell me difference between join and subquery
sha said…
Hi
I wanted to share with you guys.

I was installing orcale 10 g windows 64bit, (Enterprise/Standard Edition for Microsoft Windows (x64)), If you guys have downloaded the above version by mistake instead of "Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows". And you have windows 7 64bit os, you will face problem when you try to click on run "checking operating system version: must be 5.1 or 5.2. Actual 6.1 Failed <<<<"
Nothing to worry, You need to edit the file oraparam after extracting, path is Database--->Install---> then oraparam.ini search for the string CERTIFIED_VERSION_FAILURE_MESSAGE
below that replace 5.1,5.2 with 5.0,5.1,5.2,6.0,6.1,7.0 and your done installation will proceed without any problem

IF your still not clear below is the video
http://www.youtube.com/watch?v=IFkr2VRUQU0
sha said…
This comment has been removed by the author.
pavithra hm said…
Hi sir, i have installed db in my system but when logged in ,its showing tns:protocol adapter error.
Please tel me on how to rectify that.
Thanks in advance.
Rvkshetty said…
Hi Mithun can u tell me hw to log into online sql database n work(w/o installing it or downloading)?
plz
Satyadev001 said…
Hi, I just installed Oracle 10g as per your video. It was successful. Can able to connect everything from oracle-appdev-sqlplus. Then I installed Toad 9.5 version , installation is successful but couldn't able to connect to any users. Please find below the error it thrown Toad ORA-12154:TNS:COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED (ORCL)
Note: still able to connect to oracle using sqlplus.
Ravi Saxena64 said…
sir can you send me link of download of oracle 10g setup
on my email id-ravi.saxena64@gmail.com
do the needful sir.

Thanks
SREE said…
Hi sir, i have installed db in my system but when logged in ,its showing tns:protocol adapter error.
Please tel me on how to rectify that.
Thanks in advance.
SREE said…
Hi sir, i have installed db 10g in my system w7 but when logged in ,its showing tns:protocol adapter error.and also showing host string
i dont know how to proceed
please rply me
i have to do your assignment if not means
i have to ran some where please*1000....! help me
Please tel me on how to rectify that.
Thanks in advance.
Mithun Ashok said…
Sree,

This means database has not been started. Go to services.msc from Start -> RUN. See if you database in started state. If not then start the database.
prasann gurav said…
while installing im getng this error msg sir. what to do???
prasann gurav said…
sir im getng dis error now...
prasann gurav said…
sir im getng dis erroe now
prasann gurav said…
sir im getnd dis error now
santosh said…
Hi sir, i am facing an problem in one of my server.. these are the screen shots of it.. please help me out.. i have got huge amount of data on it.. i am not able to login to mysql or i am not able to take an dump... it always gives an error as "mysql server is gone away, trying to reconnect"
santosh said…
please check this up sir...
Deepthi said…
hello sir,
I am Deepthi from q spider.I installed oracle 11g database in w7,by following steps in Google .After that i don't know how to start sqlplus.Please help me in accessing data base.
Darshan said…
Darshan,
hello sir this is darshan from q spiders after installing oracle 10g i couldn't start the working window.
in the service.msc i set all the oracle processes to manual and then tried to start it s showing error which is in the following screen shot
hello sir,
i have installed oracle database 10g in windows 7,n have given the system password as tiger itself but m not able to login.whenever i enter id n password the window disappears.
Nishkala said…
Hello sir,
My database installation was successful 10g on Windows 7,but when i try to login as scott and tiger the window disappears
Arun said…
Em ur new batch student, while explaining plz be slow sir!!!
hamid hasan said…
hi sir,
Oracle 10G has successfully installed but Scott id is not accepting.Only SYSTEM id is accepting.can i continue with this id or Scott id is mandatory to continue for sql.
plz reply asap.
Thanks
Hamid
Pradeep said…
Hello sir,
I have a query like, how can I create my own user in the database and put all the elements related to that user???
vimal said…
Hello sir,
I was using oracle10g without any problem but due to some problem i have uninstalled that one and i am trying to re install again.. it is showing an error "SID you have specified already exists on your machine.please specify a different SID" after this i try to remove the oracle from the registry but i didn't found any from there.. what to do???
vimal said…
Hello sir,
I was using oracle10g without any problem but due to some problem i have uninstalled that one and i am trying to re install again.. it is showing an error "SID you have specified already exists on your machine.please specify a different SID" after this i try to remove the oracle from the registry but i didn't found any from there.. what to do???
vimal said…
Hello sir,
I was using oracle10g without any problem but due to some problem i have uninstalled that one and i am trying to re install again.. it is showing an error "SID you have specified already exists on your machine.please specify a different SID" after this i try to remove the oracle from the registry but i didn't found any from there.. what to do???
shweta nandargi said…
This comment has been removed by the author.
shree said…
Hi Sir. I am finding error installing as OUI 10133 invalid staging area .. How to resolve it sir plz help out
shree said…
Hi Sir. I am finding error installing as OUI 10133 invalid staging area .. How to resolve it sir plz help out
Unknown said…
Hello sir,
I am getting same issue as Nishkala mentioned above . I have reinstalled the database but still i am getting the same issue. Please help me out in solving this issue.
PREETHI K S said…
Hi sir,
Oracle 10g software is currently unavailable to download in the link that you have provided above. So please tell me how can i download the software.

Popular posts from this blog

SQL Interview Questions on Subqueries

SUB Queries:
1. List the employees working in research department 2. List employees who are located in New York and Chicago
3. Display the department name in which ANALYSTS are working
4. Display employees who are reporting to JONES
5. Display all the employees who are reporting to Jones Manager
6. Display all the managers in SALES and ACCOUNTING department
7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them
8. Display all employees who do not have any reportees
9. List employees who are having at least 2 reporting
10. List the department names which are having more than 5 employees
11. List department name having at-least 3 salesman
12. List employees from research and accounting having at-least 2 reporting
13. Display second max salary
14. Display 4th max salary
15. Display 5th max salary  -- Answer for nth Max Salary
Co-Related Subqueries:
16. Write a query to get 4th max salary from EMP table
17. Write a query to get 2nd…

Answers for SUB Queries

1. SQL> select empno, ename from emp where deptno=(select deptno from dept where dname='RESEARCH');


2. SQL> select empno, ename from emp where deptno in (select deptno from dept where loc in ('NEW YORK','CHICAGO'));

3. SQL> select dname from dept where deptno in ( select deptno from emp where job ='ANALYST');

4. SQL> select empno, ename, mgr from emp where mgr = (select empno from emp where ename='JONES');

5. SQL> select empno, ename, mgr from emp where mgr = (select mgr from emp where ename='JONES')

6. SQL> select empno, ename, job from emp where deptno in ( select deptno from dept where dname in ('SALES','ACCOUNTING'))

7. SQL> select empno, ename, job from emp where deptno in ( select deptno from dept where dname in ('SALES','RESEARCH')) and empno in (select mgr from emp)

8. SQL> select empno, ename from emp where empno not in ( select mgr from emp where mgr is not null)

9. select…

'Linux-x86_64 Error: 28: No space left on device' While trying to start the database -- Error

SQL> startup mount pfile='/tmp/initdlfasp12.ora'
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device


This as you can see is on Linux x86 with 64 bit processor. We got this error after we changed SGA on 10gR2 database. So was sure that this is something to do with the OS.

Parameters to check for this are shmall.

shmall is the total amount of shared memory, in pages, that the system can use at one time.

$cat /proc/sys/kernel/shmmax
53687091200

$ getconf PAGE_SIZE
4096

As per Oracle SHMALL should be set to the total amount of physical RAM divided by page size.

Our system has 64GB memory, so change kernel.shmall = 1024 * 1024 * 1024 * 64 / 4096 = 16777216


Once this value is calculated you can modify Linux system configuration file directly.

$ su - root
vi /etc/sysctl.conf file:
kernel.shmall=16777216

and

# sysctl -p

Once this is done the database was started without any problem.