How to do automatic disconnection of idle sessions

If you don't have a good idea about inactive/idle sessions in oracle database then please have a look at About Dead connection and inactive sessions.

In the post Script to check list of idle sessions I have wrote a script through which you can see the list of inactive/idle sessions in a database.

After you see the list of inactive/idle session in a database, take the SID, SERIAL# and then using command,
SQL> alter system kill session 'sid,serial#'; (where sid and serial# is integer number returned from above url query.)
you can kill the inactive/idle session in your database.
However, this is not the ideal scenario. In most of the cases you want to do automatic disconnection of idle sessions in your database. Step by step procedure is shown below.

Step 01: Enables the enforcement of resource limits in database.
You can enable the enforcement of resource limits by setting the initialization parameter RESOURCE_LIMIT to TRUE.
SQL> alter system set resource_limit = true;

Step 02: Create a profile which will monitor the idle time.
The parameter idle_time of a profile limit the idle time for a session. If the time between calls in a session reaches the idle time limit, then the current transaction is rolled back, the session is terminated, and the resources of the session are returned to the system. This limit is set as a number of elapsed minutes.

Note that, shortly after a session is terminated because it has exceeded an idle time limit, the process monitor (PMON) background process cleans up after the terminated session. Until PMON completes this process, the terminated session is still counted in any session or user resource limit.

So create a profile with idle_time parameter set to your expected value.
Syntax is,
create profile profile_name limit idle_time no_of_minutes;

I want to create a profile named idletime with 10 minutes idle time limit.
SQL> create profile idletime limit idle_time 10;

Step 03: Assign this profile to your desired user.

alter user user_name profile profile_name;
Example: (if user name is prod and profile is idletime)
SQL> alter user prod profile idletime;

Now Oracle prod user sessions, which have been inactive for greater than 10 minutes, to be disconnected from the database. Any uncommitted transaction will be rolled back. When the idle time has passed, the session will be suspended. Next time the user enters a command he will receive an ORA-02396: exceeded maximum idle time, please connect again.

Script to check list of inactive users or inactive sessions in a database

If you don't have a good idea about inactive sessions in oracle database then please have a look at About Dead connection and inactive sessions.
In many cases you need to check the list of inactive users or inactive sessions in your database. From the view V$SESSION, V$PROCESS and V$SESSION_WAIT you can check that. I have made a script through which you can check the list of inactive users as well as inactive sessions. Note that in order to use this script you must have SELECT privilege on V$SESSION, V$PROCESS, V$SESSION_WAIT.

Following is the script.

REM NAME inactive_users_sessions.sql
REM --------------------------------------------
REM PRIVILEGES NEEDED
REM SELECT on V$SESSION, V$PROCESS, V$SESSION_WAIT
REM --------------------------------------------
REM AUTHOR:  
REM    Mohammad Abdul Momin Arju
REM    http://arjudba.blogspot.com    
REM -------------------------------------------------------------------------- 
REM PURPOSE
REM This script will lists the inactive users and sessions in a database.
REM The wait sequence can be monitored to check whether this really is an
REM inactive user or not. The process id & serial can assist to kill the process.
REM ------------------------------------------------------------------------------------------------------------
REM EXAMPLE:
REM
REM                                                                          Shadow     Parent          Wait
REM ORACLE/OS User      Client Machine       Terminal          SID    SERIAL# Process ID Process ID  Sequence
REM ------------------- -------------------- ---------- ---------- ---------- ---------- ---------- ---------
REM ARJU NOTEBOOK\User  WORKGROUP\NOTEBOOK   NOTEBOOK          147        372 4952       2812:2000         41
REM ------------------------------------------------------------------------------------------------------------
REM Main Text
set heading on feedback on pages 100 lines 140
column userinfo heading "ORACLE/OS User" format a19
column machine heading "Client Machine" format a20
column terminal heading "Terminal" format a10
column process heading "Parent|Process ID" format a10
column spid heading "Shadow|Process ID" format a10
column seq# heading "Wait|Sequence" format 99999990
select s.username||' '||s.osuser userinfo,s.machine, s.terminal, s.sid, s.serial#,
p.spid,
s.process , w.seq#
from v$session s, v$process p
,v$session_wait w
where p.addr = s.paddr
and s.sid = w.sid
and w.event = 'SQL*Net message from client'
and s.status = 'INACTIVE'
order by s.osuser, s.machine
/

Following is the sample output from my oracle environment.

SQL> set heading on feedback on pages 100 lines 140
SQL> column userinfo heading "ORACLE/OS User" format a19
SQL> column machine heading "Client Machine" format a20
SQL> column terminal heading "Terminal" format a10
SQL> column process heading "Parent|Process ID" format a10
SQL> column spid heading "Shadow|Process ID" format a10
SQL> column seq# heading "Wait|Sequence" format 99999990
SQL> select s.username||' '||s.osuser userinfo,s.machine, s.terminal, s.sid, s.serial#,
  2  p.spid,
  3  s.process , w.seq#
  4  from v$session s, v$process p
  5  ,v$session_wait w
  6  where p.addr = s.paddr
  7  and s.sid = w.sid
  8  and w.event = 'SQL*Net message from client'
  9  and s.status = 'INACTIVE'
 10  order by s.osuser, s.machine
 11  /

                                                                          Shadow     Parent          Wait
ORACLE/OS User      Client Machine       Terminal          SID    SERIAL# Process ID Process ID  Sequence
------------------- -------------------- ---------- ---------- ---------- ---------- ---------- ---------
ARJU NOTEBOOK\User  WORKGROUP\NOTEBOOK   NOTEBOOK          147        372 4952       2812:2000         41
SYS NOTEBOOK\User   WORKGROUP\NOTEBOOK   NOTEBOOK          143          1 4972       2136:4332         20

2 rows selected. 

You can make a script to kill all inactive users or sessions in a database by making a script like below.

set heading off
select 'alter system kill session ' || '''' || s.sid ||','||s.serial# ||''''||';' 
from v$session s, v$process p
,v$session_wait w
where p.addr = s.paddr
and s.sid = w.sid
and w.event = 'SQL*Net message from client'
and s.status = 'INACTIVE'
/

From my environment,

SQL> set heading off
SQL> select 'alter system kill session ' || '''' || s.sid ||','||s.serial# ||''''||';'
  2  from v$session s, v$process p
  3  ,v$session_wait w
  4  where p.addr = s.paddr
  5  and s.sid = w.sid
  6  and w.event = 'SQL*Net message from client'
  7  and s.status = 'INACTIVE'
  8  /

alter system kill session '143,40';

1 row selected.

What is Dead Connection and Inactive Session and differences between them

This post will describe the differences between dead connection and INACTIVE session. In the subsequent posts I will also explain how we can automate the cleanup of dead connection as well as INACTIVE session.

Dead Connections
Dead Connections are previously valid connections with the database but the connection between the client and server processes has terminated abnormally.

Examples of Dead Connections/ Abnormally Terminated Connection are:

i) Client turns off/reboots their system without logging off or disconnecting from the database.

ii) Client kill the process, for example kill -9 in linux or kill through task manager in windows without normally closing the session.

iii) A network problem prevents communication between the client and the server.

If there is found above cases, the shadow process runs on the server and the session in the database may not terminate. To automate the cleanup of these sessions, you can use the Dead Connection Detection (DCD) feature of Net8.

When Dead Connection Detection (DCD) is enabled, Net8 (server-side) sends a packet to the client. If the client is active, the packet is discarded. If the client has terminated, the server will receive an error and Net8 (server-side) will end that session.

Details will be discuss in another article.

INACTIVE Sessions
You can check INACTIVE sessions in database by querying STATUS column from v$session view. Example of an INACTIVE session:

i) A user starts a program/session, then leaves it running and idle for an extended period of time. This means you are connected to a session but neither you are running any query in that session nor you have terminated the session.

To automate cleanup of INACTIVE sessions you can create a profile with an appropriate IDLE_TIME setting and assign that profile to the users.

Details about automate the cleanup process for inactive session will be discussed in another article.

Step by step Oracle Data Guard Configuration

In the post Step by step Oracle Data Guard Configuration I have already discussed about about the detail procedure of creating physical standby database. After you create standby database if you want to configure Oracle Data Guard Broker in order to centrally manage primary and all the standby databases then in the post Prerequisites for Oracle Data Guard Broker it is discussed the prerequisites for data guard broker.

After you follow above two posts now it is the time to configure data guard broker.

Step 01: Check for DG_BROKER_START initialization parameter. Login to database through sql*plus and issue show parameter dg_broker_start,

SQL> show parameter dg_broker_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------
dg_broker_start                      boolean     FALSE

If it is set to FALSE then proceed further. If it is TRUE then your Data Guard broker DMON process is running. So you will not be able to change configuration file parameters. In order to set the configuration file of your own ensure that dg_broker_start is set to FALSE. You can do it by,

SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;

Step 02: Set the configuration filenames for the database.
Two copies of the configuration file are maintained for each database so as to always have a record of the last known valid state of the configuration. When the broker is started for the first time, the configuration files are automatically created and named using a default path name and filename that is operating-system specific. You can override this default path name and filename by setting the following initialization parameters for that database:

DG_BROKER_CONFIG_FILE1
DG_BROKER_CONFIG_FILE2

You can check the current configuration file by,

SQL> show parameter dg_broker_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
dg_broker_config_file1               string      /u01/app/oracle/DR1A.DAT
dg_broker_config_file2               string      /u01/app/oracle/DR2A.DAT

You can change/override these settings. Note that if you are in Oracle RAC instances then these two parameter must be to a raw device or Oracle ASM file or cluster file system file that is shared by every instance of the RAC. For example issue,

SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1=+DATA/bddipdc/config1.dat;
SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2=+DATA/bddipdc/config2.dat;

Step 03: Restart the DMON process by setting DG_BROKER_START to TRUE.

SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE;

Step 04: Invoke DGMGRL and connect to the primary database.
$ dgmgrl

The DGMGRL prompt is displayed:
DGMGRL>

Note that, the command you write inside dgmgrl prompt is treated as lowercase. So if you want to write something in uppercase within dgmgrl you have to specify within quote.

To connect to primary database on the Local System issue,

DGMGRL> CONNECT sys;
Password: password
Connected.

If you connect to the Primary Database on a Remote System issue,

DGMGRL> CONNECT sys@Nbddipdc

Step 05: Create the broker configuration
If your primary database name is BDDIPDC, connect identifier/tns names of primary database is BDDIPDC and you want to name the configuration as DGCONF then your command will be following.

DGMGRL> CREATE CONFIGURATION 'DGCONF' AS PRIMARY DATABASE IS 'BDDIPDC' CONNECT IDENTIFIER IS 'BDDIPDC';

After you create configuration, you can issue 'show configuration' in order to show the configuration information.

DGMGRL> SHOW CONFIGURATION;

Step 06: Add a standby database to the configuration.
To add a standby database named BDDIPDRS (note that this need to be DB_UNIQUE_NAME) and connect identifier BDDIPDRS issue,

DGMGRL> ADD DATABASE 'BDDIPDRS' AS CONNECT IDENTIFIER IS 'BDDIPDRS';

Note that, you can omit single quote if your DB_UNIQUE_NAME is in lowercase.

Use the SHOW CONFIGURATION command to verify that the 'BDDIPDRS' database was added to the 'DGCONF' configuration:

DGMGRL> SHOW CONFIGURATION;

Prerequisites for Oracle Data Guard Broker

In the post Step by step creating a physical standby database I have already discussed about the detail procedure of creating physical standby database. After you create a standby database now it is the time to configure data guard broker. This post discuss about the prerequisites for Oracle Data Guard Broker configuration.

Following are the prerequisites:

1. Primary and standby databases must use same version of Oracle database and must have Oracle Enterprise Edition or Personal Edition. Either primary or standby or both can be RAC or non-RAC database.

2. You must use SPFILE so that the broker can persistently reconcile values between broker properties and any related initialization parameter values. If you have RAC database then keep the spfile in shared storage.

3. Setup DG_BROKER_CONFIG_FILEn initialization parameters to a location where you want to keep broker configuration file. If you are in RAC environment, then you must set up the DG_BROKER_CONFIG_FILEn initialization parameters for that database such that they point to the same shared files for all instances of that database.

4. The value of the DG_BROKER_START initialization parameter must be set to TRUE.

5. To enable DGMGRL to restart instances during the course of broker operations, a service with a specific name must be statically registered with the local listener of each instance. A static service registration is also required to enable the observer to restart instances as part of automatic reinstatement of the old primary database after a fast-start failover has occurred. The broker uses a default name for the GLOBAL_DBNAME attribute of db_unique_name_DGMGRL.db_domain. For example, in the LISTENER.ORA file:

SID_LIST_LISTENER2 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = bdafisdc_DGMGRL.world)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = bdafisdc1)
    )
  ) 

LISTENER2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER2))
      (ADDRESS = (PROTOCOL = TCP)(HOST =DC-DB-01)(PORT = 1522))
    )
  )

Alternatively, you can use a different static service name. If you do, be sure to modify the StaticConnectIdentifier instance-specific property to reflect the different service name.

Along with previous configuration it is assumed that you have environment of standby database.

ORA-04043 on DBA_* Views if they are described while database is mount stage

Problem Description
Whenever you issue describe command or do any query on a DBA_* views it fails with ORA-04043. Amazing but it is true and another terrible scenario of oracle. For example,

SQL> desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist


SQL> desc dba_tablespaces;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------

 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                NOT NULL NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                                        NUMBER
 PCT_INCREASE                                       NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)
 FORCE_LOGGING                                      VARCHAR2(3)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 ALLOCATION_TYPE                                    VARCHAR2(9)
 PLUGGED_IN                                         VARCHAR2(3)
 SEGMENT_SPACE_MANAGEMENT                           VARCHAR2(6)
 DEF_TAB_COMPRESSION                                VARCHAR2(8)
 RETENTION                                          VARCHAR2(11)
 BIGFILE                                            VARCHAR2(3)

SQL> desc dba_temp_files
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------

 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             CHAR(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER

Though database is open but still it does not show dba_data_files view.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> desc dba_data_files;
ERROR:
ORA-04043: object dba_data_files does not exist

Moreover whenever you try to compile the dba_data_files view it fails with error ORA-00001: unique constraint (SYS.I_OBJ2) violated like below.

SQL> alter view dba_data_files compile;
alter view dba_data_files compile
                                *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_OBJ2) violated

Cause and Investigation of the Problem
The problem is happened due to Oracle bug. ORA-4043 raised on DBA_* tables if those views are described in mount stage. This is same if you issue "desc dba_*" while database is being opened.

You can easily reproduce the problem.

Step 01: Shut down the database.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Step 02: Start the database in mount stage.

SQL> startup mount
ORACLE instance started.

Total System Global Area  314572800 bytes
Fixed Size                  1290328 bytes
Variable Size             205524904 bytes
Database Buffers          100663296 bytes
Redo Buffers                7094272 bytes
Database mounted.

Step 03: Describe one or any DBA_* views.

SQL> desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist

Step 04: Open the database.

SQL> alter database open;

Database altered.

Step 05: Describe the same DBA_* view.

SQL> desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist

Compile the view also raise ORA-00001.
SQL> alter view dba_data_files compile;
alter view dba_data_files compile
                                *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_OBJ2) violated

Solution of the Problem
Solution 01: Flush the shared pool and reissue the same statement.

SQL> alter system flush shared_pool;

System altered.

SQL> desc dba_data_files
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------------

 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
 ONLINE_STATUS                                      VARCHAR2(7)

Solution 02: Don't describe the dba_* views at mount stage.

Solution 03: Shutdown and restart instance and don't desc any dba_* views while database is being mounted or opened.

Age of Empires III and Age Of Empires 3 The Asian Dynasties Cheat Codes

1)10,000 coin Give me liberty or give me coin
2)10,000 food Medium Rare Please
3)10,000 wood
4)10,000 experience points Nova & Orion
5)100x gather/build rates Speed always wins
6)Win single player mission this is too hard
7)Disable fog of war X marks the spot
8)Spawns Mediocre Bombard at Home City
9)gather point Ya gotta make do with what ya got
10)Spawn big red monster truck tuck tuck tuck
11)"Musketeer'ed!" when killed by Musketeers Sooo Good
12)Fatten animals on map A recent study indicated that 100% of herdables are obese
13)Edit resources
Note: This procedure involves editing a game file; create a backup copy of the file before proceeding. Use a text editor to edit the "proto.xml" file in the "data" directory in the game folder. Note: You may first need to uncheck the "Read Only" attribute of that file's properties in Windows Explorer. Search for the text "CrateOf". You will find CrateofFood, CrateofCoin, CrateofWood, CrateofFoodLarge, CrafteofCoinLarge, and CrateofWoodLarge. For all these entries, find the tag "InitialResourceCount" and change the count to whatever desired. For example, the normal crates each have "100.000" of the resources. You can change the "100" to "99999.000", etc. Make sure you do this for all the crates; sometimes a map will give you a large crate of something, and smaller ones of something else, etc. This works best because every map you play in Campaign mode or Skirmish mode starts you with some "crates" of resources, which your settlers will gather out. This will edit the crates to have large amounts of resources in them. However, it still takes a long time to get the resources out of the crate for the settlers, because there are so many. If you are impatient, search for "Settler" in the "proto.xml" file and find the tag for GatherCrate. Change the value to whatever desired, preferably something very high (for example, "99999"). They will pull the resources out of the crate instantly.

14)Easy experience points
To get easy experience for your home town, start a Skirmish, choose the Sandbox difficulty setting, and the smallest map. Win the game the fastest way possible. You will receive the usual amount of experience, but can do this as many times as desired. If desired, use the cheats to win the game quicker and easier.

15)Revealing the entire map
Save your game and resign. The map will be shown to you as if you had lost. Then, just load the game and keep playing. Note: The map will be shown only between clicking to resign and choosing to quit. It will not continue like this when you start the loaded game.

16)Invincible units
Note: This procedure involves editing a game file; create a backup copy of the file before proceeding. Use a text editor to edit the "proto.xml" file in the "data" directory in the game folder. Find a the heading for a unit in the file (for example, "Explorer"). Locate the area below the heading that starts with the tags. Add a new line under that area with:

<flag>Invulnerable</Flag>
<flag>DoNotDieAtZeroHitpoints</Flag>

17)Super heroes
This is similar to the "Edit resources" trick, except only your side benefits and not the CPU. This trick will enable your hero character to move very fast on the map; have lots of hit points; destroy any enemy unit/building in one click; etc. Note: This procedure involves editing a game file; create a backup copy of the file before proceeding. Use a text editor to edit the "proto.xml" file in the "data" directory in the game folder. Search for your hero's first name plus "SPC". For example, for "Amelia", it is "SPCAmelia". You should find something that looks like the following:

</Unit>
<unit id ='458' name ='SPCAmelia'>
The XML tags of interests are as follows:

<maxvelocity>5.0000</MaxVelocity>
<maxrunvelocity>7.0000</MaxRunVelocity>
<turnrate>18.0000</TurnRate>
<initialhitpoints>850.0000</InitialHitpoints>
<maxhitpoints>850.0000</MaxHitpoints>
<los>24.0000</LOS>
<protoaction>
<name>BuildingAttack</Name>
<damage>14.000000</Damage>
<damagetype>Siege</DamageType>
<rof>3.000000</ROF>
</ProtoAction>
<protoaction>
<name>DoubleBarrelAttack</Name>
<damage>750.000000</Damage>
<damagetype>Ranged</DamageType>
<maxrange>16.000000</MaxRange>
<rof>3.000000</ROF>
<damagearea>1.000000</DamageArea>
<damageflags>GAIAEnemy</DamageFlags>
</ProtoAction>
<protoaction>
<name>HandAttack</Name>
<damage>14.000000</Damage>
<damagetype>Hand</DamageType>
<rof>1.500000</ROF>
</ProtoAction>
<protoaction>
<name>MusketAttack</Name>
<damage>16.000000</Damage>
<damagetype>Ranged</DamageType>
<maxrange>16.000000</MaxRange>
<rof>3.000000</ROF>
</ProtoAction>

Change the above values to create a super hero, as follows.

<maxvelocity>50.0000</MaxVelocity>
<maxrunvelocity>70.0000</MaxRunVelocity>
<turnrate>68.0000</TurnRate>
<initialhitpoints>99999.0000</InitialHitpoints>
<maxhitpoints>99999.0000</MaxHitpoints>
<los>99.0000</LOS>
<protoaction>
<name>BuildingAttack</Name>
<damage>9999.000000</Damage>
<damagetype>Siege</DamageType>
<rof>1.000000</ROF>
</ProtoAction>
<protoaction>
<name>DoubleBarrelAttack</Name>
<damage>9999.000000</Damage>
<damagetype>Ranged</DamageType>
<maxrange>50.000000</MaxRange>
<rof>1.000000</ROF>
<damagearea>1.000000</DamageArea>
<damageflags>GAIAEnemy</DamageFlags>
</ProtoAction>
<protoaction>
<name>HandAttack</Name>
<damage>9999.000000</Damage>
<damagetype>Hand</DamageType>
<rof>1.500000</ROF>
</ProtoAction>
<protoaction>
<name>MusketAttack</Name>
<damage>9999.000000</Damage>
<damagetype>Ranged</DamageType>
<maxrange>50.000000</MaxRange>
<rof>1.000000</ROF>
</ProtoAction>

Note: Do not set the any of the <maxvelocity>, <maxrunvelocity>, or <turnrate> values too high. This will cause your character to "jump" instantly from one spot to the next because their movement speed is so fast. This makes it difficult to move/track your character around the map. The <rof> or rate of fire should be set to a low value. This acts as a delay. The lower the value, the lesser the delay. Note: You can test your changes while the game is running. Just save the current game. Switch over to your text editor, then make changes to "proto.xml" and save the file. Switch back to the game, then reload saved game.

Age Of Empires 3: The Asian Dynasties

1)+10,000 coins give me liberty or give me coin
2)+10,000 experience points nova & orion
3)+10,000 food medium rare please
4)+10,000 wood or
5)Faster building, research, and shipments speed always wins
6)Full map but with fog of war x marks the spot
7)Instant win in Single Player mode this is too hard
8)Destroys all the enemy boats on the map shiver me timpers!
9)Name of unit appears when it destroys another unit or building sooo good
10)Spawn George Crushington where's that axe?
11)Spawn Tommynator tuck tuck tuck
12)Spawn Mediocre Bombard ya gotta make do with what ya got

Cheat Codes of Age of Empire I - The Rise Of Rome

Age of Empire 1
1)Instant building steroids
2)Win scenario home run
3)Kill player kill[player's position 1-8]
4)Rocket launcher car bigdaddy
5)Everyone dies diediedie
6)Resign game resign
7)Full map reveal map
8)1000 food pepperoni pizza
9)1000 gold coinage
10)1000 wood woodstock
11)1000 stone quarry
12)Remove Fog of War no fog
13)Transform villagers medusa
After enabling this cheat, move one of the villagers into an opponent. He or she will transform into a Black Rider after death. The Black Rider will transform into a Heavy Catapult after it dies.
14)Laser gunner photon man
Enable this code after establishing your Empire and clicking on the center of a town.
15)Animal control gaia
16)Juggernauts may move on land flying dutchman
17)Increased catapult range and effect big bertha
18)Priest 600 hit points, speed 6 hoyohoyo
19)Increased ballista range icbm
20)Catapults fire peasants jack be nimble
Enable this code after a catapult is selected.
21)Stealth archer, dressed as tree when still dark rain
22)Turn horse archers into black riders black rider
23)Nuclear missile trooper e=mc2 trooper
24)Commit suicide hari kari

Age Of Empires: The Rise Of Rome
1)New priest unit convert this!
2)Car with a missile launcher big momma
3)Baby on a tricycle with a super-gun pow
4)Combat robot stormbilly
5)Turns eagles into a 999 hp dragons king arthur
6)Animals kill with one bite grantlinkspence
7)Instant building steroids
8)Win scenario home run
9)Everyone dies diediedie
10)Resign game resign
11)Full map reveal map
12)1000 food pepperoni pizza
13)1000 gold coinage
14)1000 wood woodstock
15)1000 stone quarry
16)Remove Fog of War no fog
17)Transform villagers medusa
After enabling this code, move one of the villagers into an opponent. He or she will transform into a Black Rider after death. The Black Rider will transform into a Heavy Catapult after it dies.
18)Laser gunner photon man
Enable this code after establishing your Empire and clicking on the center of a town.
19)Juggernauts may move on land flying dutchman
20)Kill player kill[player's position 1-8]
21)Rocket launcher car bigdaddy
22)Increased catapult range and effect big bertha
23)Priest 600 hit points, speed 6 hoyohoyo
24)Increased ballista range icbm
25)Catapults fire peasants jack be nimble
Enable this code after a catapult is selected.
26)Nuclear missile trooper e=mc2 trooper
27)Commit suicide hari kari
28)Animal control gaia

Age of Empires II - Age of Kings and Conquerors Cheat Codes

Age Of Empires 2: The Age Of Kings
1)1000 gold robin hood
2)1000 wood lumberjack
3)1000 stone rock on
4)1000 food cheese steak jimmy's
5)Instant victory i r winner
6)Instant loss resign
7)Fast building aegis
8)Full map marco
9)Kill indicated opponent torpedo[number]
10)Kill all opponents black death
11)No shadows polo
12)Control animals natural wonders
13)VDML i love the monkey head
14)Cobra car how do you turn this on
15)Saboteur to smithereens
16)Commit suicide wimpywimpywimpy
17)Fast construction [Ctrl] + Q
18)Build immutable structure [Ctrl] + P
19)Alternate resource menu [Ctrl] + T
20)View ending sequence [Ctrl] + C
21)800 x 600 screen resolution 800
22)1024 x 768 screen resolution 1024
23)1280 x 1024 screen resolution 1280
24)Auto save game autompsave
25)Standard mouse pointer NormalMouse
26)Fix display problems with some video cards Mfill
27)Fix SoundBlaster AWE freezes Msync
28)Disable all terrain sounds NoTerrainSound
29)Disable all music NoMusic
30)Disable all sounds except during FMV sequences NoSound
31)No pre-game FMV sequences NoStartup

Age Of Empires 2: The Conquerors
1)1000 food cheese steak jimmy's
2)1000 gold robin hood
3)1000 stone rock on
4)1000 wood lumberjack
5)Cobra car how do you turn this on
6)Commit suicide wimpywimpywimpy
7)Control nature natural wonders
8)Destroy all opponents black death
9)Fast building aegis
10)Flying dogs woof woof
11)Full map marco
12)Instant loss resign
13)Instant victory i r winner
14)Kill Opponent 1 torpedo1
15)Kill Opponent 2 torpedo2
16)Kill Opponent 3 torpedo3
17)Kill Opponent 4 torpedo4
18)Kill Opponent 5 torpedo5
19)Kill Opponent 6 torpedo6
20)Kill Opponent 7 torpedo7
21)Kill Opponent 8 torpedo8
22)Little monkey furious the monkey boy
23)No fog of war polo
24)Saboteur unit to smithereens
25)Tall, fast moving, useless villager i love the monkey head

Age of Mythology and Age of Mythology Titan Cheat Codes

Age of Mythology
Now I days I am playing Age of Mythology and Age of Mythology Titan Expansion. It is always challenge if you play in Titan mode specially with more opponents at a time. I am listing the cheat codes so that I can easily follow them while playing game if needed.

To activate these cheat codes, press enter, type in the code, and then press enter again to activate it.

1)1000 Food JUNK FOOD NIGHT
2)1000 Gold ATM OF EREBUS
3)1000 Wood TROJAN HORSE FOR SALE
4)Chicken meteor god power BAWK BAWK BOOM
5)Enable used god power DIVINE INTERVENTION
6)Expert AI MR. MONDAY
7)Fast construction L33T SUPA H4X0R
8)Faster game LETS GO! NOW!
9)Flying purple hippo WUV WOO
10)Forkboy TINES OF POWER
11)Full map LAY OF THE LAND
12)Herd animals fattened ENGINEERED GRAIN
13)Hide map UNCERTAINTY AND DOUBT
14)Laser bear O CANADA
15)Lightning storm, earthquake, meteor, tornado WRATH OF THE GODS
16)Lots of monkeys I WANT TEH MONKEYS!!!!!
17)Maximum Favor MOUNT OLYMPUS
18)New random god powers PANDORAS BOX
19)Night IN DARKEST NIGHT
20)Red water RED TIDE
21)Reveal all animals on map SET ASCENDANT
22)Slow down units CONSIDER THE INTERNET
23)Small hero campaign army ISIS HEAR MY PLEA
24)Turn enemies into goats GOATUNHEIM
25)Units can move over water CHANNEL SURFING
26)Walking berry bushes god power FEAR THE FORAGE
27)Win scenario THRILL OF VICTORY

29)Hidden taunt
If you want to annoy someone while playing online, type 999 and music will begin to play. It sounds just like the theme music, but with things that sounds like chipmunks singing.

30)Infinite Sons of Osiris
To start, you must be worshipping the major Egyptian God Isis or Ra. Then, advance to the Mythic Age and worship Osiris. Ignore the fact that the mummies that you can make are useless. Then, select either the Temple or Town Center and choose to research the technology. The description is the Osiris issues another Pharaoh to govern your people. After that. Enable the "DIVINE INTERVENTION" code. Do this as many times as desired. Each time it is enabled, you can use each of your God Powers one more time. Then, use the Son of Osiris God Power on both of your Pharaohs to have two Sons of Osiris. About every three to five minutes, another Pharaoh will appear near your Town Center, which you will then use the God Power on. Within fifteen to twenty minutes, you should have about eight to ten of these powerhouses. By doing this, you can wipe out an enemy base that stretches over half of the map without losing one of them. When you have them attack something, the lightening that shoots from their rods will also reach through the initial target to up to four other enemy units or buildings.

31)Son of Osiris kills animals
If your Son of Osiris targets an enemy and there are animals nearby, his chain lightning attack might strike the animals. It kills the weaker animals in a single shot, which is quite funny to watch.

32)Stronger attacks for your units
In any mission or random map game, enable the "PANDORAS BOX" code until you get the Flaming Weapons God power. Enable the "DIVINE INTERVENTION" code as many times as desired. Then, use all of your Flaming Weapons on any unit, all in rapid succession. It will bolster all of your units' attack. When the time runs out for the Flaming Weapons, the high attack value will remain and will not wear off. Note: This requires the latest patch for the game.

33)One way gates
Use the following trick to build a gate that you can use, but not your allies (to prevent them from using the resources around you). First, build a Fortress, Migdol Stronghold, Hillfort, or any kind of Tower. Enclose your city with walls. Have the Fortress or Tower be a part of the walls. When you want a unit to get from one side of the wall to another, have them garrison inside the Fortress or Tower. Then, set the gather point to the opposite side. When you eject the units, they will be on the other side of the wall. Note: This does not work on units that will not garrison inside buildings.

34)King of the Hill
When playing the King of the Hill map, be Poseidon. As soon as the game starts, cast Lure just beside the Plenty Vault in the middle of the map. The Lure Stone will capture the vault. While it will not win you the game (unless if the vault is on an island), it will get you extra resources in the time it takes your opponent to try to reclaim it.

35)Floating enemies
Enter Mount Olympus and get a few Niddhogs. Raid an enemy city and continuously use Meteor Power on large warrior armies. Sometimes an enemy will be floating while kicking their legs. Get rid of them by building over them.

Age of Mythology - Titan Expansion

1)1000 Food JUNK FOOD NIGHT
2)1000 Gold ATM OF EREBUS
3)1000 Wood TROJAN HORSE FOR SALE
4)Chicken meteor god power BAWK BAWK BOOM
5)Enable used god power DIVINE INTERVENTION
6)Expert AI MR. MONDAY
7)Fast construction L33T SUPA H4X0R
8)Faster game LETS GO! NOW!
9)Flying purple hippo WUV WOO
10)Forkboy TINES OF POWER
11)Full map LAY OF THE LAND
12)Herd animals fattened ENGINEERED GRAIN
13)Hide map UNCERTAINTY AND DOUBT
14)Instant Titan TITANOMACHY
15)Laser bear O CANADA
16)Lightning storm, earthquake, meteor, tornado WRATH OF THE GODS
17)Lots of monkeys I WANT TEH MONKEYS!!!!!
18)Maximum Favor MOUNT OLYMPUS
19)New random god powers PANDORAS BOX
20)Night IN DARKEST NIGHT
21)Random unit ownership TINFOIL HAT
22)Red water RED TIDE
23)Reveal all animals on map SET ASCENDANT
24)Slow down units CONSIDER THE INTERNET
25)Small hero campaign army ISIS HEAR MY PLEA
26)Spawn super dog BARKBARKBARKBARKBARK
27)Turn enemies into goats GOATUNHEIM
28)Units can move over water CHANNEL SURFING
29)Use the deconstruction in all buildings and units except settlement for all players RESET BUTTON
30)Walking berry bushes god power FEAR THE FORAGE
31)Win scenario THRILL OF VICTORY

32)Save space with more resources
Once the "DIVINE INTERVENTION" code is enabled to get multiple Plenty Vaults or Dwarven Gold Mines, you can use [Pause Break] to pause game play. Then, all the Plenty Vaults or Gold Mines can be put one over the other. Many Plenty Vaults at the same location will give an enormous gain of space, and give the same amount of resources. Many Gold Mines can be placed like a linked barrier to stop enemies. Many Gaia Forests can be put around a Titan once the game is paused to stop him from moving for the entire scenario, which gives you the freedom to attack whenever one is completely ready. Note: Once the game is resumed, more Plenty Vaults cannot be put at the same location again. Also, the Invoked god power is not visible until the game is resumed.

33)Killing Cerebus
On the level where you have to kill Cerebus, in order to protect the Son Of Osiris train at least 30 Priests to defend him.

34)Avoiding Kronis
On the last level when you have all of the four summoning trees, do not attack the enemies base or Kronos will come from the Tartauras gate and destroy your empire. Kronos cannot be defeated by anyone except Gia.

35)Training Rocs
On the level where the Promeatheus Titan comes, after you have defended your base for the time limit, the Titan will attack you. You must train 3 Rocs and send them to Kastor's base. It is better to train them at the start of the level.

36)Defeating the Norse Titan
In the level that you need to defeat the Norse Titan, enable the "DIVINE INTERVENTION" code a few times. This will allow more usages of the God Power Healing Springs. Put them near all of your allies bases. Then, take the King Frost Giant as well as about ten Fire Giants and ten Giants to attack. If you have extra resources, build up an army to take out the enemy base (in red). The King will freeze the Titan and your Giants will do the attacking. This is a good way to defeat the Titan instead of waiting for the Nidhog.

37)Boats on land
Get the Implode God power. You can get this by being Atlantean and worshipping Atlas; or by using the "ZENOS PARADOX" code. Next, get some boats and bring them as close to the shore as possible. Then, cast Implode just barely in range of the boats. This may require a few attempts; enable the "DIVINE INTERVENTION" code until done correctly. The orb will suck them in. When the orb explodes, they will fly through the air and land on the ground. Note: You cannot move them at all.