Notes on Oracle 10g Installation
Go to the Oracle download web site: http://www.oracle.com/technology/software/products/database/oracle10g/index.html
You may need two different downloads:
The 10g release is the database system itself. You need it only if you want to have databases local to your machine. 10g Client has the SQLPlusWorksheet application. It will allow you to connect to our Oracle server and/or your local database. Click on each release above to see the installation notes. There are additional notes on starting and stopping Oracle 10g, and logging on to Oracle.
The following is a series of screen snapshots that capture the settings you'll need. Install Oracle at the top of C: (or some other disk). I don't think Oracle likes blanks in its path (e.g., like "Program Files").
Select personal edition, provide a database password and remember this password! Here's the next panel:
Click install. The installer will take a while. You may (or may not) get errors during installation. In such cases, you may or may not get a correct installation. When it has not worked, I ended all of my user processes, and started again. Finally this page appears:
The most important thing to do at this time is to click password management button. You MUST activate the Scott account (and any others that you want). You will then be presented with a screen of information that looks like the following. Copy its contents into a text file for safe keeping.
You're almost done. Search the Oracle installation directory for the tnsnames.ora file. It should be in directory oracle\product\10.1.0\DB4\NETWORK\ADMIN. Open it and you'll find an entry like the one below:
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)
Copy this, as we will need to paste it into a corresponding file in the 10g client, once it is installed. You may have a different name than ORACLE = . This is the service name (ORACLE or whatever) that you will use to log onto your database.
For reference, here is the tnsnames.ora file that I use for my 10g server. Remember, I used the name ORACLE for my service name; yours might be different. Note also that "commando" is the name of my machine.
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_4\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = commando)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.microlab.cs.utexas.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
) |
Oracle will install lots of services which will heavily load your machine. Pull up the Windows services panel and see which ones are running. Make note of them, and do the following. Turn off each service and have it start manually. (If not, each time you boot your machine, Oracle will begin to run, and it is a resource hog). To run the local database, you need to start 3 services: OracleService, DBConsole, and CSService. I believe they can be started in any order. In fact, I use the following batch script on my windows machine to start, stop oracle:
rem %1 is either start or stop
net %1 OracleServiceORCL
net %1 OracleOradb10g_home1TNSListener
net %1 OracleCSService
Please note that the names of these services may be different on your machine, so modify the above script accordingly.
Here is the splash screen:
Choose administrator, Next. The installer will grinds for about 10 minutes.
Click cancel. You're almost done.
Now, search for the tnsnames.ora file in the 10g Client installation. It should be in oracle\product\10.1.0\Client_2\NETWORK\ADMIN. Do the following:
- Add the Oracle descriptor to this file that you extracted from your 10g install. (Click here see how to get this). This descriptor will allow you to log into to your local Oracle database. You can logon as "scott", password "tiger", and the installation service name that was defined in your Oracle 10g installation (e.g., ORACLE).
- Now add the following additional descriptor. It will allow you to log on as yourself to our class's Oracle server at school. You log on with your user name and password, using microlab as the service.
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.microlab.cs.utexas.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
For reference, here is the tnsnames.ora file that I use for my 10g client. Remember, I used the name ORACLE for my service name; yours might be different:
# tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.microlab.cs.utexas.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = commando)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
) |
Use SQLPlusWorksheet to logon to either your local install of 10g or our classes server.
- Local login: log on as "scott", password "tiger", and the installation service name that was defined in your Oracle 10g installation (e.g., ORACLE).
- Server login: log on with your user name and password, using microlab as the service.
Unlocking The Scott Account
So you forgot to unlock the Scott account, eh? Here is a suggestion. Login using SQLPlusWorksheet to oracle as "System", using the password you gave to system accounts during installation. Then run the following script:
Notes on Oracle 10g Installation
Go to the Oracle download web site: http://www.oracle.com/technology/software/products/database/oracle10g/index.html
You may need two different downloads:
The 10g release is the database system itself. You need it only if you want to have databases local to your machine. 10g Client has the SQLPlusWorksheet application. It will allow you to connect to our Oracle server and/or your local database. Click on each release above to see the installation notes. There are additional notes on starting and stopping Oracle 10g, and logging on to Oracle.
The following is a series of screen snapshots that capture the settings you'll need. Install Oracle at the top of C: (or some other disk). I don't think Oracle likes blanks in its path (e.g., like "Program Files").
Select personal edition, provide a database password and remember this password! Here's the next panel:
Click install. The installer will take a while. You may (or may not) get errors during installation. In such cases, you may or may not get a correct installation. When it has not worked, I ended all of my user processes, and started again. Finally this page appears:
The most important thing to do at this time is to click password management button. You MUST activate the Scott account (and any others that you want). You will then be presented with a screen of information that looks like the following. Copy its contents into a text file for safe keeping.
You're almost done. Search the Oracle installation directory for the tnsnames.ora file. It should be in directory oracle\product\10.1.0\DB4\NETWORK\ADMIN. Open it and you'll find an entry like the one below:
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)
Copy this, as we will need to paste it into a corresponding file in the 10g client, once it is installed. You may have a different name than ORACLE = . This is the service name (ORACLE or whatever) that you will use to log onto your database.
For reference, here is the tnsnames.ora file that I use for my 10g server. Remember, I used the name ORACLE for my service name; yours might be different. Note also that "commando" is the name of my machine.
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_4\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = commando)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.microlab.cs.utexas.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
) |
Oracle will install lots of services which will heavily load your machine. Pull up the Windows services panel and see which ones are running. Make note of them, and do the following. Turn off each service and have it start manually. (If not, each time you boot your machine, Oracle will begin to run, and it is a resource hog). To run the local database, you need to start 3 services: OracleService, DBConsole, and CSService. I believe they can be started in any order. In fact, I use the following batch script on my windows machine to start, stop oracle:
rem %1 is either start or stop
net %1 OracleServiceORCL
net %1 OracleOradb10g_home1TNSListener
net %1 OracleCSService
Please note that the names of these services may be different on your machine, so modify the above script accordingly.
Here is the splash screen:
Choose administrator, Next. The installer will grinds for about 10 minutes.
Click cancel. You're almost done.
Now, search for the tnsnames.ora file in the 10g Client installation. It should be in oracle\product\10.1.0\Client_2\NETWORK\ADMIN. Do the following:
- Add the Oracle descriptor to this file that you extracted from your 10g install. (Click here see how to get this). This descriptor will allow you to log into to your local Oracle database. You can logon as "scott", password "tiger", and the installation service name that was defined in your Oracle 10g installation (e.g., ORACLE).
- Now add the following additional descriptor. It will allow you to log on as yourself to our class's Oracle server at school. You log on with your user name and password, using microlab as the service.
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.microlab.cs.utexas.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
For reference, here is the tnsnames.ora file that I use for my 10g client. Remember, I used the name ORACLE for my service name; yours might be different:
# tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
MICROLAB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.microlab.cs.utexas.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = commando)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
) |
Use SQLPlusWorksheet to logon to either your local install of 10g or our classes server.
- Local login: log on as "scott", password "tiger", and the installation service name that was defined in your Oracle 10g installation (e.g., ORACLE).
- Server login: log on with your user name and password, using microlab as the service.
So you forgot to unlock the Scott account, eh? Using SQLPlusWorksheet, login as "system" using the password that you gave to system accounts when you installed oracle. Next, execute the following statements:
alter user scott account unlock;
grant connect, resource to scott;
That should do it. If you want to create new accounts, try this:
create user LOGINNAME profile default identified by PASSWORD;
alter user LOGINNAME account unlock;
grant connect, resource to PASSWORD;
