oracle 을 다시깔려고 생각하다가 문득 생각난게 있어서. $ORACLE_HOME을 전부 tar로 말았습니다. 그리고 지우고. 황급히 다시 tar를 풀었습니다.
그리고 software upgrade? 를 했는데요.
oracle 계정으로 해서는 sqlplus를 잘 쓰는데요. 딴 계정으로는 sqlplus로 접속할 수가 없습니다.
ERROR:
ORA-01034: ORACLE not available
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
// - The SGA requires more space than was allocated for it.
// - The operating-system variable pointing to the instance is
// improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
// the problem mentioned in the other messages.
// If Oracle has been initialized, then on some operating systems,
// verify that Oracle was linked correctly. See the platform
// specific Oracle documentation.
이렇게 나옵니다. 이유가 몰까요? 계속 잘 쓰고 있었거든요.
|