You can connect the DGMGRL interface locally by specifying only the username with the password, or just using /
if OS authentication is possible. If you are connecting from a remote machine, you must use Oracle Net Services name to connect the Data Guard broker. Use the following steps to see some examples of broker connections:
/
as follows:[oracle@oracle-primary ~]$ dgmgrl / DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected. DGMGRL>
sqlnet.ora
file to gain authentication:[oracle@oracle-primary admin]$ cat sqlnet.ora|grep SQLNET SQLNET.AUTHENTICATION_SERVICES = (NONE)
[oracle@oracle-primary]$ dgmgrl / DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. ORA-01031: insufficient privileges
SYS
login credentials as follows:[oracle@oracle-primary]$ dgmgrl sys/free2go DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected.
[oracle@oracle-stby ~]$ dgmgrl sys/free2go@turkey DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected.
show database 'turkey_un'
statement:[oracle@oracle-primary ~]$ dgmgrl sys/free2go "show database 'turkey_un'" DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected. Database - turkey_un Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): TURKEY Database Status: SUCCESS
SILENT
keyword is used, it will suppress the introduction lines of DGMGR as follows:[oracle@oracle-primary]$ dgmgrl -silent sys/free2go@turkey "show configuration verbose" Configuration - PACKT Protection Mode: MaxPerformance Databases: turkey_un - Primary database INDIA_UN - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
EXIT
command as follows:DGMGRL> exit [oracle@oracle-primary ~]$