2.5. Verification after configuration

2.5.1. Sign in

With RDP, sign in as an oracle user.

2.5.2. Verifying that the Listener boots.

If the listener name is “LISTENER”, execute the command below in PowerShell.

PS C:\Users\oracle> lsnrctl status LISTENER
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 08-DEC-2016 17:49:21
Copyright (c) 1991, 2014, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle-se2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date                08-DEC-2016 17:33:23
Uptime                    0 days 0 hr. 15 min. 59 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\oraclehome\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File         D:\app\oraclehome\diag\tnslsnr\oracle-se2\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle-se2)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oracle-se2)(PORT=5500))(Security=(my_wallet_directory=D:\APP\ORACLEHOME\adm
in\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

2.5.3. Verifying that the Instance has booted.

Execute the following command in PowerShell.

PS C:\Users\oracle> sqlplus / 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.

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

2.5.4. Verifying the Instance Version.

Execute the following command in PowerShell.

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for 64-bit Windows: 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”.

2.5.5. Connecting to “EM Database Express”

To access from the Windows Server that Oracle has been installed (e.g. oracle-se2), it is necessary to install Adobe Flash Player. Execute the command below in PowerShell.
PS C:\Users\Administrator> Install-WindowsFeature Desktop-Experience

In this example, the destination URL is https://192.168.1.101:5500/em . After entering the following items, mark the checkbox of as sysdba and click [ Login ].

User Name sys
Password

The password specified at the timing of instance creating.

../../_images/image084.png

Verify that created database has been displayed.

../../_images/image0851.png