we are having a test server in bank environment. Details:
IBM p series servers
Server memory : 16G
there are 2 instances on this server.
1. Near DR - 9840M
2. Test server - 1344M
Rest is for server.
Oracle 10.2.0.3.0 - Production
2 days ago we are running a stored procedure on this test server. After some time DB gave this error and stored procedure stopped.
After that we were unable to login through Oracle Client Software. Whenever we try to login to this DB through client software, it gives following errors. ERROR: ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment IBM AIX RISC System /6000 Error: 13: Permission denied
We tried to shut the DR database and then login but still gives error..
Please help me out.
Thanks in advance..
Most of the links suggests that permissions on oracle file may be changed.
we tried that also..
tried to change the permissions to 6751..but no results..
Our DB is running properly. But only problem is we are unable to login from client..
Yes the DB is running.
when i fire this query, the results are coming..
SQL> select open_mode from v$database;
SQL> select STATUS from v$instance;
Edited by: Dipak Kalamkar on Oct 11, 2012 3:01 PM