mail-question wrote:
QUOTE:
Thank you very much.
I've no Oracle Client.So I'm trying to use TCP/IP direct connection.
How can I get Oracle instance name?Can you explain this?
I gave Login as my login ID,password as my password, and IP as my system IP address.
But I confused at oracle instance name.
Thanks and Regards ,
Sujatha
In this case you need the name of the ORACLE database.
The technical anwser about Oracle Instance :
Overview of an Oracle Instance
Every running Oracle database is associated with an Oracle instance. When a
database is started on a database server (regardless of the type of computer),
Oracle allocates a memory area called the System Global Area (SGA) and starts
one or more Oracle processes. This combination of the SGA and the Oracle
processes is called an Oracle instance. The memory and processes of an instance
manage the associated database’s data efficiently and serve the one or multiple
users of the database.
The Instance and the Database
After starting an instance, Oracle associates the instance with the specified
database. This is called mounting the database. The database is then ready to be
opened, which makes it accessible to authorized users.
Multiple instances can execute concurrently on the same computer, each accessing
its own physical database. In clustered and massively parallel systems (MPP),
the Oracle Parallel Server allows multiple instances to mount a single database.
Only the database administrator can start up an instance and open the database.
If a database is open, the database administrator can shut down the database so
that it is closed. When a database is closed, users cannot access the
information that it contains.
Security for database startup and shutdown is controlled via connections to
Oracle with administrator privileges. Normal users do not have control over the
current status of an Oracle database.
Regards,
Peter
