Oracle 12c Cheat Sheet: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
==Quick Check== | ==Quick Check== | ||
Listner status | Listner status <pre>lsnrctl status</pre> | ||
must display something similar to: | |||
<pre> | |||
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 | |||
</pre> | |||
==Connect with SqlPlus== | ==Connect with SqlPlus== | ||
Revision as of 00:47, 7 October 2014
Quick Check
Listner status
lsnrctl status
must display something similar to:
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/