1.5. Verification after configuration¶
1.5.1. Verification¶
1.5.1.1. Verifying that the Listener boots.¶
Log in as Oracle user (If “Listener name” is LISTENER)
$ lsnrctl status LISTENER LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-3 -2016 14:45:46 Copyright (c) 1991, 2014, Oracle. All rights reserved. (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle-se2.cloud.lab.oratest.com)(PORT=1521)))
1.5.1.2. The status of Listner¶
Another Name ListenerVersion TNSLSNR for Linux: Version 12.1.0.2.0 - ProductionStart Date 25-03-2016 13:53:00Running time 0day 0hour 52 mins 46secsTrace Level OffSecurity ON: Local OS AuthenticationSNMP OFFParameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.oraLog file /u01/app/oracle/diag/tnslsnr/oracle-se2/listener/alert/log.xmlListening Endpoint Summary(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle-se2.cloud.lab.oratest.com)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oracle-se2.cloud.lab.oratest.com)(PORT=5500))(Security=(my_wallet_ directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))Service SummaryThe service “orcl” has one Instance.The Instance “orcl” at the“READY” state has one handler to this service.The service “orclXDB” has one Instance.The Instance “orcl” at the“READY” state has one handler to this service.The command has successfully finished.Verify that the service has been booting.
1.5.1.3. Verifying that the Instance has booted.¶
Following is the command in the event SID is “orcl”.
$ sqlplus sys@orcl as sysdba SQL*Plus: Release 12.1.0.2.0 Production on 金 3月 25 14:48:19 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Enter password: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production SQL>
1.5.1.4. Verifying the Instance Version.¶
SQL> select banner from v$version;
BANNER
------------------------------------------------------------------------------
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bitProduction
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
You need to verify the contents as “12.1.0.2” as well as “SE2”.
1.5.1.5. Connecting to “EM Database Express”¶
You need to configure the various settings such as Firewall, etc., if you connect to the EM database express from the external environments. For the procedure of how to configure the settings, please refer to “Enterprise Cloud 2.0 Tutorial Documents”.
NOTE: If the Instance Firewall boots at the default state, the EM Database Express will be blocked and fail to connect. If this incident occurs, you need to stop the current utilizing Firewall temporally, then verify the details on the connectivity. Following is how you shut off the utilizing Firewall temporally, as described below.
# systemctl stop firewalld
Following is the destination URL for this procedure environment.
Or, specify the IP Address.
“User Name” : sys
“Password” : Enter the password you configure.
“as sysdba” : check in
After filling in the details, click “Login”.
Finally, you need to verify that your created Database is appeared at the screen, as above.