Sunday, March 3, 2013

Finding Details Oracle 11G Express Edition

Installed on my Machine OS Windows 7 Home Edition

Oracle 11g Express Edition

lsnrctl status command was helpful in letting me know the following details after execution on the command prompt


C:\Windows\system32>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 03-MAR-2013 16:27:04

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date                02-MAR-2013 22:14:24
Uptime                    0 days 18 hr. 12 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File         C:\oraclexe\app\oracle\diag\tnslsnr\MEDITATE-THINK\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MEDITATE-THINK)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MEDITATE-THINK)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Windows\system32>


Found the database connection details one by one

1521 Port was easy to know
sys or system as username and Passwzerord was easy as I have set it during installation
service name was found by executing the command the output I have

I managed to connect to the server. I ran 'lsnrctl status' in command prompt then I looked at the listeners. and instead of using my localhost and that given port. I used My Laptop's name and port :) 

http://stackoverflow.com/questions/4381215/oracle-11g-and-database-connection

No comments: