SnapCenter Powershell Commands
Configure-SmOracleDatabase
Suggest changes
PDFs
Configures Oracle Database in SnapCenter. This includes configuring database authentication with port, ASM authentication with port and Oracle Recovery Manager (RMAN) catalog database. For Oracle RAC database, preferred nodes for backup operation can be configured.
Syntax
Configure-SmOracleDatabase [-AppObjectId] <String> [-DatabaseCredentialName] <String> [-AsmCredentialName] <String> [-OracleRmanCatalogTnsName] <String> [-OracleRmanCatalogCredentialName] <String> [-ASMPort] <Int32> [-DatabasePort] <Int32> [-OracleRACPreferredNodes] <String>
Detailed Description
Configures Oracle Database in SnapCenter. This includes configuring database authentication with port, ASM authentication with port and Oracle Recovery Manager (RMAN) catalog database. For Oracle RAC database, preferred nodes for backup operation can be configured.
Parameters
| Name | Description | Required? | Pipeline Input | Default Value |
|---|---|---|---|---|
AppObjectId |
Specifies the application object identifier of an Oracle Database that needs to be configured. You need to specify the application object identifier format as 'host\database' for Oracle standalone database or 'clustername\database' for Oracle RAC database. |
true |
true (ByPropertyName) |
|
DatabaseCredentialName |
false |
true (ByPropertyName) |
||
AsmCredentialName |
false |
true (ByPropertyName) |
||
OracleRmanCatalogTnsName |
Specifies the TNS name of Oracle Recovery Manager (RMAN) catalog database. |
false |
true (ByPropertyName) |
|
OracleRmanCatalogCredentialName |
false |
true (ByPropertyName) |
||
ASMPort |
Specifies the port where the Oracle ASM listener is running.Default: 1521 |
false |
true (ByPropertyName) |
1521 |
DatabasePort |
Specifies the port where the Oracle Database listener is running.Default: 1521 |
false |
true (ByPropertyName) |
1521 |
OracleRACPreferredNodes |
Specifies one or more Oracle RAC database preferred nodes you want to configure for backup operation. Oracle RAC Nodes must be specified in a comma separated values in the order of their preference. |
false |
true (ByPropertyName) |
Examples
Example 1: Configure database credentials for Oracle Database.
Configure-SmOracleDatabase -AppObjectId host-name\STDDB -DatabaseRunAsName stddb_cred -DatabasePort 1521
This example shows how to configure database credentials for Oracle Database.
Example 2: Configure RAC preferred node settings for Oracle Database.
Configure-SmOracleDatabase -AppObjectId oracle-rac-cluster\RACDB -OracleRACPreferredNodes rac-node1.netapp.com,rac-node3.netapp.com,rac-node2.netapp.com
This example shows how to configure RAC preferred node settings for Oracle Database.