[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

echosid

for windows

echo %ORACLE_SID%

What is equivalence in Sunsolaris or Windows.
0
jeevan mathew
Asked:
jeevan mathew
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
Unix and variations:
echo $ORACLE_SID

To set it:
export ORACLE_SID=ORCL

where ORCL is the correct SID.

I don't understand the second half  " or Windows"
0
 
jeevan mathewdbaAuthor Commented:
yes it was a mistake please ignore windows.

Thank you.
0
 
johnsoneSenior Oracle DBACommented:
To clear up something, setting the ORACLE_SID in Unix variants does depend on the variant and which shell you are using.  This command:

export ORACLE_SID=ORCL

should work in most cases, but will not work in all cases.

Any system where you are using a true Bourne shell, that will not work, you would be required to do this:

ORACLE_SID=ORCL
export ORACLE_SID

Also, if you are using csh or one of its variants, the command would be different as well.  Not many people use that one anymore, but it is different.
0
 
jeevan mathewdbaAuthor Commented:
Compared.
instance information in windows and linux.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now