Home » RDBMS Server » Server Administration » Setting environmental variable for SID failed (oracle 12c - Windows server 2012)
Setting environmental variable for SID failed [message #635348] Fri, 27 March 2015 05:18 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #635350 is a reply to message #635348] Fri, 27 March 2015 06:10 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Is the Windows service OracleService<sid_name> running?
Re: Setting environmental variable for SID failed [message #635357 is a reply to message #635348] Fri, 27 March 2015 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also feedback to your previous topics, in most of them we are waiting for you.
We expect you'll do it before your next question as well as you do it in this one.

[Updated on: Fri, 27 March 2015 11:10]

Report message to a moderator

Re: Setting environmental variable for SID failed [message #635429 is a reply to message #635357] Mon, 30 March 2015 03:28 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Why I am not replying for some of the posts are either "I got answer from the post" or "The post, long lasting forever, where post was requiring immediate solution, but haven't got".

Thanks and Regards
Muktha
Re: Setting environmental variable for SID failed [message #635431 is a reply to message #635429] Mon, 30 March 2015 03:34 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
muktha_22 wrote on Mon, 30 March 2015 03:28
Hi 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.
Previous Topic: schema stats
Next Topic: How to upgrade time zone binaries
Goto Forum:
  


Current Time: Fri Mar 29 05:30:33 CDT 2024