N/APosted 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?
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.