Home » RDBMS Server » Server Administration » difference
difference [message #218810] Sat, 10 February 2007 11:24 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
I am setting ORACLE_SID entry in registry and PATH!!! what is the difference? do we need to set the oracle_sid in both places?

Thanks.
Re: difference [message #218816 is a reply to message #218810] Sat, 10 February 2007 14:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Setting the ORACLE_SID in the PATH variable won't do you any good. ORACLE_SID is it's own environment variable. If you set ORACLE_SID as an environment variable it will take precedence over the registry value.
Re: difference [message #218905 is a reply to message #218816] Sun, 11 February 2007 23:45 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
I don't think the variable ORACLE_SID will set audomatically! I installed oracle software alone, when i try to query

sqlplus "/as sysdba"

it is not going, unless i specify set ORACLE_SID=<any name>

By the way what is the use of oracleservice<sid>??

oradim -new -sid <oracle sid> -startmode -m
or
net start oracleservice<sid> /* if service is already created */

Thanks.
Re: difference [message #218911 is a reply to message #218905] Mon, 12 February 2007 00:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

sqlplus "/as sysdba"

it is not going,

Are you getting any error.
E:\>sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Feb 12 09:54:10 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

Make sure in sqlnet.ora >>>SQLNET.AUTHENTICATION_SERVICES= (NTS)<<< or os user member of ORA_DBA group.

I don't think the variable ORACLE_SID will set audomatically
if you have more than one database on some machine then you have to first set ORACLE_SID or use @tns_entry TO POINT which database you want to connect.
consider
i have to database on some machine >>>TAJ , ORCL<<<<
without tnsentry or oracle_sid parameters set i am connect new created database ( IS TAJ) but if i want to connect ORCL i have to set oracle_sid OR use @tnsentry with connect string.
E:\>sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Feb 12 09:58:54 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      Taj
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

E:\>set oracle_sid=ORCL

E:\>sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Feb 12 09:59:10 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      orcl
SQL>

You can also use SET INSTANCE instance_name COMMAND on sql prompt to SET INSTANCE_NAME.but first you have to disconn from current instance.

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      orcl
SQL> disconn
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
SQL> set INSTANCE TAJ
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn system/oracle
Connected.
SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      Taj
SQL>



oracleservice<sid>??
ORADIM is utility to CREATE ORACLE SERVICES.
it is point to Oracle Service.
net start OracleSerivce<sid> for start services.
net stop OracleServices<sid> for stop services.

regards
Taj

[Updated on: Mon, 12 February 2007 00:08]

Report message to a moderator

Re: difference [message #235856 is a reply to message #218911] Tue, 08 May 2007 03:10 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Taj.
Is there any difference b/w setting ORACLE_SID as environmental variable and registry???

Thanks.
Re: difference [message #235886 is a reply to message #235856] Tue, 08 May 2007 04:49 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
>>By the way what is the use of oracleservice<sid>??
Adding to Taj's reply.. In WIndows operating system,for any process to run in background, there should be service created.That is what you do with ORADIM utility.
You can see even for listener ,there is a service created.
Go to run > type services.msc >hit enter
Re: difference [message #236065 is a reply to message #235886] Tue, 08 May 2007 23:27 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks for some more information.

What exactly oracleservice doing? As you said is it mantadory to create ( if not available) and start the service for running background jobs?
In windows is it possible to see how many processes are running?

Thanks.
Previous Topic: execute a job every x minutes
Next Topic: oracle 9i problem
Goto Forum:
  


Current Time: Sat Dec 10 06:59:06 CST 2016

Total time taken to generate the page: 0.04379 seconds