一、Stopping Grid Control and All Its Components 1.停止OMS服务 [oracle@ocm2 oms10g]$ cd /u01/app/oracle/OracleHomes/oms10g/bin/ [oracle@ocm2 bin]$ ./emctl stop oms Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Or
一、Stopping Grid Control and All Its Components1.停止OMS服务 [oracle@ocm2 oms10g]$ cd /u01/app/oracle/OracleHomes/oms10g/bin/ [oracle@ocm2 bin]$ ./emctl stop oms Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. Oracle Management Server is Down. [oracle@ocm2 bin]$
2.停止Application Server Control Console [oracle@ocm2 bin]$ ./emctl stop iasconsole Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Stopping Oracle 10g Application Server Control ... ... Stopped. [oracle@ocm2 bin]$
3.切换目录至OPMN并停止Application Server components [oracle@ocm2 oms10g]$ cd opmn/ [oracle@ocm2 opmn]$ cd bin/ [oracle@ocm2 bin]$ pwd /u01/app/oracle/OracleHomes/oms10g/opmn/bin [oracle@ocm2 bin]$ ./opmnctl stopall opmnctl: stopping opmn and all managed processes... [oracle@ocm2 bin]$
4.切换目录并停止agent
[oracle@ocm2 bin]$ pwd /u01/app/oracle/OracleHomes/agent10g/bin [oracle@ocm2 bin]$ ./emctl stop agent Oracle Enterprise Manager 10g Release 10.2.0.1.0. Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. Stopping agent ... stopped. [oracle@ocm2 bin]$
5.停止Repository数据库 [oracle@ocm2 bin]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 22 18:15:48 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, Oracle Label Security, OLAP and Data Mining options
SYS@EMREP> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SYS@EMREP> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, Oracle Label Security, OLAP and Data Mining options [oracle@ocm2 bin]$
6.停止Repository数据库监听程序 [oracle@ocm2 bin]$ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 22-JUL-2014 18:17:53
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2.localdomain)(PORT=1521))) The command completed successfully [oracle@ocm2 bin]$
停止结束
二、Starting Grid Control and All Its Components
1.启动Repository数据库对应的监听程序和数据库(注意SID) [oracle@ocm2 bin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 22-JUL-2014 18:20:06
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.2.0 - Production System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2.localdomain)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2.localdomain)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.2.0 - Production Start Date 22-JUL-2014 18:20:06 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2.localdomain)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@ocm2 bin]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 22 18:20:30 2014
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SYS@EMREP> startup ORACLE instance started.
Total System Global Area 285212672 bytes Fixed Size 1260420 bytes Variable Size 125830268 bytes Database Buffers 155189248 bytes Redo Buffers 2932736 bytes Database mounted. Database opened. SYS@EMREP> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, Oracle Label Security, OLAP and Data Mining options [oracle@ocm2 bin]$
2.切换路径并启动OMS [oracle@ocm2 bin]$ cd /u01/app/oracle/OracleHomes/oms10g/bin/ [oracle@ocm2 bin]$ pwd /u01/app/oracle/OracleHomes/oms10g/bin [oracle@ocm2 bin]$ ./emctl start oms Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. opmnctl: opmn started Starting HTTP Server ... Starting Oracle Management Server ... Checking Oracle Management Server Status ... Oracle Management Server is Up. [oracle@ocm2 bin]$
3.切换路径启动OracleAS Web Cache [oracle@ocm2 bin]$ pwd /u01/app/oracle/OracleHomes/oms10g/opmn/bin [oracle@ocm2 bin]$ ./opmnctl status
Processes in Instance: EnterpriseManager0.ocm2.localdomain -------------------+--------------------+---------+--------- ias-component | process-type | pid | status -------------------+--------------------+---------+--------- DSA | DSA | N/A | Down HTTP_Server | HTTP_Server | 17072 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | dcm-daemon | 17039 | Alive OC4J | home | N/A | Down OC4J | OC4J_EMPROV | N/A | Down OC4J | OC4J_EM | 17116 | Alive WebCache | WebCache | N/A | Down WebCache | WebCacheAdmin | N/A | Down
[oracle@ocm2 bin]$ ./opmnctl startproc ias-component=WebCache opmnctl: starting opmn managed processes... [oracle@ocm2 bin]$ ./opmnctl status
Processes in Instance: EnterpriseManager0.ocm2.localdomain -------------------+--------------------+---------+--------- ias-component | process-type | pid | status -------------------+--------------------+---------+--------- DSA | DSA | N/A | Down HTTP_Server | HTTP_Server | 17072 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | dcm-daemon | 17039 | Alive OC4J | home | N/A | Down OC4J | OC4J_EMPROV | N/A | Down OC4J | OC4J_EM | 17116 | Alive WebCache | WebCache | 17205 | Alive WebCache | WebCacheAdmin | 17197 | Alive
[oracle@ocm2 bin]$
4.切换路径并启动agent
[oracle@ocm2 bin]$ pwd /u01/app/oracle/OracleHomes/agent10g/bin [oracle@ocm2 bin]$ ./emctl start agent Oracle Enterprise Manager 10g Release 10.2.0.1.0. Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. Starting agent ..... started. [oracle@ocm2 bin]$
最后确认ias-component全部已经启动 [oracle@ocm2 bin]$ cd /u01/app/oracle/OracleHomes/oms10g/opmn/bin/ [oracle@ocm2 bin]$ ./opmnctl status
Processes in Instance: EnterpriseManager0.ocm2.localdomain -------------------+--------------------+---------+--------- ias-component | process-type | pid | status -------------------+--------------------+---------+--------- DSA | DSA | N/A | Down HTTP_Server | HTTP_Server | 17072 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | dcm-daemon | 17039 | Alive OC4J | home | N/A | Down OC4J | OC4J_EMPROV | N/A | Down OC4J | OC4J_EM | 17116 | Alive WebCache | WebCache | 17205 | Alive WebCache | WebCacheAdmin | 17197 | Alive
[oracle@ocm2 bin]$ ./opmnctl startproc ias-component=DSA opmnctl: starting opmn managed processes... [oracle@ocm2 bin]$ ./opmnctl startproc ias-component=LogLoader opmnctl: starting opmn managed processes... [oracle@ocm2 bin]$ ./opmnctl startproc ias-component=OC4J opmnctl: starting opmn managed processes... [oracle@ocm2 bin]$ ./opmnctl status
Processes in Instance: EnterpriseManager0.ocm2.localdomain -------------------+--------------------+---------+--------- ias-component | process-type | pid | status -------------------+--------------------+---------+--------- DSA | DSA | 18173 | Alive HTTP_Server | HTTP_Server | 17072 | Alive LogLoader | logloaderd | 18197 | Alive dcm-daemon | dcm-daemon | 17039 | Alive OC4J | home | 18326 | Alive OC4J | OC4J_EMPROV | 18324 | Alive OC4J | OC4J_EM | 17116 | Alive WebCache | WebCache | 17205 | Alive WebCache | WebCacheAdmin | 17197 | Alive
[oracle@ocm2 bin]$

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

MySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.

Optimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Dreamweaver Mac version
Visual web development tools

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

WebStorm Mac version
Useful JavaScript development tools

Zend Studio 13.0.1
Powerful PHP integrated development environment
