Service_Name is the Db_name + db_domain. It is used by the instance for
atomatic registration to the listener ...
SID is the System Identifier which uniquely identifies your Instance. This
is used in unix to get a Memory Area.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax
What's with the Service_name? vs. SID?
On Tuesday 30 April 2002 18:03, you wrote:
> ORACLE_HOME + ORACLE_SID together uniquely identify an instance.
>
> Anjo.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services
ORACLE_HOME + ORACLE_SID together uniquely identify an instance.
Anjo.
"Vergara, Michael (TEM)" wrote:
> I've seen this happen in the following circumstance:
>
> Log in as oracle owner. svrmgrl -> startup -> exit.
> Log out. The instance is running.
>
> Now log in as another user who is a me
I've seen this happen in the following circumstance:
Log in as oracle owner. svrmgrl -> startup -> exit.
Log out. The instance is running.
Now log in as another user who is a member of the dba
group. svrmgrl -> startup -> exit. Do a ps -ef.
You will see two instances running.
Been there. O
Raj - I believe I've seen this sometime ago. It is like a set of processes
have no connection like normal. You'll probably have to kill those processes
manually before you restart the instance.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April
Hi
This could happen if you have Oracle installed twice on the box.
The same SID could be started up from each of the binaries.
Ben
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
Hello Folks,
I was teaching DBA stu