| Setting environmental variable for SID failed [message #635348] |
Fri, 27 March 2015 05:18  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
Hope all is well,
Need some guidance,
When we set environmental variable as SET ORACLE_SID=<sid name> in a live production server, it returns error of TNS:Protocol adapter error.
But, we have already setup in registry.
Tried of setting in windows OS level Environment Variable tab.
All are failed.
Kindly suggest
Muktha
|
|
|
|
| Re: Setting environmental variable for SID failed [message #635349 is a reply to message #635348] |
Fri, 27 March 2015 05:21  |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I suggest that you show what you are doing. Like this:
C:\Users\john>
C:\Users\john>sc query OracleServiceORCLZ
SERVICE_NAME: OracleServiceORCLZ
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
C:\Users\john>
C:\Users\john>set ORACLE_SID=orclz
C:\Users\john>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 27 10:20:43 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
orclz>
|
|
|
|
|
|
|
|
|
|
| Re: Setting environmental variable for SID failed [message #635431 is a reply to message #635429] |
Mon, 30 March 2015 03:34 |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
So which of those two reasons explains your failure to reply to me or to gazzag in this topic?
Really, Muktha, you do need to consider your attitude. Have you ever wondered your your work mates dont like helping you? Or why you don't get bigger pay rises?
|
|
|
|
| Re: Setting environmental variable for SID failed [message #635442 is a reply to message #635429] |
Mon, 30 March 2015 06:44 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
muktha_22 wrote on Mon, 30 March 2015 03:28Hi Michel,
where post was requiring immediate solution, but haven't got".
Thanks and Regards
Muktha
This is a forum of peer volunteers. Nothing here requires immediate solution. If you need "immediate" solution, you need to open a SEV-1 SR with Oracle Support.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
