I'va two questions:
- 7.3.4 on Unix, I've ORACLE_SID set in the environment. I can't use
"sqlplus uname/passwd" to connect database, I got "ERROR: ORA-01034: ORACLE
not available", and some OS error "permission denied". There is no other
instance on the box. But both "sqlplus uname/passwd@$ORACLE_SID" and
"sqlplus uname/passwd_at_sid" works fine. Further I found if I login in as
oracle with the same ORACLE_SID setting, "sqlplus uname/passwd" works fine
too. What is the problem, I mean as long as ORACLE_SID is set, "sqlplus
uname/passwd" should works to any user, right?
- I had this several times: after I issue "shutdown" (normal) database in
svrmgrl on UNIX, I recognized there are still connections to the database.
So basically the shutdown will hanging there. The problem is no more new
connection can be made since the shutdown is in process. On NT, I can stop
Oracle service to solve this problem. But what shoild I do on Unix? Kill the
process one by one? Some times we just re-boot the box but this obviously
not a right solution.
Any help will be appreciated.
Received on Fri Jun 30 2000 - 00:00:00 CDT