Perhaps your task is not to create a new database, but to upgrade an existing database. A database upgrade is necessary when Oracle DBA have an older database such as Oracle9i and need to upgrade it to the current release. Oracle provides a tool for upgrading an existing database, called the Database Upgrade Assistant (DBUA).
The Database Upgrade Assistant (DBUA) interactively steps Oracle DBA through the upgrade process and configures the database for the new Oracle Database 10g release. The Database Upgrade Assistant automates the upgrade process by performing all of the tasks normally performed manually.
The Database Upgrade Assistant makes appropriate recommendations for configuration options such as tablespaces and redo logs. Oracle DBA can then act on these recommendations. For example, the Database Upgrade Assistant recommends sizing information for the new SYSAUX tablespace, which is required in Oracle Database 10g. Before the Upgrade The Database Upgrade Assistant performs the following pre-upgrade steps: It checks for any invalid user accounts or roles It checks for any invalid datatypes It checks for any desupported character sets It checks for adequate resources, including rollback segments, tablespaces, and free disk space It optionally backs up all necessary files The Database Upgrade Assistant does not begin the upgrade until it completes all of the pre-upgrade steps.
During the Upgrade The Database Upgrade Assistant automatically modifies or creates new required tablespaces, invokes the appropriate upgrade scripts, archives the redo logs, and disables archiving during the upgrade phase. While the upgrade is running, the Database Upgrade Assistant shows the upgrade progress for each component.
The Database Upgrade Assistant writes detailed trace and log files and produces a complete HTML report for later reference. To enhance security, the Database Upgrade Assistant automatically locks new user accounts in the upgraded database. The Database Upgrade Assistant then proceeds to create new configuration files (parameter and listener files) in the new Oracle home.
Read the complete article at http://Oracleonline.info/upgrade_database.html
Showing posts with label learn-oracle. Show all posts
Showing posts with label learn-oracle. Show all posts
Thursday, May 22, 2008
Friday, May 9, 2008
Installation Choices
Installation Choices The Oracle Universal Installer guides you through an interview phase that asks you to specify your choices for installation and database creation.
The exact sequence of pages depends on your platform. All platforms include the following choices: What database product do you want to install? You can install one of the following: Oracle Enterprise Edition—Oracle’s most full featured database product providing data management for high-end applications.
Oracle Standard Edition—A less-expensive and somewhat scaled down version of the Oracle database suitable for workgroup or department level applications Custom Install—Allows Oracle DBA to customize the Enterprise Edition by selecting products to install. Do this if Oracle DBA want to add a component to your database that would not normally be installed or prevent certain components from being installed.
Do Oracle DBA want to create a starter database in addition to installing the Oracle software? To create the database, the installer automatically launches the Database Configuration Assistant at the end of the installation.
If Oracle DBA want a preconfigured database installed, Oracle DBA can select one of the following database types, optimized according to usage: General Purpose Transaction Processing Data Warehouse If Oracle DBA want to create an custom database where Oracle DBA configure your own database structure, you can select an advanced install. What are your Database Configuration Options?
These include your Global Database Name, Oracle System Identifier (SID), and whether to install the example schemas. The Global Database Name is the full name of the database which uniquely identifies it from any other database. The global database name is of the form database_name.database_domain as in sales.us.acme.com. The database name portion sales is a simple name you call your database.
The database domain portion us.acme.com specifies the database domain in which the database is located. Together database name and domain make up the Global Database Name. Oracle recommends that you install the example schemas so that you can run many of the examples in the documentation.
Read the complete oracle article at http://Oracleonline.info/install_choice.html
The exact sequence of pages depends on your platform. All platforms include the following choices: What database product do you want to install? You can install one of the following: Oracle Enterprise Edition—Oracle’s most full featured database product providing data management for high-end applications.
Oracle Standard Edition—A less-expensive and somewhat scaled down version of the Oracle database suitable for workgroup or department level applications Custom Install—Allows Oracle DBA to customize the Enterprise Edition by selecting products to install. Do this if Oracle DBA want to add a component to your database that would not normally be installed or prevent certain components from being installed.
Do Oracle DBA want to create a starter database in addition to installing the Oracle software? To create the database, the installer automatically launches the Database Configuration Assistant at the end of the installation.
If Oracle DBA want a preconfigured database installed, Oracle DBA can select one of the following database types, optimized according to usage: General Purpose Transaction Processing Data Warehouse If Oracle DBA want to create an custom database where Oracle DBA configure your own database structure, you can select an advanced install. What are your Database Configuration Options?
These include your Global Database Name, Oracle System Identifier (SID), and whether to install the example schemas. The Global Database Name is the full name of the database which uniquely identifies it from any other database. The global database name is of the form database_name.database_domain as in sales.us.acme.com. The database name portion sales is a simple name you call your database.
The database domain portion us.acme.com specifies the database domain in which the database is located. Together database name and domain make up the Global Database Name. Oracle recommends that you install the example schemas so that you can run many of the examples in the documentation.
Read the complete oracle article at http://Oracleonline.info/install_choice.html
Thursday, May 8, 2008
Checking Prerequisites
Before the installation process, Oracle performs a number of automated prerequisite checks to ensure that your machine fulfills the basic hardware and software requirements for an Oracle install. If your machine does not meet any of the requirements, an error message is displayed.
The requirements may vary somewhat depending upon the type of machine and operation system Oracle DBA are running, but some examples of prerequisite checks include: A minimum of 512 MB of memory is available
Sufficient paging space is available. Appropriate operating system service packs or patches are installed. Appropriate files system format is being used. The installer automatically sets any operating system environment variables that the Oracle database server requires for its operation.
The Oracle Universal Installer guides Oracle DBA through an interview phase that asks Oracle DBA to specify your choices for installation and database creation. The exact sequence of pages depends on your platform. All platforms include the following choices: What database product do Oracle DBA want to install?
Oracle DBA can install one of the following: Oracle Enterprise Edition—Oracle’s most full featured database product providing data management for high-end applications. Oracle Standard Edition—A less-expensive and somewhat scaled down version of the Oracle database suitable for workgroup or department level applications Custom Install—Allows Oracle DBA to customize the Enterprise Edition by selecting products to install.
Do this if Oracle DBA want to add a component to your database that would not normally be installed or prevent certain components from being installed.
Read on to learn oracle more http://Oracleonline.info
The requirements may vary somewhat depending upon the type of machine and operation system Oracle DBA are running, but some examples of prerequisite checks include: A minimum of 512 MB of memory is available
Sufficient paging space is available. Appropriate operating system service packs or patches are installed. Appropriate files system format is being used. The installer automatically sets any operating system environment variables that the Oracle database server requires for its operation.
The Oracle Universal Installer guides Oracle DBA through an interview phase that asks Oracle DBA to specify your choices for installation and database creation. The exact sequence of pages depends on your platform. All platforms include the following choices: What database product do Oracle DBA want to install?
Oracle DBA can install one of the following: Oracle Enterprise Edition—Oracle’s most full featured database product providing data management for high-end applications. Oracle Standard Edition—A less-expensive and somewhat scaled down version of the Oracle database suitable for workgroup or department level applications Custom Install—Allows Oracle DBA to customize the Enterprise Edition by selecting products to install.
Do this if Oracle DBA want to add a component to your database that would not normally be installed or prevent certain components from being installed.
Read on to learn oracle more http://Oracleonline.info
Tuesday, May 6, 2008
Oracle Database Architecture
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data.
All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components.
There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.
The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.This learn oracle article contains the following topics :
Physical Database Structure
Logical Database Structure
An Oracle Instance
Learn Oracle - Physical Database Structures
Datafiles - Every Oracle database has one or more physical datafiles. The datafiles contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the datafiles allocated for a database.
The characteristics of datafiles are:
A datafile can be associated with only one database.Datafiles can have certain characteristics set to let them automatically extend when the database runs out of space.One or more datafiles form a logical unit of database storage called a tablespace.
Data in a datafile is read, as needed, during normal database operation and stored in the memory cache of Oracle. For example, assume that a user wants to access some data in a table of a database.
If the requested information is not already in the memory cache for the database, then it is read from the appropriate datafiles and stored in memory. Modified or new data is not necessarily written to a datafile immediately.
Learn more about Oracle at http://Oracleonline.info/Oracle_architecture.html
All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components.
There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.
The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.This learn oracle article contains the following topics :
Physical Database Structure
Logical Database Structure
An Oracle Instance
Learn Oracle - Physical Database Structures
Datafiles - Every Oracle database has one or more physical datafiles. The datafiles contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the datafiles allocated for a database.
The characteristics of datafiles are:
A datafile can be associated with only one database.Datafiles can have certain characteristics set to let them automatically extend when the database runs out of space.One or more datafiles form a logical unit of database storage called a tablespace.
Data in a datafile is read, as needed, during normal database operation and stored in the memory cache of Oracle. For example, assume that a user wants to access some data in a table of a database.
If the requested information is not already in the memory cache for the database, then it is read from the appropriate datafiles and stored in memory. Modified or new data is not necessarily written to a datafile immediately.
Learn more about Oracle at http://Oracleonline.info/Oracle_architecture.html
Saturday, May 3, 2008
Common Oracle DBA Tasks
As an Oracle DBA, you can expect to be involved in the following tasks:
Installing Oracle software
Creating Oracle databases
Performing upgrades of the database and software to new release levels
Starting up and shutting down the Oracle database
Managing the database's storage structures
Managing users and security
Managing schema objects, such as tables, indexes, and views
Making Oracle database backups and performing recovery when necessary
Proactively monitoring the database's health and taking preventive or corrective action as required
Monitoring and tuning performance In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning.
Few more can be read at http://Oracleonline.info/dba_task.html
Installing Oracle software
Creating Oracle databases
Performing upgrades of the database and software to new release levels
Starting up and shutting down the Oracle database
Managing the database's storage structures
Managing users and security
Managing schema objects, such as tables, indexes, and views
Making Oracle database backups and performing recovery when necessary
Proactively monitoring the database's health and taking preventive or corrective action as required
Monitoring and tuning performance In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning.
Few more can be read at http://Oracleonline.info/dba_task.html
Friday, May 2, 2008
What is a Oracle Database
Oracle is a relational database. In a relational database, all data is stored in two-dimensional tables that are composed of rows and columns. The Oracle Database enables you to store data, update it, and efficiently retrieve it.
Oracle provides software to create and manage the Oracle database. The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server. Collectively, the software that runs oracle and the physical database are called the Oracle database system.
Some of Oracle's tools to access the database and create programs are:
SQL*Plus has a command line interface. With it, you can access the database and write stored procedures, you can run SQL commands to retrieve data and you can run scripts of either SQL, PL/SQL or built-in SQL*Plus commands, or a mixture of those three things.
Oracle Developer is a 4GL GUI application Builder. With Developer, you can create forms, reports, and graphics. Oracle*Forms and Oracle*Reports are two components of Oracle Developer. Earlier versions created client-server applications, but the more recent versions create web applications that run under the Oracle Application Server (OAS). OAS is a web-based application server sold by Oracle. OAS is licensed separately and is very expensive (as are its closed source competitors). The current version is OAS 10g.
HTML DB is a fairly new application builder geared toward web development (added to the DB with release 9iR2). HTML DB does not need an application server. This tool runs from the database and can be presented to the web using the Apache web server that comes with the database. Since this is not an additional license, it provides a cheaper way to develop applications. Developer is a feature-rich thick client with all of the normal GUI widgets. HTML DB is HTML-based and is very thin and limited to the HTML provided widgets.
Oracle Enterprise Manager (OEM) is the Enterprise GUI tool to manage the database. From this tool, you can perform any action in the database that is required. This tool is primarily used for administration but can also be provided to developers for application tuning and monitoring. In Oracle 10g, OEM also provides Grid control.
Read next steps at http://Oracleonline.info
Oracle provides software to create and manage the Oracle database. The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server. Collectively, the software that runs oracle and the physical database are called the Oracle database system.
Some of Oracle's tools to access the database and create programs are:
SQL*Plus has a command line interface. With it, you can access the database and write stored procedures, you can run SQL commands to retrieve data and you can run scripts of either SQL, PL/SQL or built-in SQL*Plus commands, or a mixture of those three things.
Oracle Developer is a 4GL GUI application Builder. With Developer, you can create forms, reports, and graphics. Oracle*Forms and Oracle*Reports are two components of Oracle Developer. Earlier versions created client-server applications, but the more recent versions create web applications that run under the Oracle Application Server (OAS). OAS is a web-based application server sold by Oracle. OAS is licensed separately and is very expensive (as are its closed source competitors). The current version is OAS 10g.
HTML DB is a fairly new application builder geared toward web development (added to the DB with release 9iR2). HTML DB does not need an application server. This tool runs from the database and can be presented to the web using the Apache web server that comes with the database. Since this is not an additional license, it provides a cheaper way to develop applications. Developer is a feature-rich thick client with all of the normal GUI widgets. HTML DB is HTML-based and is very thin and limited to the HTML provided widgets.
Oracle Enterprise Manager (OEM) is the Enterprise GUI tool to manage the database. From this tool, you can perform any action in the database that is required. This tool is primarily used for administration but can also be provided to developers for application tuning and monitoring. In Oracle 10g, OEM also provides Grid control.
Read next steps at http://Oracleonline.info
Thursday, April 17, 2008
Learn Oracle - Become oracle DBA in 10 simple steps
I have created Learn Oracle website for anyone who wants to Learn Oracle and perform common day-to-day administrative tasks with the Oracle Database. Prior knowledge or experience with managing databases is not required. The only requirement is a basic knowledge of computers.The website is targeted toward the following groups of Oracle users:
-Developers wanting to acquire part-time DBA skills
-Anyone managing departmental servers
-Database administrators managing an Oracle database for small or medium business (SMB)
The website is equally useful for enterprise DBAs. It provides recommended best practices and describes efficient ways of performing administrative tasks with Oracle Enterprise Manager as the primary interface.
You can access the website at http://Oracleonline.info/
-Developers wanting to acquire part-time DBA skills
-Anyone managing departmental servers
-Database administrators managing an Oracle database for small or medium business (SMB)
The website is equally useful for enterprise DBAs. It provides recommended best practices and describes efficient ways of performing administrative tasks with Oracle Enterprise Manager as the primary interface.
You can access the website at http://Oracleonline.info/
Subscribe to:
Posts (Atom)