Home » RDBMS Server » Enterprise Manager » Oracle Instance
Oracle Instance [message #162253] Thu, 09 March 2006 07:13 Go to next message
chemengr
Messages: 1
Registered: March 2006
Junior Member
Hi,
I have a few querries regarding an Oracle Instance.
1)Is it same as a databse?
2)WHat is the exact hierarchy among instances,databases,schema and objects?
3)How to create an Oracle Instance in my computer?
For the 3rd question,I actually got a set of commands from the net.But im not sure from where to execute them & also not sure if they answer my question.
Here are the commands :
CONNECT SYS AS SYSDBA;
ALTER SYSTEM SET DB_CREATE_FILE_DEST = ‘/u01/oradata/’;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1=’ /u02/oradata/’;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2=’ /u03/oradata/’;
CREATE DATABASE;
Kindly help.
Thank You.
Regards,
Kailash.
Re: Oracle Instance [message #162278 is a reply to message #162253] Thu, 09 March 2006 09:10 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
1) Oracle Instance is the term, which means processes Oracle in the RAM of server which are provide access to the dates. Oracle database mean datafiles, which are on the disk, where are placed dates.
2)In general for one database can exist one or more instances, but one instance can server only one database.In general schema means a set of object that owns by some user - for example shema of user AAA is objects owned by AAA.
3) How to create instance or database very much depends of paltform on which You want to create them.
Previous Topic: Event test faiure
Next Topic: Report of Top Sql not in the required format in OEM.
Goto Forum:
  


Current Time: Fri Mar 29 00:28:50 CDT 2024