DB CLONE

26/04/2014

Q) How to check how many databases are up and running in a server?

A) ps -ef |grep pmon

24/04/2014

Hi All,

We are going to start the New Oracle DBA Batch Shortly, with Real Time Scenarios. if any one is interested in attending the Classes then let me know.

22/04/2014

Q) Where All Oracle Homes and Oracle SID information is available?

A) /etc/oratab

22/04/2014

Q) In which file Oracle Inventory Information is available?

A) /etc/OraInst.loc

20/04/2014

Q) Where do you get to know the Information of your Oracle Software and the Version?

A) From the View v$version (field is banner).

18/04/2014

Q) You have just had to restore from backup and do not have any control files. How would you go about
bringing up this database?

A) I would create a text based backup control file, stipulating where on disk all the data files where and then issue the
recover command with the using backup control file clause.

17/04/2014

Oracle DBA Responsibilities are:
-------------------------------

(1) Creates and maintains all databases required for development, testing,
education and production usage.

(2) Performs the capacity planning required to create and maintain the
databases.

(3) Performs ongoing tuning of the database instances.

(4) Install new versions of the Oracle RDBMS and its tools and any other tools
that access the Oracle database.

(5) Plans and implements backup and recovery of the Oracle database.

(6) Controls migrations of programs, database changes, reference data changes
and menu changes through the development life cycle.

(7) Implements security for all of the Oracle Databases.

(8) Performs database re-organisations as required to assist performance and
ensure maximum uptime of the database.

(9) The DBA will perform reviews on the design and code frequently to ensure the site standards are
being adhered to.

(10) Evaluates releases of Oracle and its tools, and third party products to
ensure that the site is running the products that are most appropriate.
Planning is also performed by the DBA, along with the application developers
and System administrators, to ensure that any new product usage or release
upgrade takes place with minimal impact.

(11) Provides technical support to application development teams. This is
usually in the form of a help desk. The DBA is usually the point of contact
for Oracle Corporation.

(12) Enforces and maintains database contraints to ensure integrity of the
database.

(13) Administers all database objects, including tables, clusters, indexes,
views, sequences, packages and procedures.

(14) Assists with impact analysis of any changes made to the database objects.

(15) Troubleshoots with problems regarding the databases, applications and
development tools.

(16) Create new database users as required.

(17) Manage sharing of resources amongst applications.

(18) The DBA has ultimate responsibility for the physical database design.

16/04/2014

What the DBA Should have?

-----> The DBA should posses the following skills like:

(1) A good knowledge of the Operating System(s)

(2) A good knowledge of Physical Database Design

(3) Ability to perform both Oracle and also operating system performance monitoring and the necessary adjustments.

(4) Excellent knowledge of Oracle backup and recovery scenarios.

(5) Good skills in all Oracle tools.

Thats what we Guarantee in our Teaching.

15/04/2014

Today's Information is here:

Difference Between Oracle DBA & Oracle Developer are:

ORACLE DBA:
---------------

1) DBA's job is to manage the server related activities, like administration job
2) DBA is Dealing with the backend(Background Processes, how the data is Fetching and Modifying)
3) Oracle DBA means it is used to maintain the data base and manage the database.
4) In which We are studying about SQL ,Creating Database ,Analaying and Performance Tuning and Data Recovery.
5) DBA is developer + having extra right on Database(He is the owner of database)
6) DBA takes care of instance health and also takes care of Security/Access related issues, Unix Environment Set-up etc

Oracle Developer:
--------------------

1) Developers are supposed to work on SQL & PL/SQL(Write Coding).
2) Developers are used to Join the database backend to frontend by using trigger procedure etc..
3) Oracle developer means oracle programs using to develop the project.
4) Here We studying about Programming and Oracle FORM Deseging GUI (graphical user interface)
5) Developer is having limited access on DB
6) Oracle developer works for coding, testing, maintainnace & enhancements jobs.

14/04/2014

Today's information is here:

What is DBA?

A DBA is a Database Administrator, and this is the most common job that you find a database specialist doing.
There are Development DBAs and Production DBAs.

A Development DBA usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL.
That can be satisfying at a human level because you are part of a team and you share the satisfaction of the team's accomplishments.

A Production DBA (on the other hand) is responsible for maintaining Databases within an organisation, so it is a very demanding job. He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running.
Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction. But it's a more challenging job than being a Development DBA.

14/04/2014

Hey all, from today onwards we are going to post ORACLE DBA information/queries in this page. If you have any queries you can share it here....

14/04/2014

Our new page...
share this.. :)

DB CLONE TECHNOLOGIES
"Feel The Difference in Teaching and become an Expert"