oedacli> SAVE ACTION
5.
Merge all actions.
oedacli> MERGE ACTIONS
processMerge
processMergeActions
Merging Action : add database dbname='testdb' DATADG='DATAC1' RECODG='RECOC1'
where DBHOMEID='c0_databaseHome'
Merging ADD DATABASE
Action Validated and Merged OK
6.
Save the action to a new Engineered Systems XML configuration file.
oedacli> SAVE FILE NAME ='cli-test-2databases.xml'
File : cli-test-2databases.xml saved OK
7.
Deploy the actions.
oedacli> DEPLOY ACTIONS
Deploying Action ID : 4 add database dbname='testdb' DATADG='DATAC1' RECODG='
RECOC1' where DBHOMEID='c0_databaseHome'
Deploying ADD DATABASE
Running datapatch on database 'testdb'
Done...
Done
3.3.3.6.2 ALTER DATABASE
This command alters an existing Oracle database.
Syntax
ALTER DATABASE
[ BLOCKSIZE = blocksize ]
[ CHARSET = database_character_set
DATADG = data_diskgroup
[ DBLANG = database_language ]
DBNAME = database_name
[ DBTEMPLATE = database_template ]
[ DBTYPE = database_type ]
[ HOSTNAMES = 'host_names' ]
RECODG = reco_diskgroup
WHERE
ID = database_id |
CLUSTERNUMBER = cluster_number DATABASENAME = database_name |
CLUSTERNAME = cluster_name DATABASENAME = database_name |
CLUSTERID = cluster_id DATABASENAME = database_name
Arguments
You can modify the following attributes for the Oracle database:
•
BLOCKSIZE
: Specifies the new block size for the database. The default value is
8192. This argument is not required for pluggable databases.
•
CHARSET
: Specifies the new character set to use for the database. The default
value is
AL32UTF8
. This argument is not required for pluggable databases.
•
DATADG
: (Mandatory) Specifies the name of the DATA disk group for the database.
This argument is not required for pluggable databases.
Chapter 3
OEDA Command Line Interface
3-50