Ask The Experts

Highlighted

SMO dataguard repository

When creating a repository, is it possible to supply a TNS string rather than a combination of hostname:port:SID for the repository?

As per help it is not possible:

repository create -repository -port <repo_port> -dbname <repo_service_name> -host <repo_host> -login -username <repo_username> [-force] [-noprompt] [-quie t | -verbose]

svphg200ddb001_oracle:~> smo version
SnapManager for Oracle version: 3.3
svphg200ddb001_oracle:~>

2 REPLIES 2

Re: SMO dataguard repository

SMO will configure the Repository access in hostname:port:SID format, and all log files will report the connection in that manner.  It is per SMO design.

 

Thanks,

Mike Brolley

 

Re: SMO dataguard repository

Hi Mike Thanks for the reply.

Too bad, we have a dataguard solution for our catalog and cannot really use it for smo because of this restriction.

Is it planned to add tns strings as alternative for host:port:SID?

Best regards,

Martin

Forums