Linux下的启动oracle的EM的命令

Linux下的启动oracle的EM的命令

1.启动数据库

su - oracle
$sqlplus / as sysdba
sql>startup

2.启动监听

$lsnrctl
LSNRCTL>start

3.启动EM

$emctl start dbconsole

4：操作示例： 因为我不知道我的数据库示例是否已经启动了。于是下面示例是重启了数据库，查看了监听是否已经启动

[oracle@localhost ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 3 15:24:51 2018

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


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

SYS@orcl> startup force
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1221992448 bytes
Fixed Size                  1344596 bytes
Variable Size             939527084 bytes
Database Buffers          268435456 bytes
Redo Buffers               12685312 bytes
Database mounted.
Database opened.
SYS@orcl> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-APR-2018 15:25:46

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                27-MAR-2018 21:12:41
Uptime                    6 days 18 hr. 13 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
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...
The command completed successfully
LSNRCTL> quit
[oracle@localhost ~]$ emctl start dbconsole;
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://localhost.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ....... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_orcl/sysman/log
[oracle@localhost ~]$ cat  /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_orcl/sysman/log
cat: /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_orcl/sysman/log: Is a directory
[oracle@localhost ~]$ cd /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_orcl/sysman/log
[oracle@localhost log]$ ls
emagentfetchlet.log  emagent.log       emagent.trc  emdctl.log  emoms.log  nfsPatchPlug.log  patchAgtStPlugin.log
emagentfetchlet.trc  emagent_perl.trc  emdb.nohup   emdctl.trc  emoms.trc  pafLogs           secure.log
[oracle@localhost log]$ cat emagent.log
2016-11-30 03:45:56,404 Thread-3040471936 Starting Agent 10.2.0.4.4 from /u01/app/oracle/product/11.2.0/db_1 (00701)
2016-11-30 03:45:59,914 Thread-3040471936 Undefined column name __intervalONNECT_DATA in expression ((gc_cr_recv < _gc_cr_recv) ? 0 : (gc_cr_recv - _gc_cr_recv))/__intervalONNECT_DATA=(SID=%SID%)))
             (00104)
2016-11-30 03:45:59,914 Thread-3040471936 Undefined column name __intervalCT_DATA in expression ((gc_cur_recv < _gc_cur_recv) ? 0 : (gc_cur_recv - _gc_cur_recv))/__intervalCT_DATA=(SID=%SID%)))
             (00104)
2016-11-30 03:45:59,914 Thread-3040471936 Undefined column name __intervalrvalCT_DATA in expression ((gc_cr_serv < _gc_cr_serv) ? 0 : (gc_cr_serv - _gc_cr_serv))/__intervalrvalCT_DATA=(SID=%SID%)))
             (00104)
2016-11-30 03:45:59,914 Thread-3040471936 Undefined column name __intervalCT_DATA in expression ((gc_cur_serv < _gc_cur_serv) ? 0 : (gc_cur_serv - _gc_cur_serv))/__intervalCT_DATA=(SID=%SID%)))
             (00104)
2016-11-30 03:45:59,914 Thread-3040471936 Undefined column name __intervalATA in expression ((msg_sent_dir < _msg_sent_dir) ? 0 : (msg_sent_dir - _msg_sent_dir))/__intervalATA=(SID=%SID%)))
             (00104)
2016-11-30 03:45:59,914 Thread-3040471936 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/__intervalinterval=%SID%)))
             (00104)
2016-11-30 03:46:00,457 Thread-3040471936 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
2016-11-30 03:46:03,365 Thread-3040471936 EMAgent started successfully (00702)
2018-04-03 15:26:15,247 Thread-3040008400 Starting Agent 10.2.0.4.4 from /u01/app/oracle/product/11.2.0/db_1 (00701)
2018-04-03 15:26:16,791 Thread-3040008400 Undefined column name __intervalONNECT_DATA in expression ((gc_cr_recv < _gc_cr_recv) ? 0 : (gc_cr_recv - _gc_cr_recv))/__intervalONNECT_DATA=(SID=%SID%)))
             (00104)
2018-04-03 15:26:16,791 Thread-3040008400 Undefined column name __intervalCT_DATA in expression ((gc_cur_recv < _gc_cur_recv) ? 0 : (gc_cur_recv - _gc_cur_recv))/__intervalCT_DATA=(SID=%SID%)))
             (00104)
2018-04-03 15:26:16,791 Thread-3040008400 Undefined column name __intervalrvalCT_DATA in expression ((gc_cr_serv < _gc_cr_serv) ? 0 : (gc_cr_serv - _gc_cr_serv))/__intervalrvalCT_DATA=(SID=%SID%)))
             (00104)
2018-04-03 15:26:16,791 Thread-3040008400 Undefined column name __intervalCT_DATA in expression ((gc_cur_serv < _gc_cur_serv) ? 0 : (gc_cur_serv - _gc_cur_serv))/__intervalCT_DATA=(SID=%SID%)))
             (00104)
2018-04-03 15:26:16,791 Thread-3040008400 Undefined column name __intervalATA in expression ((msg_sent_dir < _msg_sent_dir) ? 0 : (msg_sent_dir - _msg_sent_dir))/__intervalATA=(SID=%SID%)))
             (00104)
2018-04-03 15:26:16,791 Thread-3040008400 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/__intervalinterval=%SID%)))
             (00104)
2018-04-03 15:26:17,203 Thread-3040008400 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
2018-04-03 15:26:21,110 Thread-3040008400 EMAgent started successfully (00702)
[oracle@localhost log]$

本地访问地址：https://localhost:1158/em/console/aboutApplication