Search This Blog

Wednesday, 4 September 2013

Error while connecting to Database

[rjkm@slc01mmi dbhome_1]$ sqlplus / as sysdba

 SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 1 12:34:23 2013

 Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 Connected to an idle instance.

 SQL> CREATE TABLESPACE INFA_901_TS

       DATAFILE '/scratch/rjkm/app/oradata/OBIAPPS/INFA_901_TS.dbf'

       SIZE 1024M

       EXTENT MANAGEMENT LOCAL AUTOALLOCATE;  2    3    4

     CREATE TABLESPACE INFA_901_TS

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

 [rjkm@slc01mmi dbhome_1]$ lsnrctl start

 LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-SEP-2013 12:38:00

 Copyright (c) 1991, 2011, Oracle.  All rights reserved.

 Starting /scratch/rjkm/app/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

 TNSLSNR for Linux: Version 11.2.0.3.0 - Production

System parameter file is /scratch/rjkm/app/product/11.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /scratch/rjkm/app/diag/tnslsnr/slc01mmi/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                01-SEP-2013 12:38:02

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /scratch/rjkm/app/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /scratch/rjkm/app/diag/tnslsnr/slc01mmi/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

The listener supports no services

The command completed successfully

[rjkm@slc01mmi dbhome_1]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 1 12:41:00 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1820540928 bytes

Fixed Size                  2229304 bytes

Variable Size             469765064 bytes

Database Buffers         1342177280 bytes

Redo Buffers                6369280 bytes

Database mounted.

Database opened.

SQL> conn infa901/infa901

Connected.

SQL>

No comments:

Post a Comment