|
|
|
|
| Re: Oracle Database Connection Error [message #578863 is a reply to message #578861] |
Tue, 05 March 2013 23:25   |
 |
swathi.shilpa
Messages: 8
Registered: March 2013
|
Junior Member |
|
|
Attaching the screen output from terminal
**File1:"output"...This is taken when am connected as user where am getting the error
acgx0456>$ echo $ORACLE_SID
ac2e
acgx0456>$ sqlplus /
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 5 16:28:49 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument
Additional information: 1
Additional information: 12
Enter user-name:
When am connected as oracle user,i can login to database.Database is up and running .From this user also,till last day,its connected,but now error throwing out.
-
Attachment: output.txt
(Size: 6.54KB, Downloaded 1819 times)
[Updated on: Tue, 05 March 2013 23:31] Report message to a moderator |
|
|
|
|
|
| Re: Oracle Database Connection Error [message #578916 is a reply to message #578875] |
Wed, 06 March 2013 06:18 |
|
swathi.shilpa
Messages: 8
Registered: March 2013
|
Junior Member |
|
|
When am trying
sqlplus
/ as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
HP-UX Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
HP-UX Error: 13: Permission denied
Additional information: 9925
*********************************************
I can login this DB when am connected as oracle user.But from this user(aed) i connected successfully till last day as "sqlplus /" .
As oracle USer:-
acgx0456:ac2e:oracle>$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0
acgx0456:ac2e:oracle>$ echo $ORACLE_SID
ac2e
acgx0456:ac2e:oracle>$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 5 23:54:15 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
ac2e READ WRITE
SQL> exit
[Updated on: Wed, 06 March 2013 06:37] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Database Connection Error [message #578960 is a reply to message #578948] |
Wed, 06 March 2013 11:08 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
In the same window:
id
env | sort | egrep 'ORA|TNS|LIB|PATH'
sqlplus /
Then in another window with oracle user:
id
env | sort | egrep 'ORA|TNS|LIB|PATH'
sqlplus / as sysdba
select instance_name, name from v$instance, v$database;
select * from v$version;
select username, password from dba_users where username like '%AED%';
select value from v$parameter where name='os_authent_prefix';
(Note: this is just to use the same account than previously in the topic otherwise SYS/SYSDBA should not be used to do these commands.)
Regards
Michel
[Updated on: Wed, 06 March 2013 11:09] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Oracle Database Connection Error [message #579005 is a reply to message #578992] |
Thu, 07 March 2013 00:34 |
|
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Please let us sleep from time to time.
ORA-27123: unable to attach to shared memory segment
*Cause: shmat() call failed
*Action: check permissions on segment, contact Oracle support
From oracle account:
ls -l $ORACLE_HOME/bin/sqlplus
ipcs -m
Regards
Michel
[Updated on: Thu, 07 March 2013 00:36] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
