10.2.0.1.1 Start and Stop grid control, 10.2.0.1.1grid

10.2.0.1.1 Start and Stop grid control, 10.2.0.1.1grid
1. Stopping Grid Control and All Its Components
1. stop OMS service [oracle @ ocm2 oms10g] $ cd/u01/app/oracle/OracleHomes/oms10g/bin/[oracle @ ocm2 bin] $. /emctl stop omsOracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996,200 5 Oracle Corporation. all rights reserved. oracle Management Server is Down. [oracle @ ocm2 bin] $2. stop Application Server Control Console [oracle @ ocm2 bin] $. /emctl stop iasconsoleOracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996,200 5 Oracle Corporation. all rights reserved.
Stopping Oracle 10g Application Server Control ...... stopped. [oracle @ ocm2 bin] $3. switch the directory to OPMN and stop 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 stopallopmnctl: stopping opmn and all managed processes... [oracle @ ocm2 bin] $4. switch directory and stop agent
[Oracle @ ocm2 bin] $ pwd/u01/app/oracle/OracleHomes/agent10g/bin [oracle @ ocm2 bin] $. /emctl stop agentOracle Enterprise Manager 10g Release 10.2.0.1.0. copyright (c) 1996,200 5 Oracle Corporation. all rights reserved. stopping agent... stopped. [oracle @ ocm2 bin] $5. stop the Repository database [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,200 5, Oracle. All Rights Reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining options
SYS @ EMREP> shutdown immediateDatabase closed. database dismounted. ORACLE instance shut down. SYS @ EMREP> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining options [oracle @ ocm2 bin] $6. stop the Repository Database Listener [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,200 5, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ocm2.localdomain) (PORT = 1521) The command completed successfully [oracle @ ocm2 bin] $ stop The end


2. Starting Grid Control and All Its Components
1. start the listener and database corresponding to the Repository database (note 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,200 5, 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-ProductionSystem parameter file is/u01/app/oracle/product/10.2.0/db_1/network/admin/listener. oraLog messages written to/u01/app/oracle/product/10.2.0/db_1/network/log/listener. logListening 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 LISTENERVersion TNSLSNR for Linux: version 10.2.0.2.0-ProductionStart Date 22-JUL-2014 18: 20: 06 Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File/u01/app/oracle/product/10.2.0/db_1/network/admin/listener. oraListener Log File/u01/app/oracle/product/10.2.0/db_1/network/log/listener. logListening 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,200 5, Oracle. All Rights Reserved.
Connected to an idle instance.
SYS @ EMREP> startupORACLE instance started.
Total System Global Area 285212672 bytesFixed Size 1260420 bytesVariable Size 125830268 bytesDatabase Buffers 155189248 bytesRedo Buffers 2932736 bytesDatabase mounted. database opened. SYS @ EMREP> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0-ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining options [oracle @ ocm2 bin] $2. switch the path and start 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 omsOracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996,200 5 Oracle Corporation. all rights reserved. opmnctl: opmn startedStarting HTTP Server... starting Oracle Management Server... checking Oracle Management Server Status... oracle Management Server is Up. [oracle @ ocm2 bin] $3. start 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 alias + -------------------- + --------- ias-component | process-type | pid | status indication + -------------------- + --------- DSA | N/A | Down HTTP_Server | 17072 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | 17039 | Alive productname | home | N/A | Down productname | OC4J_EMPROV | N/A | Down productname | OC4J_EM | 17116 | Alive WebCache | N/A | Down WebCache | WebCacheAdmin | N/A | Down
[Oracle @ ocm2 bin] $./opmnctl startproc ias-component = WebCacheopmnctl: starting opmn managed processes... [oracle @ ocm2 bin] $./opmnctl status
Processes in Instance: EnterpriseManager0.ocm2. localdomain alias + -------------------- + --------- ias-component | process-type | pid | status indication + -------------------- + --------- DSA | N/A | Down HTTP_Server | 17072 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | 17039 | Alive productname | home | N/A | Down productname | OC4J_EMPROV | N/A | Down productname | OC4J_EM | 17116 | Alive WebCache | 17205 |AliveWebCache | WebCacheAdmin | 17197 |Alive
[Oracle @ ocm2 bin] $4. Switch the path and start the agent
[Oracle @ ocm2 bin] $ pwd/u01/app/oracle/OracleHomes/agent10g/bin [oracle @ ocm2 bin] $. /emctl start agentOracle Enterprise Manager 10g Release 10.2.0.1.0. copyright (c) 1996,200 5 Oracle Corporation. all rights reserved. starting agent ..... started. [oracle @ ocm2 bin] $ finally confirm that ias-component has all started [oracle @ ocm2 bin] $ cd/u01/app/oracle/OracleHomes/oms10g/opmn/bin/[oracle @ ocm2 bin] $. /opmnctl status
Processes in Instance: EnterpriseManager0.ocm2. localdomain alias + -------------------- + --------- ias-component | process-type | pid | status indication + -------------------- + --------- DSA | N/A | Down HTTP_Server | 17072 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | 17039 | Alive productname | home | N/A | Down productname | OC4J_EMPROV | N/A | Down productname | OC4J_EM | 17116 | Alive WebCache | 17205 | Alive WebCache | WebCacheAdmin | 17197 | Alive
[Oracle @ ocm2 bin] $. /opmnctl startproc ias-component = DSAopmnctl: starting opmn managed processes... [oracle @ ocm2 bin] $. /opmnctl startproc ias-component = LogLoaderopmnctl: starting opmn managed processes... [oracle @ ocm2 bin] $. /opmnctl startproc ias-component = OC4Jopmnctl: starting opmn managed processes... [oracle @ ocm2 bin] $. /opmnctl status
Processes in Instance: EnterpriseManager0.ocm2. localdomain alias + -------------------- + --------- ias-component | process-type | pid | status indication + ---------------------- + --------- DSA | 18173 | Alive HTTP_Server | 17072 | logLoader | logloaderd | 18197 | Alive dcm-daemon | 17039 | Alive productname | home | 18326 | Alive productname | OC4J_EMPROV | 18324 | Alive productname | OC4J_EM | 17116 | Alive WebCache | WebCache | 17205 | Alive WebCache | WebCacheAdmin | 17197 | Alive
[Oracle @ ocm2 bin] $










Use gridcontrol

Private void mnuLoad_Click (object sender, System. EventArgs e)
{
// TODO: Load MERs

Database db = null;
Db = DatabaseFactory. CreateDatabase ();

DataSet ds = db. ExecuteDataSet (
CommandType. Text,
"Select id, Name, Age From UserInfo ");

GridControl1.DataSource = ds. Tables [0];

// Select a row at a time and cannot be edited
This. gridView1.FocusRectStyle = DevExpress. XtraGrid. Views. Grid. DrawFocusRectStyle. RowFocus;
This. gridView1.OptionsBehavior. Editable = false;
This. gridView1.OptionsSelection. EnableAppearanceFocusedCell = false;

// Set the column title
GridView1.Columns [0]. Caption = "no ";
GridView1.Columns [1]. Caption = "name ";
GridView1.Columns [2]. Caption = "Age ";

// Set the column name to facilitate the display of grouping and Foot statistics.
GridView1.Columns [0]. Name = "ID ";
GridView1.Columns [1]. Name = "Name ";
GridView1.Columns [2]. Name = "Age ";

// Add a Group column for grouping
This. gridView1.GroupSummary. AddRange (new DevExpress. XtraGrid. GridSummaryItem [] {
New DevExpress. XtraGrid. GridGroupSummaryItem (DevExpress. Data. SummaryItemType. Count, "ID", null, "(Count = {0 })")});

// Add a Group column for grouping
This. gridView1.GroupSummary. AddRange (new DevExpress. XtraGrid. GridSumm ...... the remaining full text>

Add built-in pagination entries in gridControl1. After you click the delete button, the two rows are deleted in the gridview? (In fact, only one row is deleted.) How can this problem be eliminated?

Clicking Delete will delete the two rows,
When you discover this problem, you need to find out how it affects.
In my past coding habits, I may use the following methods to implement this implementation:
1. Bind The gridview data.
DataTable dt = DBUtil. GetDateBind (/.../); this is from the database to investigate the data source;
GridView1.DataSource = dt; this is for the Gridview Data Source
GridView1.DataBind (); this is the data binding of the GridView.
2. You added the delete button. I don't know how you wrote the delete button ?? (2 types: I: Use checkbox for selection, and then put a deleted linkbutton ON THE GridView; II: Put a deleted linkbutton on each row)
As for the first type: You can loop through GridViewRows and use FindControl to find the checkbox of each row to check whether the row is selected and save the selected one to a string, if there are two strings sid = "'a1', 'a1'"; then delete from table1 where ID in (sid.
Second, you may need to write the delete statement on the CommandName and CommandArgument of the deleted linkbutton, for example, CommandName = "ufdel" CommandArgument = "<% # Eval ("... ") %>", then you can use if (e. commandName = "ufdel "){... here is the deleted code .}, OK.
3. The deletion is complete. Then we need to bind data from the new one:
DataTable dt = DBUtil. GetDateBind (/.../); this is from the database to investigate the data source;
GridView1.DataSource = dt; this is for the Gridview Data Source
GridView1.DataBind (); this is the data binding of the GridView.
Repeat the first step.