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
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.
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
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.
Query retrieval etc..
Yes even metadata is data, but this data is not user data. Metadata is databases data.
Regards,
Mithun
You should run it in compatible mode set to XP because on some versions of Win 7 has issues with installation.
Regards,
Mithun
You should login as user SCOTT only then you will be able to see table emp.
Regards,
Mithun
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
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.
thIS IS rAVI rAnJAN,It's really very helpful for beginer.thnks a lot for helping me out.
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..
Can you pls send a screenshot of fatal error to my mail id.
Regards,
Mithun
Right click on sql*plus and click on Run As administrator.
Regards,
Mithun
I installed oracle 10g successfully.. video was so helpful.. thanq..
I installed oracle 10g successfully.. video was so helpful.. thanq..
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?
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
Yes you can work with home1 no problem.
Regards,
Mithun
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
Please tel me on how to rectify that.
Thanks in advance.
plz
Note: still able to connect to oracle using sqlplus.
on my email id-ravi.saxena64@gmail.com
do the needful sir.
Thanks
Please tel me on how to rectify that.
Thanks in advance.
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.
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.
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.
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
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.
My database installation was successful 10g on Windows 7,but when i try to login as scott and tiger the window disappears
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
I have a query like, how can I create my own user in the database and put all the elements related to that user???
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???
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???
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???
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.