Can't login using sqlplus [message #511369] |
Sun, 12 June 2011 07:48 |
|
gruszczy
Messages: 7 Registered: June 2011
|
Junior Member |
|
|
When I run sqlplus and try to loging as system/<admin passwd> I get information:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
I understand, that this is a common question and the common answer is don't have trailing slash in ORACLE_HOME and set ORACLE_SID. But I did this.
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=XE
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
What else I might be doing wrong?
|
|
|
|
|
Re: Can't login using sqlplus [message #511390 is a reply to message #511373] |
Sun, 12 June 2011 10:49 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Inside my application I have 'Start Database' application, with which I assume I start the database.
WE can't assume that.
Copy and paste:
sqlplus / as sysdba
alter session set nls_date_format='DD/MM/YYYY HH24:MI:SS';
select name, open_mode, database_role from v$database;
select instance_name, startup_time, status, logins, database_status, active_state from v$instance;
Regards
Michel
|
|
|
|
|
|
Re: Can't login using sqlplus [message #511399 is a reply to message #511396] |
Sun, 12 June 2011 11:46 |
|
gruszczy
Messages: 7 Registered: June 2011
|
Junior Member |
|
|
Ok, that pushed me a little forward. First I got information about wrong configuration, that it can't connect to HOST=gruszczy-laptop. I couldn't find this entry and change it to localhost, so I edited my /etc/hosts and added gruszczy-laptop there. This helped a little. This is what I got:
SQL> startup
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2230776 bytes
Variable Size 222299656 bytes
Database Buffers 574619648 bytes
Redo Buffers 2551808 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> alter session set nls_date_format='DD/MM/YYYY HH24:MI:SS';
Session altered.
SQL> select name, open_mode, database_role from v$database;
select name, open_mode, database_role from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
Now when I try to use sqlplus from my usual account I get: ORA-01033: ORACLE initialization or shutdown in progress
I understand that mounting is a normal step of starting database and it must have failed with this error: ORA-00205: error in identifying control file, check alert log for more info. That's why I don't get proper information.
I have checked /u01/app/oracle/diag/rdbms/xe/XE/alert/log.xml and got this:
<msg time='2011-06-12T18:37:48.618+02:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='gruszczy-laptop' host_addr='127.0.0.1' module=''
pid='2495'>
<txt>ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/XE/control.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
</txt>
<msg time='2011-06-12T18:37:48.805+02:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3036:2780954927' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='gruszczy-laptop'
host_addr='127.0.0.1' module='sqlplus@gruszczy-laptop (TNS V1-V3)' pid='2514'>
<txt>ORA-205 signalled during: ALTER DATABASE MOUNT...
</txt>
</msg>
But this tells me nothing.
|
|
|
|
|
|
|
|