New to Oracle

skarrlette · Apr 22, 2014

Hi I am new to this site and new to Oracle. In fact I have no real experience with databases at all. I have Windows 7 and decided to download Oracle Database 11g to learn. Some how I ran it and then a beige window box comes up called "Oracle Database 11g release 2 Installer-Installing database - step 1 of 9." Then it says Configure security updates enter email and password which I do then I hit next, and on the next screen it asks me for .....

Specific proxy server information

proxer server

a proxy port

proxy username

and proxy password.

Not sure what any of it means or did I do something wrong. can someone tell me what my next step is to install the database?

Thanks in advance !

zargon · Apr 22, 2014

You start over and choose the 'I don't want to be notified' selection and move on. For this purpose you don't need to configure automatic updates since you do not have an Oracle CSI number or support contract.

krasnoslobodtsev_si · Apr 23, 2014

Hi.

Look in documentation, there enough everything is well considered.

The following table lists the various screens displayed during an Enterprise Edition installation for Oracle Database 11g Release 2 (11.2):
Table 4-1 Oracle Universal Installer Windows
Screen Action Configure Security Updates
Enter your e-mail address, preferably your My Oracle Support (formerly OracleMetaLink) e-mail address or user name in the Email field.
You can select the I wish to receive security updates via My Oracle Support check box to receive security updates.
Enter your My Oracle Support (formerly OracleMetaLink) password in the My Oracle Support Password field.
Click Next.
Download Software Updates
Starting with Oracle Database 11g Release 2 (11.2.0.2), you can use the Software Updates feature to dynamically download and apply latest updates. Select one of the following options, and click Next:

Use My Oracle Support credentials for download: Select this option to download and apply the latest software updates.
Click Proxy Settings to configure a proxy for Oracle Universal Installer to use to connect to the Internet. Provide the proxy server information for your site, along with a user account that has access to the local area network through which the server is connecting. Starting with Oracle Database 11g Release 2 (11.2.0.3), you can enter the Proxy Realm information. The proxy realm information is case-sensitive. If you do not have a proxy realm, then you do not need to provide an entry for the Proxy Username, Proxy Password, and Proxy Realm fields.
Click Test Connection to ensure that your proxy settings are correctly entered, and the installer can download the updates.

Use pre-downloaded software updates: Select this option if you have already downloaded software updates using the Oracle Universal installer command setup.exe -downloadUpdates.

Skip software updates: Select this option if you do not want to apply any updates.

See Also: "Software Updates Option"
Apply Software Updates
This screen is displayed if you select to download the software updates, or provide the pre-downloaded software updates location.

If you selected Use My Oracle Support credentials for download in the previous screen, select Download and apply all updates, and then click Next to apply the updates.
By default, the download location for software updates is placed in the home directory of the Oracle installation owner you are using to run this installation. If you choose to download the software updates in another location, then click Browse and select a different location on your server.

If you selected Use pre-downloaded software updates in the previous screen, select Apply all updates, and then click Next to apply the updates downloaded before starting the installation.

Select Installation Option
Select one of the following installation options, click Next.

Create and configure a database: This option creates a new database along with sample schemas.

Install database software only: This option installs only the database binaries. To configure database, you must run Oracle Database Configuration Assistant after the software installation.

Upgrade an existing database: This option installs the software binaries in a new Oracle home. At the end of the installation, you can upgrade the existing database.

System Class
Select the type of system for installing the database, click Next.

Desktop Class: Choose this option if you are installing on a laptop or desktop class system. This option includes a starter database and allows minimal configuration. This option is designed for those who want to get up and running with the database quickly.

Server Class: Choose this option if you are installing on a server class system, such as what you would use when deploying Oracle in a production data center. This option allows for more advanced configuration options. Advanced configuration options available using this option include Oracle RAC, Oracle Automatic Storage Management, backup and recovery configuration, integration with Enterprise Manager Grid Control, and more fine-grained memory tuning, among many others.

Grid Installation Options
Select the type of database installation you want to perform, click Next.

Single instance database installation: This option installs the database and the listener.

Oracle Real Application Clusters database installation: This option installs Oracle Real Application Clusters.

Oracle RAC One Node database installation: This option installs Oracle RAC One Noda database.
Note: Oracle RAC One Node is only supported with Oracle Clusterware.

Select Install Type
Select one of the following, then click Next:

Typical Install: This installation method is selected by default. It lets you quickly install Oracle Database using minimal input. It installs the software and optionally creates a general-purpose database using the information that you specify on this screen.

Advanced Install: This installation method enables to perform more complex installations, such as creating individual passwords for different accounts, creating specific types of starter databases (for example, for transaction processing or data warehouse systems), using different language groups, specifying e-mail notifications, and so on.

Select Product Languages
This option enables you to select the language in which you want to run the product.
Select the product Language from the Available Languages list, transfer it to the Selected Languages list. Click Next.
Select Database Edition
Select Enterprise Edition, Standard Edition, Standard Edition One, or Personal Edition. Click Next
If you click Select Options, then based on your selection you can enable or disable components from the components list. The components available are:

Oracle Partitioning

Oracle OLAP

Oracle Label Security

Oracle Data Mining RDBMS Files

Oracle Database Vault option

Oracle Real Application Testing

Oracle Database Extensions for .NET

Click OK to continue.
Click Next.
Note: The Select Options button is enabled only if you select the Enterprise Edition installation type.
Specify Installation Location
The Oracle base path appears by default. You can change the path based on your requirement. Specify Oracle Base, Software Location, and click Next.
The Oracle base directory is a top-level directory for Oracle software installations owned by an Oracle installation owner account. The default Oracle base path is DRIVE_LETTER:\app\user, where user is the user account running the installation. You can change the path based on your requirements.
In the Software Location field, accept the default value or enter the Oracle home directory path in which you want to install Oracle components. The directory path should not contain spaces.
Click Next.
Note: This screen is available only with Advanced Installation.
See Also: "Optimal Flexible Architecture Directory Naming Conventions" for information about directory naming conventions
Select Configuration Type
Select one of the following, click Next:

General Purpose / Transaction Processing: This is a starter database designed for general usage or transaction-heavy applications.

Data Warehousing: A starter database optimized to run Data Warehousing applications.

See the online Help provided by either Oracle Universal Installer or Oracle Database Configuration Assistant for a description of these preconfigured database types.
Specify Database Identifiers
Specify the following information, then click Next:
Database Naming
Specify the Global Database Name using the following syntax:
database_unique_name.db_domain where:

database_unique_name is the name of the database. It can contain a maximum of 30 characters as long as the first eight characters are unique and begin with an alphabetic character. The characters can include alphanumeric, underscore (_), dollar ($) , and pound (#), no other special characters are permitted in a database name.

db_domain is the computer environment used for the database. It should contain no more than 128 characters (alphanumeric, underscore (_), and pound (#)), inclusive of all periods.

Note: Ensure that the combination of database name (first eight unique characters of database unique name), delimiter, and the database domain name does not exceed 128 characters.
For example:
sales.us.example.com where:

database_unique_name is sales

db_domain is us.example.com

When you enter the Global Database Name, Oracle Universal Installer automatically populates the SID prefix with the database name. You can change this name in Advanced installation.
Oracle Universal Installer limits the SID to 12 alphanumeric characters and the SID cannot contain underscore (_), dollar ( $), and pound (#).
Specify Configuration Options
Specify the following configuration details, then click Next.
Memory:
Enable Automatic MemoryManagement option is selected by default. This option allows the database to automatically distribute memory between SGA and PGA. If you deselect this option, then the SGA and PGA must be sized manually.
Character Sets:
This option enables you to store the character data in the database in one of the following methods:

Use the default: This option uses the operating system language settings.

Use Unicode: This option enables you to store multiple language groups.

Choose from the following list of character sets: This option enables the Select Database Character Set drop down list.

See Also:

"Selecting the Database Character Set"

Oracle Database Globalization Support Guide for information about choosing a character set.

Security:
The Assert all new security settings option is selected by default. The setting includes enabling auditing and using new password profile.
Note: Oracle recommends that you use the default settings.
Sample Schemas:
The Create database with sample schemas option is not selected by default. However, you can select the option, to create the starter database with sample schema.
Specify Management Options
Select one of the following, then click Next:

Use an existing Oracle Enterprise Manager Grid Control for database management: This option is useful if you have Oracle Enterprise Manager installed.

Use Oracle Enterprise Manager Database Control for database management: This option enables you to manage Oracle Database locally. Optionally, select Enable Email Notifications and then enter the outgoing SMTP server and e-mail address.
See Also: "Email Notification Options"
Note: The option to enable e-mail notifications is not available starting with Oracle Database 11g Release 2 (11.2.0.2).

Specify Database Storage Options
Select one of the following, then click Next.

File System: Specify the database file location.

Oracle Automatic Storage Management: Specify a password for the ASMSNMP user.

Note: Installing Oracle data files on an Oracle ACFS file system is not supported. Oracle recommends that these data files are installed in Oracle ASM disk groups.
See Also: "Using an Oracle Automatic Storage Management Disk Group"
Specify Recovery Options
Select one of the following, then click Next.

Do not enable automated backups.

Enable automated backups: If you select this option, then the backup job uses a specified recovery area storage.
Select File System to use a file system directory for the fast recovery area, and then specify the fast recovery area path in the Recovery Area location field.
Select Oracle Automatic Storage Management to use an Oracle Automatic Storage Management disk group for the fast recovery area.
Specify your operating system user credentials to perform the backup job.

See Also: "Preparing Disks for an Oracle Automatic Storage Management Installation"
Select ASM Disk Group
This screen is displayed only if you select Oracle Automatic Storage Management as your storage option.
Disk groups are created during the Oracle Grid Infrastructure installation. Disk groups are configured with the SYSASM privilege using asmcmd or SQL create diskgroup commands. An ASM disk group consists of multiple disk partitions.
The table in this screen displays existing disk groups created during the Oracle Grid Infrastructure installation. Select a disk group to use for database file storage.
Specify Schema Passwords
Enter and confirm passwords for the privileged database accounts: SYS, SYSTEM, SYSMAN, and DBSNMP.
Click Next.
Note: Optionally, you can use the same password for all accounts. However, Oracle recommends that you specify a different password for each account. You must remember the passwords that you specify.
See Also: "Unlocking and Resetting User Passwords" for information about password guidelines
Perform Prerequisite Checks
This option checks if the minimum system requirements to perform the database installation are met.
Click Fix & Check Again, if you want the installer to fix the problem and check the system requirements once more.
If you click Check Again, then you can run the prerequisite check again to see if the minimum requirements are met to carry on with the database installation.
To get a list of failed requirements, select Show Failed from the list. To get a list of all the prerequirement checks run by the OUI, select Show All. To get a list of the prerequirement checks that are successful, select Show Succeeded.
Note: Oracle recommends that you use caution in checking the Ignore All option. If you check this option, then Oracle Universal Installer may not confirm that your system can install Oracle Database successfully.
See Also: "Oracle Database Preinstallation Requirements" for information about the system requirements
Summary
Review the information displayed on this screen, and click Install.
Note: Starting with Oracle Database 11g Release 2 (11.2), you can save all the installation steps into a response file by clicking Save Response File. Later, this file can be used for a silent installation.
Install Product
This screen displays the progress of a database installation. It also shows the status information while the product is being installed. Click Next.
This screen then displays the status information for the configuration assistants that configure the software and create a database. When the message is displayed after Database Configuration Assistant process, click OK to continue.
Finish
This screen is shown automatically when all the configuration tools are successful.
Review the Enterprise Manager Database Control URL information displayed in this screen and click Close.

Click to expand...

See links :

http://docs.oracle.com/cd/E11882_01/install.112/e47798/install.htm#NTDBI2788

http://docs.oracle.com/cd/E11882_01/install.112/e47798/install.htm#NTDBI2766
http://docs.oracle.com/cd/E11882_01/install.112/e47798/reqs.htm#NTDBI002

marcusnicholas · Feb 3, 2015

hi i am also new to oracle database anybody give me basic introduction link for windows 7 32 bit operating system

zargon · Feb 3, 2015

google.com is your friend, it would benefit you to use it. You'll find the information you're asking for there.

helenfrances2 · Apr 9, 2015

I would like to suggest to search on google, and you will have plenty of resources.

Log in

New to Oracle

skarrlette Guest

zargon Community Moderator Forum Guru

krasnoslobodtsev_si Forum Genius

marcusnicholas Active Member

zargon Community Moderator Forum Guru

helenfrances2 Active Member