oracle 11g启动双实例

[oracle@imagehost ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 23-OCT-2015 15:25:29

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=imagehost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@imagehost ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 23-OCT-2015 15:25:37

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

Starting /u01/app/oracle/product/11g/db_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.1.0 – Production
System parameter file is /u01/app/oracle/product/11g/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/imagehost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=imagehost)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=imagehost)(PORT=1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 – Production
Start Date                23-OCT-2015 15:25:37
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11g/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/imagehost/listener/alert/log.xml
Listening Endpoints Summary…
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=imagehost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@imagehost ~]$ echo $ORACLE_SID
orcl
[oracle@imagehost ~]$ conn / as sysdba
bash: conn: command not found
[oracle@imagehost ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 23 15:27:49 2015

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

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  492707840 bytes
Fixed Size                  2214656 bytes
Variable Size             411043072 bytes
Database Buffers           71303168 bytes
Redo Buffers                8146944 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@imagehost ~]$ export ORACLE_SID=test2
[oracle@imagehost ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 23 15:29:31 2015

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 2488635392 bytes
Fixed Size                  2215904 bytes
Variable Size            1560281120 bytes
Database Buffers          905969664 bytes
Redo Buffers               20168704 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@imagehost ~]$ echo $ORACLE_SID
test2
[oracle@imagehost ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 23-OCT-2015 15:31:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=imagehost)(PORT=1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 – Production
Start Date                23-OCT-2015 15:25:37
Uptime                    0 days 0 hr. 5 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11g/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/imagehost/listener/alert/log.xml
Listening Endpoints Summary…
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=imagehost)(PORT=1521)))
Services Summary…
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service…
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service…
Service "test2" has 1 instance(s).
  Instance "test2", status READY, has 1 handler(s) for this service…
Service "test2XDB" has 1 instance(s).
  Instance "test2", status READY, has 1 handler(s) for this service…
The command completed successfully

声明: 除非转自他站（如有侵权，请联系处理）外，本文采用 BY-NC-SA 协议进行授权 | 嗅谱网
转载请注明：转自《oracle 11g启动双实例》
本文地址：http://www.xiupu.net/archives-5023.html
关注公众号：