OraFAQ Forum: Server Administration » Setting environmental variable for SID failed

Home » RDBMS Server » Server Administration » Setting environmental variable for SID failed (oracle 12c - Windows server 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Setting environmental variable for SID failed [message #635349 is a reply to message #635348]

Fri, 27 March 2015 05:21

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

I suggest that you show what you are doing. Like this:

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Setting environmental variable for SID failed [message #635350 is a reply to message #635348]

Fri, 27 March 2015 06:10

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Is the Windows service OracleService<sid_name> running?

Report message to a moderator

Re: Setting environmental variable for SID failed [message #635357 is a reply to message #635348]

Fri, 27 March 2015 11:09

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: Setting environmental variable for SID failed [message #635431 is a reply to message #635429]

Mon, 30 March 2015 03:34

John Watson
Messages: 8976
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?

Report message to a moderator

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: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.

Report message to a moderator

Previous Topic:	schema stats
Next Topic:	How to upgrade time zone binaries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 18:55:58 CDT 2025