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. |
Verify that created database has been displayed.