[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