Hi
We're currently doing a POC for oracle RAC one node and i'm having issues trying to create the smo profile here is the error.
[oracle@pocdb1 ~]$ smo profile create -profile TEST -profile-password password -repository -dbname SMOPROD1 -host 10.217.0.32 -login -username smo_rep_owner -port 1521 -database -login -username smo_oper -password password -dbname TEST -host pocdb1 -sid TEST_2 -port 1521 -osaccount oracle -osgroup oinstall -retain -daily -count 7 -duration 7 -hourly -count 4 -duration 24 -monthly -count 12 -duration 12 -weekly -count 4 -duration 4 -snapname-pattern smo_{profile}_{db-sid}_{scope}_{mode}_{smid}
[ INFO] SMO-20020: Set password for profile "TEST" in user credentials for "oracle".
[ERROR] SMO-05075: Profile create failed: ORACLE-00300: Error executing srvctl command srvctl status database -d TEST. The command returned: [Instance TEST_2 is running on node pocdb1, Online relocation: INACTIVE]
[ INFO] SMO-20022: Deleted credentials and repository mapping for profile "TEST" in user credentials for "oracle".
Operation Id [8a9a83744ca34820014ca34824940009] failed. Error: Error executing srvctl command srvctl status database -d TEST. The command returned: [Instance TEST_2 is running on node pocdb1, Online relocation: INACTIVE]
To me it seems as though it doesn't like the output from srvctl status database, does anybody use SMO with oracle RAC one node? I've tried setting up a profile to a RAC database on the same cluster and that seems to work ok.
The output from srvctl status database differ from a RAC database to a RAC one database
RAC database output
[oracle@pocdb1 ~]$ srvctl status database -d TESTRAC
Instance TESTRAC1 is running on node pocdb1
Instance TESTRAC2 is running on node pocdb2
RAC one node database output
[oracle@pocdb1 ~]$ srvctl status database -d TEST
Instance TEST_2 is running on node pocdb1
Online relocation: INACTIVE
Any help appreciated!
Thanks
Tony
