How to register database using odacli on ODA ?
Registering oracle database using odacli register-database on ODA machine.
Prerequisites for registering database in ODA.
- Instance name ,database name should be in uppercase.
- wallet_root = ‘/opt/oracle/des/commonstore/wallets/tde/ORCLDW/tde
- sqlnet.ora should contain entries as given below.
- ODA storage should be created. Create dbstorage on Oracle Database Appliance (ODA)
$cat sqlnet.ora
SQLNET.ALLOWED LOGON VERSION CLIENT=11
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
ENCRYPTION_WALLET_LOCATION =
(SOURCE=
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/tde/ORCLDW)
))
# odacli register-database -c OLTP s odb1 -sn ORCLDW -tp
Enter SYS, SYSTEM and PDB Admin user password:
Retype SYS, SYSTEM and PDB Admin user password:
Enter TDE wallet password:
Retype TDE wallet password:
{
“jobId” : “6caf2d95-b92f-454a-b9d3-0374c4c9c4b3”,
“status”: “Created”,
“message”: null,
“reports”:[],
“createTimestamp”: “September 25, 2023 06:22:07 AM EDT”,
“resourceList”:[],
“description”: “Database service registration with db service name: ORCLDW”,
“updatedTime” : “September 25, 2023 06:22:07 AM EDT”,
“jobType”: “”
}
#
see also