Ask The Experts

SMO dataguard repository

mruthner
1,387 Views

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

Brolley_Mike
1,132 Views

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

 

mruthner
1,091 Views

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

Public