Re: Please Help

1 This is a file protection problem. Basically all files should have 4755, and the Oracle executable the suid bit set. The other reason I have seen is on an installation using NIS where the NIS guid and uid differed from the local guid and uid of all files. It worked as long as NIS was not running.

2
Are you running the Oracle Intelligent Agent by any chance? You'll need to stop that before the shutdown.
OIA will run two processes with the dbsnmp.exe executable.

Hth,

Sybrand Bakker, Oracle DBA

"cc" <zhangc_at_netcom.ca> wrote in message news:_q375.17704$qS3.44315_at_tor-nn1.netcom.ca...
> I'va two questions:
>
> 1) 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?
>
> 2) 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