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.

이렇게 나옵니다. 이유가 몰까요? 계속 잘 쓰고 있었거든요.