Oracle Tutorial 1 - Part 3

This video shows you have to check your Oracle 11g install to make sure everything is installed correctly. You will also see how to access the SQL*Plus Window, Login and create your first table. SQL syntax and language will be discussed in the next lecture.

Category:

Education

Tags:

• Oracle
• Database
• Design

[bjhecker]

There are about 10 videos in the Oracle class playlist. The tutorials are based on the install and the class videos are on basic database usage and design. I think part 3 (this video) is the last part of the install set. Next, I would watch the lecture series.

[bjhecker]

You need to type in "connect" with the Oracle 10 release as well. I double checked and the video is correct. With the newer 11.2g release I suspect the menu options or some of the console features might be different though. Next time, I'll use the more current version. It just came out not too long ago.

[bjhecker]

Make sure the Oracle services are running. You might see are start/stop database option in the start-up menu. Try the "start" option then go into the SQLPlus console. You could also try:

Start --> Run--> type " services.msc"

Select the OracleService name, Right Click, Start.

If you are running with Windows 7, make sure you are using:

Oracle 11g Release-2

Other Oracle versions have problems with the background services starting and running.

[arfirst]

Hello, Great Videos! Can you let me know which video is the next one ? Thanks

[mmmooommmzaz]

@MidMeOn yes i can because you did not set your oracle_sid type set oracle_sid=database name in cmd

[mmmooommmzaz]

to start your oracle service in windows environment type net start oracleservice...

where dots are your database name to connect type set oracle_sid=database name if you are connecting from cmd you dont need a listener but if u dont type lsnrctl start in cmd this should start your listener

[mmmooommmzaz]

cl screen

[fishcious]

What is the title of the next video in the series?

[ranaamit1423]

very very nice video........that's really a privilege to watch this one............nice work :)

[adaseth]

I believe that the date was just the current date and the "Production" was a part of the title.