Problem while making down oracle instances

Asked By tommy j 0 points N/A Posted on - 07/01/2011

I am an employee working in a small company for Unix DBA support. We used to shutdown the Unix services and instances. When I try to shut down oracle instances, I am getting an error as “ORACLE_SID=FLEXCJ: is not an identifier”. Can anyone check the attached screenshots and guide me in rectifying the error?

• Status: Open
• Question Views: 1780
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By stephen gh 210 points N/A #127380

Problem while making down oracle instances

 

In Unix, we use some shell programming like C shell, Korn shell or maybe Sash shell. So we need to know which shell we are using. Screen shots provided by you shows two oracle databases, one is ora11gR2 and other is ora10gR2. So when you give the command Su – (database name), it should go inside that particulars database. So after going inside that particulars’ database, then give the command only when you see in which shell you are using like bash shell. So type the command “bash” so that it will be inside the shell prompt. Once you are able to see the bash prompt, give the command “export ORACLE_SID=FLEXCJ”. Once you had given the command, you won't get any error, I am attaching screenshots for your reference so check it. 

About stephen gh

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/01/2011
• Question Category: MySQL Server