1. Create the repository for the Oracle Enterprise Manager Console.
   

   % emca -repos create
   
   STARTED EMCA at Feb 14, 2008 1:52:03 AM
   EM Configuration Assistant, Version 10.2.0.1.0 Production
   Copyright (c) 2003, 2005, Oracle.  All rights reserved.
   
   Enter the following information:
   Database SID: TEST <- you may have to input your database's SID
   Listener port number: 1521
   Password for SYS user:  change_on_install <- choose any string you like
   Password for SYSMAN user:  manager <- choose any string you like
   
   Do you wish to continue? [yes(Y)/no(N)]: y
   Feb 14, 2008 1:52:39 AM oracle.sysman.emcp.EMConfig perform
   INFO: This operation is being logged at /export/home/oracle/cfgtoollogs/emca/TEST/emca_2008-02-14_01-52-03-AM.log.
   Feb 14, 2008 1:52:39 AM oracle.sysman.emcp.EMReposConfig createRepository
   INFO: Creating the EM repository (this may take a while) ...
   Feb 14, 2008 1:54:33 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Repository successfully created
   Enterprise Manager configuration completed successfully
   FINISHED EMCA at Feb 14, 2008 1:54:33 AM

   
   emca is the Enterprise Manager Configuration Assistant. And the repository that we just created will hold a set of tables containing the internal state information of Enterprise Manager for the managed environment.
   
   
2. Dynamically increase the maximum number of processes that can be created for the execution of jobs, JOB_QUEUE_PROCESSES.
   

   % sqlplus / as sysdba
   
   SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 14 01:54:57 2008
   Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
   
   SQL> alter system set job_queue_processes = 2;
   
   System altered.

   
   
3. Unlock the accounts of OEM super admin user, SYSMAN; and the database monitoring agent, DBSNMP.
   

   % sqlplus / as sysdba
   
   SQL> alter user dbsnmp identified by dbsnmp account unlock;
   
   User altered.
   
   SQL> alter user sysman identified by manager account unlock;
   
   User altered.

   
   
4. Configure the database control for the database that we just created (step #1)
   

   % emca -config dbcontrol db
   
   STARTED EMCA at Feb 14, 2008 1:55:35 AM
   EM Configuration Assistant, Version 10.2.0.1.0 Production
   Copyright (c) 2003, 2005, Oracle.  All rights reserved.
   
   Enter the following information:
   Database SID: TEST
   Listener port number: 1521
   Password for SYS user:  change_on_install
   Password for DBSNMP user:  dbsnmp
   Password for SYSMAN user:  manager
   Email address for notifications (optional):
   Outgoing Mail (SMTP) server for notifications (optional):
   -----------------------------------------------------------------
   
   You have specified the following settings
   
   Database ORACLE_HOME ................ /export/home/oracle
   
   Database hostname ................ ben05
   Listener port number ................ 1521
   Database SID ................ TEST
   Email address for notifications ...............
   Outgoing Mail (SMTP) server for notifications ...............
   
   -----------------------------------------------------------------
   Do you wish to continue? [yes(Y)/no(N)]: y
   Feb 14, 2008 1:56:17 AM oracle.sysman.emcp.EMConfig perform
   INFO: This operation is being logged at /export/home/oracle/cfgtoollogs/emca/TEST/emca_2008-02-14_01-55-35-AM.log.
   Feb 14, 2008 1:56:20 AM oracle.sysman.emcp.util.DBControlUtil startOMS
   INFO: Starting Database Control (this may take a while) ...
   Feb 14, 2008 1:57:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
   INFO: Database Control started successfully
   Feb 14, 2008 1:57:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
   INFO: >>>>>>>>>>> The Database Control URL is http://ben05:1158/em <<<<<<<<<<<
   Enterprise Manager configuration completed successfully
   FINISHED EMCA at Feb 14, 2008 1:57:57 AM
   
   % netstat -a | grep 1158
       *.1158               *.*                0      0 799744      0 LISTEN

   
   
5. Grant sysdba privileges to the sys user.
   

    % sqlplus / as sysdba
   
   SQL> grant sysdba to sys;
   
   Grant succeeded.

   
   Note:
   If the grant sysdba .. command fails with an ORA-01994: GRANT failed: password file missing or disabled, make sure the parameter REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE, not to NONE. Also create the orapw<ORACLE_SID> file as shown in the following steps.
   
   

   SQL> grant sysdba to sys;
    grant sysdba to sys
   *
   ERROR at line 1:
   ORA-01994: GRANT failed: password file missing or disabled
   
   SQL> show parameter password
   
   NAME
   ------------------------------------
   TYPE
   --------------------------------------------------------------------------------
   VALUE
   ------------------------------
   remote_login_passwordfile
   string
   NONE

   
   Set REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE in the init<ORACLE_SID> file, shutdown the database instance.
   
   Login as the same OS user that owns the file $ORACLE_HOME/bin/oracle and (re)create the passwordfile as shown below.
   

   % orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=newsyspassword entries=16 force=y
   % chown oracle:dba $ORACLE_HOME/dbs/orapw$ORACLE_SID <- replace the user id and the group with yours
   % chmod 4640 $ORACLE_HOME/dbs/orapw$ORACLE_SID
   
   eg.,
   % ls -l $ORACLE_HOME/dbs/orapw$ORACLE_SID
   -rw-r-----   1 oracle     dba        39424 Feb 14 02:12 /export/home/oracle/dbs/orapwTEST

   
   
   Start up the database and run the grant sysdba .. command again.
   
   
6. At this point, you should be able to access the Oracle Enterprise Manager Console through a web browser using the URL emitted in the emca -config dbcontrol db step (http://ben05:1158/em in this case).
   
   
7. Commands to start, stop and check the status of the console
   
   
   • To start the console:
     

     emctl start dbconsole
     
     eg.,% emctl start dbconsole
     Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
     Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
     http://ben05:1158/em/console/aboutApplication
     Starting Oracle Enterprise Manager 10g Database Control ............................ started. 
     ------------------------------------------------------------------
     Logs are generated in directory /export/home/oracle/ben05_TEST/sysman/log

     
     
   • To stop the console:
     

     emctl stop dbconsole
     
     eg., % emctl stop dbconsole
     Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
     Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
     http://ben05:1158/em/console/aboutApplication
     Stopping Oracle Enterprise Manager 10g Database Control ... 
      ...  Stopped.

     
     
   • To check the status of the console
     

     emctl status dbconsole
     
     eg., % emctl status dbconsole
     Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0  
     Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
     http://ben05:1158/em/console/aboutApplication
     Oracle Enterprise Manager 10g is not running.

   
   
8. Finally if you want to drop the database console, use this command:
   

   % emca -deconfig dbcontrol db

Oracle

Database

Oracle Enterprise Manager

Posted by: Giri Mandalika.    # 5:22 PM 3 comments.     Tweet

• Check the $TNS_ADMIN/tnsnames.ora ($TNS_ADMIN\tnsnames.ora on Windows)
  
  eg.,

  % cat $TNS_ADMIN/tnsnames.ora
  
  siamst =
    (DESCRIPTION =
      (ADDRESS_LIST =
      (SDU = 15360)
       (TDU = 15360)
        (ADDRESS = (PROTOCOL = TCP)(HOST = ben07)(PORT = 1521))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = siamst)
      )
    )

  
  
• Make sure you can ping the listener running on the database server
  
  eg.,

   % tnsping siamst
  
  TNS Ping Utility for Solaris: Version 11.1.0.6.0 - Production on 15-FEB-2008 11:06:02
  Copyright (c) 1997, 2007, Oracle.  All rights reserved.
  
  Used parameter files:
  /export/home/oracle/network/admin/sqlnet.ora
  
  Used TNSNAMES adapter to resolve the alias
  Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (SDU = 15360) (TDU = 15360) 
  (ADDRESS = (PROTOCOL = TCP)(HOST = ben07)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = siamst)))
  OK (10 msec)

  
  
• Finally using the command line utility, sqlplus, connect to the Oracle database instance with the table owner for the Siebel database schema. The following example assumes 'oraperf' is the table owner for the Siebel database schema.
  
  eg.,

   % sqlplus oraperf/oraperf@siamst
  
  SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 15 11:11:54 2008
  Copyright (c) 1982, 2007, Oracle.  All rights reserved.
  
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
  With the Partitioning, OLAP and Data Mining options
  
  SQL> set head off
  SQL> select * from s_app_ver;
  
  0-70            01-JAN-80 0-1             16-FEB-01 0-1
                16 0               V8.0
  13                             29
  43                             Y 0
  Database Schema for Siebel 2005 43r88_HEM17_06_SIA
  
  1                              0
                                 88
  71
  
                  HQ
  
  
  SQL> quit
  Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
  With the Partitioning, OLAP and Data Mining options

  
  
• If the above step fails to connect to the Oracle database instance, check the connect string, table owner etc., fix them if needed and repeat the above step.

1. Set the required environment variables
   eg.,

   % source $SIEBEL_HOME/siebenv.sh (csh)
   % . $SIEBEL_HOME/siebenv.sh (ksh)

   
   
2. Bring up the odbcsql command line interface (CLI), connect to the Oracle database instance using the table owner login/password
   
   eg.,

   % odbcsql
   ODBCSQL - ODBC SQL Interface program
   Copyright (c) 2001 Siebel Systems, Inc.  All rights reserved.
   
   Type help for usage information.
   
   ODBC> set source=siebsrvr_siebel
   
   ODBC> login oraperf/oraperf
   SQL DBMS: Oracle version 10.02.0000 Oracle 10.2.0.1.0
   ODBC driver: SEor821.so version 05.10.0017 (B0011, U0004)
   (login time: 0.73s)
   
   ODBC> quit
   Outstanding transaction committed.

   
   Alternatively it can be tested in a single line as shown below:
   

   % odbcsql /s siebsrvr_siebel /u oraperf /p oraperf
   ODBCSQL - ODBC SQL Interface program
   Copyright (c) 2001 Siebel Systems, Inc.  All rights reserved.
   
   Type help for usage information.
   
   Logging into "siebsrvr_siebel" as "oraperf" ...
   SQL DBMS: Oracle version 10.02.0000 Oracle 10.2.0.1.0
   ODBC driver: SEor821.so version 05.10.0017 (B0011, U0004)
   (login time: 0.67s)
   
   ODBC> quit
   Outstanding transaction committed.

Oracle

Siebel

CRM

Database

Posted by: Giri Mandalika.    # 12:07 AM 1 comments.     Tweet

NTSTATUS DriverEntry(PDRIVER_OBJECT DriverObject, PUNICODE_STRING RegistryPath)
{
  DriverObject->MajorFunction[IRP_MJ_CREATE] = XXXXDispatchCreate;
  DriverObject->MajorFunction[IRP_MJ_CLOSE]  = XXXXDispatchClose;
  DriverObject->MajorFunction[IRP_MJ_PNP]    = XXXXDispatchPnp;     
  DriverObject->MajorFunction[IRP_MJ_POWER]  = XXXXDispatchPower;
  DriverObject->MajorFunction[IRP_MJ_READ]   = XXXXDispatchRead;
  DriverObject->MajorFunction[IRP_MJ_WRITE]  = XXXXDispatchWrite;
  DriverObject->MajorFunction[IRP_MJ_DEVICE_CONTROL] = XXXXDispatchDeviceControl;
  DriverObject->DriverUnload = XXXXUnload;
  DriverObject->DeviceExtension->AddDevice = XXXXAddDevice;
}

The DriverEntry gets pointer to its own driver object (DriverObject).DriverEntry initializes entry points for other routines of the driver and stores their pointers in the DriverObject. DriverEntry also initializes DriverUnload routine and AddDevice routine.

AddDevice:

Syntax:

NTSTATUS XXXXAddDevice(PDRIVER_OBJECT DriverObject, PDEVICE_OBJECT DeviceObject)
{
//.....
}

DriverUnload :

Syntax:

NTSTATUS XXXXUnload(PDRIVER_OBJECT DriverObject)
{
//…………..
}

Apart from DriverUnload and AddDevice rest all routines initialised in DriverEntry share same signature.

NTSTATUS  XXXX(PDEVICE_OBJECT DeviceObject, PIRP Irp);

IRP_MJ_CREATE :

Syntax:

NTSTATUS  XXXXDispatchCreate(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

All dispatch routines must make a call to the function IoGetCurrentIrpStackLocation to get driver’s associate stack location. Also all dispatch routines must to fill out the PIRP and complete the routine through IoCompleteRequest.

PIRP can be filled as below:

Irp->IoStatus.Status = STATUS_SUCCESS;
Irp->IoStatus.Information = 0;
IoCompleteRequest( Irp,IO_NO_INCREMENT);

IRP_MJ_CLOSE :

Syntax:

NTSTATUS  XXXXDispatchClose(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

IRP_MJ_PNP:

Syntax

NTSTATUS  XXXXDispatchPnp(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

Plug-n-Play (PNP) is acombination of hardware and softawre support that enables a computer to recognize and adapt to new hardware configuration change with little or no user intervension (i.e) user can add or remove devices at run time.

PNP's main responsibilities:

• Automatic detection of hardware installation changes
  
• Loading appropriate drivers during run time.

When a device is added to the system at run time some of the steps to be taken care of can be describe briefly as:

• The user plugs in the device in a free slot
  
• Function driver on the bus determines that there is a new device on the bus
  
• Function driver notifies the PNP Manager about the new device addition
  
• PNP manager send an IRP and the function driver of the bus handles the IRP and creates the PDO for the new device.
  
• PNP manager gathers the information about the device through various IRPs and stores the information in the registry.
  
• User mode setup components call kernel mode to help them call AddDevice routine.
  
• PNP manager helps call the drivers DriverEntry and attaches the device to the stack
  
• Resources necessary for the device are added and the device is started.

PnP has minor functions to support each PnP request accordingly. Few of the required function codes are:

IRP_MN_START_DEVICE
IRP_MN_QUERY_REMOVE_DEVICE
IRP_MN_REMOVE_DEVICE
IRP_MN_CANCEL_REMOVE_DEVICE
IRP_MN_QUERY_STOP_DEVICE
IRP_MN_ STOP_DEVICE
IRP_MN_CANCEL_STOP_DEVICE
IRP_MN_SURPRISE_REMOVAL

PNP Manager sends this IRP after it has assigned hardware resources to the device.The device may have been recently enumerated and is being started for the very first time or is restarting after being stopped. It an also be sent when driver currently in use requires new set of resources.

IRP_MN_QUERY_REMOVE_DEVICE:

This IRP is sent to query if the device if the device can be removed with out disturbing the system. In response to this IRP drivers inform whether the device can be removed or not.

IRP_MN_REMOVE_DEVICE:

This IRP is used to remove to device’s software representations like device object from the system. This IRP is called when the device is removed in orderly fashion or plugged out with out prior notification or when the driver needs an update.

IRP_MN_CANCEL_REMOVE_DEVICE:

This IRP is sent to inform the driver that the device will not be removed from the system. The status prior to the IRP_MN_QUERY_REMOVE_DEVICE will be restored in this case.

IRP_MN_QUERY_STOP_DEVICE:

This IRP is sent to query whether a device can be stopped to rebalance the resources. In response to this IRP the device informs if it is safe to stop the device or not.

IRP_MN_ STOP_DEVICE:

This IRP is sent to stop the device to reconfigure the hardware resources. In response to this IRP driver stops the device and releases the hardware resources being used by the device.

IRP_MN_CANCEL_STOP_DEVICE:

This IRP is sent to inform the driver that the device will not be stopped for rebalancing of the resources. In response to this IRP the driver must return the device to the started state.

IRP_MN_SURPRISE_REMOVAL:

This IRP is sent to the drivers for a device to inform that the device is no longer available for I/O operations. This may happen for reasons like:-

• The bus has hot-plug notification and it notifies the device's parent bus driver that the device has disappeared.
  
• When the bus is enumerated the surprise removed device will not be there on the bus.

In response to this IRP, Some of the steps to be taken care of are:

• Ensure that the device is not available
  
• Release the device’s hardware resources
  
• Notify the power manager with PoSetPowerState and power down the bus slot of the device if possible
  
• Prevent further I/O operations and fail the outstanding ones.
  
• Process subsequent cleanup and close operations to the device.
  
• After this IRP succeeds IRP_MN_REMOVE_DEVICE must be called.

IRP_MJ_POWER :

Syntax

NTSTATUS  XXXXDispatchPower(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

IRP_MN_POWER_SEQUENCE
IRP_MN_SET_POWER
IRP_MN_WAIT_WAKE
IRP_MN_QUERY_POWER

IRP_MN_POWER_SEQUENCE:

This IRP is for optimization and is sent to determine whether its device actually entered a specific power state or not. IRP returns the power sequence values for the device.

IRP_MN_SET_POWER:

This IRP is sent to notify the drivers of the change to the system power state or to change the power state of a device for which the power manager is performing idle detection. PoRequestPowerIrp must be called to send this IRP.

IRP_MN_WAIT_WAKE:

This IRP is used to awaken a system/device from sleep state.

IRP_MN_QUERY_POWER:

This IRP is sent to query whether the system power state or the device power state can be changed.PoRequestPowerIrp must be called to send this IRP.

IRP_MJ_DEVICE_CONTROL :

Syntax

NTSTATUS  XXXXDeviceControl(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

Every driver whose device objects belong to a particular device type and has a set of system-defined I/O control codes (IOCTLs) support this IRP. A driver receives this I/O control code because user-mode thread has called the Microsoft Win32 DeviceIoControl function, or a higher-level kernel-mode driver has set up the request. On receipt of a device I/O control request for most I/O control codes, device drivers transfer a small amount of data to or from the buffer.

IRP_MJ_READ :

Syntax

NTSTATUS  XXXXDispatchRead(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

IRP_MJ_WRITE :

Syntax

NTSTATUS  XXXXDispatchWrite(PDEVICE_OBJECT DeviceObject, PIRP Irp)
{
//…………
}

References:

Windows® 2000 Device Driver Book: A Guide for Programmers, Second Edition
MSDN
___________________
Technorati tags:

Win32 | Windows | WDM | Device Drivers | Programming

Posted by: Harisha Nelapatla.    # 5:31 PM 0 comments.     Tweet