Oracle 12c Cheat Sheet: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
==Quick Check== | ==Quick Check== | ||
Listner status <pre>lsnrctl status</pre> | Listner status <pre>lsnrctl status</pre> | ||
must display | It must display services (XE or E1Local in this case) : | ||
<pre> | <pre> | ||
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-OCT-2014 20:46:10 | LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-OCT-2014 20:46:10 | ||
Revision as of 00:48, 7 October 2014
Quick Check
Listner status
lsnrctl status
It must display services (XE or E1Local in this case) :
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-OCT-2014 20:46:10 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 06-OCT-2014 17:19:19 Uptime 0 days 3 hr. 26 min. 50 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/diag/tnslsnr/vmsvr075/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmsvr075)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=vmsvr075)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/E1Local/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "E1Local" has 1 instance(s). Instance "E1Local", status READY, has 1 handler(s) for this service... Service "E1LocalXDB" has 1 instance(s). Instance "E1Local", status READY, has 1 handler(s) for this service... The command completed successfully
Connect with SqlPlus
List Users
Create Dabase
Create Database dbca : in /u01/app/oracle/product/12.1.0/dbhome_1/bin/