?
Solved

ORA-12505 ENVIRONMENT VARIABLE ORACLE_SID not defined

Posted on 2004-11-11
2
Medium Priority
?
1,868 Views
Last Modified: 2012-05-05
hi when I try and use svrmgr at the dos prompt
set oracle_sid kpip1
I get
ORA-12505 ENVIRONMENT VARIABLE ORACLE_SID not defined

any idea how i define the variable

(it was previously defined but my db crashed)
0
Comment
Question by:joehodge
2 Comments
 
LVL 6

Accepted Solution

by:
chedgey earned 2000 total points
ID: 12556516
Is not the syntax:

Set ORACLE_SID=kpip1

Regards

Chedgey
0
 

Author Comment

by:joehodge
ID: 12556706
spot on!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month16 days, 6 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question