日期:2014-05-16  浏览次数:20444 次

手工启动oracle EM Dbconsole 切换sid数据库(转)

http://blog.sina.com.cn/s/blog_470504830100yuhj.html

oracle@linux:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:44:14 2012

?

?

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE????11.2.0.1.0??????Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> quit
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@tbslinux:~> emca -config dbcontrol db

STARTED EMCA at Jan 5, 2012 9:49:10 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.??All rights reserved.

Enter the following information:
Database SID: ticket
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/product/11g/db_1 ]:
Password for SYS user:?
Password for DBSNMP user:?
Password for SYSMAN user:?
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------