difference [message #218810] |
Sat, 10 February 2007 11:24  |
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 #218905 is a reply to message #218816] |
Sun, 11 February 2007 23:45   |
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   |
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   |
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   |
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  |
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.
|
|
|