>
> Hi Ari,
>
> I am a D2K programmer. I am facing following problem.
> I request you to help me to solve the following problem.
> Environment
> -----------
>
> Unix Server = HP-UX 9000
> ORACLE SOFTWARE = ORACLE 7.3
>
> Clients = (Windows 95) Forms 4.5
>
>
> The problem is as follows.
>
> If I connect from ORACLE_HOME
> sqlplus scott/tiger ,
> then
> Oracle allows me to connect .
>
> If I try to connect from other dir, then I can not connect.
>
> Following Errors are displayed on the screen.
>
> ORA- 07320 Shmat error when trying to attach SGA.
> ORA- 01034 Oracle not available
> HP-UX ERROR 13 Permission denied.
>
>
> If log in as different Unix username and if I give following command
>
> $ sqlplus scott/tiger
>
> then Oracle allows me to connect.
>
> Earlier, till yesterday, if I give command without giving connect string
> , Oracle was allowing me to connect to Oracle on HP server.
>
> I am confused. What do you thing has gone wrong.
>
> Please help me to solve this problem.
>
> BYE
> PRASHANT
Make sure that the PATH environment variable is set correctly. If that
does not help, then type "env" for both the userid that works and
the usreid that does not. Look at the differences between the two
and see if any have an effect. If that fails, make sure that the Unix
group of the two users are the same; it could be that one user does
not have permissions to the Oracle executables.
When all fails, look at the listener.ora file in $ORACLE_HOME/network/admin.
If the read permissions are not there for world, you will get a similar
permission problem.
Best of luck!
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page