Oracle DBA Startup guide Post 3

Oracle Database 10g is an Relational Database or RDBMS. There are two part of this RDBMS and they are Physical Database and Oracle Instance. Physical files, redo log files and control file are comutatively called as physical database. Oracle instance consists of a big memory area and some background process. It provide a way to the users to do an activity on the data. i.e. to retrive, add, modify or delete.

Data files - Physically stores the data
Redo log file - It contains the changes made to data. It is required for recovery.
Control files - It contains tipical information about database

1. Datafile location
2. Synchronization Information
3. Backup and recovery information

Supporting files i.e. parameter file, password file, alert log are important to database but is not a part of the database.

Naming convention of the database objects

1. Max 30 characters are supported
2. It have to start with a latter
3. Can include latter, number and underscore
4. Should not user reserved words

Oracle DBA Startup guide Post 2

Oracle Database 10g installation CD is required to do a basic installation. Minimum 4 GB free disk space and 250 MB memory is required to do the installed. It can take at around 30 minutes to install the database. It also does some system checks i.e. utility and file permission.

There are various features in instance configuration

• DBCA ( Database configuration assistance)
• Policy based database configuration
• Initialization Parameter

You can create database both using DBCA or manually from command line.

More in next post....... 

Oracle DBA Startup guide Post 1

First task of an Oracle DBA is to install the Oracle Database. But before installing the database, DBA has to estimate the configuration of the server on which it is going to be installed. He have to keep in mind the bellow points,

1. Operation System version and compatability
2. Number and speed of the server
3. Size of the disk for configuration
4. Size of Memory( Primary as RAM)
5. Amount of space for backups

Oracle Enterprise Manager(OEM) Database Control included in oracle database 10g is installed for managing local databases. You need to install OEM grid control ( from Oracle Enterprise Manager CD ) for controlling multiple hosts, database and other oracle services.

Before installing Oracle Database, Oracle Universal Installer( OUI ) does a system compatability check to confirm the hardware, free disk space, OS version and other required utility.

More in next post......

Oracle Apps DBA Future

Now we have come to a stage where Oracle Apps ( E Business Suite) will face a dramatic change in its future.

Previously, Oracle Apps DBA were those persons who knows

1. Oracle E Business Suite System Administration
2. Oracle Core DBA Activities
3. Troubleshooting
4. Some Unix Knowledge
5. And some other knowledge

Now Oracle has planed to make it upgraded with Oracle Apps 12.2 which will 

push the DBAs' to update themselves.

More in Next Post.

11g Oracle DBA -- Part 2

 ​ 11g Oracle DBA -- Part 2

Introduction of 11g Database

Here we will go through the basic concepts of 11g Database. As an Oracle DBA you have to do the bellow activities. You have to install a Database. You may have to create a database. If required a DBA sometimes have to do an upgrade of the Database Server and the Database also. As per requirements it is a general requirement in a project that the database need to be started, stopped or restarted. They have plan the storage and memory structure of the database. It is one of the primary duty of a DBA to maintain user list and their securities. You have to manage all the database objects such as views, tables, indexes etc. To do backups and recoveries whenever required.  

Weather a DBA will do all these activities or there will be divisions in terms of responsibilities, that depends upon the requirement, scope, and size and budget of the project.

For doing the above activities a DBA uses the bellow tools. These are the weapons of a DBA to complete his tasks. 

• Oracle Universal Installer (OUI)
• Oracle Database Configuration Assistant (DBCA)
• Database Upgrade Assistant (DBUA)
• Net Configuration Assistant (NETCA)
• Oracle Enterprise Manager Database Control
• SQL* Loader
• Recovery Manager (RMAN)

​

More in Next Part 

11g Oracle DBA -- Part 1

 ​ 11g Oracle DBA -- Part 1

In this section we will cover the various section a DBA need to cope up to administering 11g Oracle Database.

1. Introduction of 11g Database
2. How to install Oracle Database and how to create a Database
3. Starting Oracle Database administration
4. How to configure Network for Oracle Database
5. How to manage Oracle Database Instance
6. How to manage Oracle Database storage Structures
7. How to control User Accounts and Security
8. How to manage Oracle Database Schema Objects
9. How to do backup and recovery objectives
10. How to Monitor and Tune a database
11. Managing and Troubleshooting Oracle Database
12. Managing ORacle Database Software

In this section we have given a brief idea about the Oracle 11g DBA Activities.

More in next post........

Oracle iRecruitment (iRec) External Candidate (Site Visitor) Configuration - Login Steps

​ 

 Oracle iRecruitment (iRec) External Candidate (Site Visitor) Configuration & Login Steps

1. Make sure that you are using seeded iRecruitment External candidate responsibilities.

2. Set the SSO Profile settings with the values.

Applications SSO Login Types - Both
Applications SSO Type - SSWA
Applications SSO User Creation and Updation Allowed - Enabled
Application SSO LDAP Synchronization - Enabled

3. Schedule the following concurrent processes:
• iRecruitment Index Synchronization
This ensures the job posting and document indexes are kept up to date and should be scheduled to run as follows:
– Online index rebuild – to run every 5 minutes
– Full index rebuild – to run each night

• Synchronize WF Roles

4. Check the IRC: Registration Business Group profile pointing to a correct business group for the iRecruitment External candidate Responsibility.

5. Add site visitor responsibilities to your Guest user
Assign the iRecruitment Employee Site Visitor and iRecruitment External Site Visitor responsibilities to your guest user (identified by the Guest User Password profile option). This step is required to allow
access to the site visitor screens without logging in to the application.

6. Also, download IrcVisitor.jsp page from the server and open the page in text editor and check if the Responsibility ID of 'iRecruitment Site Visitor' login page pointing to upon login. Pointing to a correct responsibility and this responsibility should be pointing in the login jsp page.

7. Set up proxy server
Use the following profiles to set up your proxy server:

• Applications Server Side Proxy Host and Domain
• Applications Proxy Bypass Domain
• IRC: Proxy Authorization Password
• IRC: Proxy Authorization User Name

8. Configure and Freeze your flexfields
Configure and Freeze all flexfields used in iRecruitment. This stops error messages appearing on the screen telling you that your flexfields have not been frozen.

9. Check the log–in URL for iRecruitment users
The URL for connecting to the iRecruitment system varies according to the user group. For example, the internal site visitor URL is different from the external site visitor URL.
For external site visitors, you access the IrcVisitor.jsp. The location of this jsp will depend on ​your applications server, however, it is of the form:
http://hostname:port/OA_HTML/IrcVisitor.jsp
For internal site visitors, you access the IrcEmpVisitor.jsp. The location of this jsp also depends on your applications server, however, it is of the form:
http://hostname:port/OA_HTML/IrcEmpVisitor.jsp
You should replace the http://hostname:port/OA_HTML part of the URL with the URL of the html directory on your applications server.
Note: If you have installed other languages, you activate iRecruitment in the required language by adding the following suffix to the log–in URLs:
?L=<language code>
For example,
http://hostname:port/OA_HTML/IrcVisitor.jsp?L=F would activate the French language version.
The language codes are available in the table FND_INSTALLED_LANGUAGES.
If you do not specify a language code, the default (US) is used

10. Configure the web pages for iRecruitment
You configure the web page layout using the Personalization Framework. If applicable, configure flexfields, instructions and tips, and the delivered logos.