2014-04-10 1:00 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH <[email protected]>: > What does > > lsrnctl status > > Return? That will report back the status of the listener and the host, > port and sid info.
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 - Produ ction Start Date 09-DUB-2014 03:26:29 Uptime 0 days 21 hr. 39 min. 33 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\a dmin\listener.ora Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\geo1\listener\aler t\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=geo1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=geo1)(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 LSNRCTL> I tried ogrinfo -ro OCI:user/password@localhost:1521/xe -sql "select count(*) from emp" and ogrinfo -ro OCI:user/password@geo1:1521/xe -sql "select count(*) from emp" but with no success. Martin -- Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
