Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2011
    Posts
    6

    Unanswered: Can not access my database via sqlplus and Toad

    Hello everyone!
    I'm struggling with this problem: I can not access my 10g Oracle database through SQLplus or Toad; Yet, I can access it via SQLplus in DOS commands. When I TNSPing it, it returns OK.
    Furthermore, I can no longer access it through the web page (Entreprise manager). It appears that my database is blocking every utility rather than the SQLplus under DOS commands.
    I appreciate your reading this post and I'll be thankfull if somebody could enlighten me.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    open Command Window & issue OS commands below

    lsnrctl status
    lsnrctl service

    COPY the results from above then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2011
    Posts
    6
    Hello!
    Here are the copied info:
    - For lsnrcl status:

    C:\Users\adem>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 20-ع╟و -2013 21
    :31:38

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Adem-PC)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
    ction
    Start Date 20-ع╟و -2013 09:11:02
    Uptime 0 days 12 hr. 20 min. 38 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File c:\oracle1\product\10.2.0\db_1\network\admin\liste ner.
    ora
    Listener Log File c:\oracle1\product\10.2.0\db_1\network\log\listene r.lo
    g
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Adem-PC)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "rms" has 1 instance(s).
    Instance "rms", status READY, has 1 handler(s) for this service...
    Service "rmsXDB" has 1 instance(s).
    Instance "rms", status READY, has 1 handler(s) for this service...
    Service "rms_XPT" has 1 instance(s).
    Instance "rms", status READY, has 1 handler(s) for this service...
    The command completed successfully
    ------------------------------------------------------------------------

    For the lsnrctl service:

    C:\Users\adem>lsnrctl service

    LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 20-ع╟و -2013 21
    :34:50

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Adem-PC)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "rms" has 1 instance(s).
    Instance "rms", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:1 refused:0 state:ready
    LOCAL SERVER
    Service "rmsXDB" has 1 instance(s).
    Instance "rms", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1002 state:ready
    DISPATCHER <machine: ADEM-PC, pid: 6740>
    (ADDRESS=(PROTOCOL=tcp)(HOST=Adem-PC)(PORT=51883))
    Service "rms_XPT" has 1 instance(s).
    Instance "rms", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:1 refused:0 state:ready
    LOCAL SERVER
    The command completed successfully
    ---------------------------------------------------------------------------------

    Thanks for trying to help me out

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post last 50 or so lines from file below

    c:\oracle1\product\10.2.0\db_1\network\log\listene r.log
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2011
    Posts
    6
    I guess this is lot of lines to read, sorry for the burden:
    ************************************************** ***********
    0
    20-مايو -2013 14:12:39 * service_update * rms2 * 0
    20-مايو -2013 14:14:36 * service_update * rms * 0
    20-مايو -2013 14:16:36 * service_update * rms * 0
    20-مايو -2013 14:16:39 * service_update * rms2 * 0
    20-مايو -2013 14:18:43 * service_update * rms2 * 0
    20-مايو -2013 14:20:37 * service_update * rms * 0
    20-مايو -2013 14:24:44 * service_update * rms2 * 0
    20-مايو -2013 14:26:42 * service_update * rms * 0
    20-مايو -2013 14:30:42 * service_update * rms * 0
    20-مايو -2013 14:35:23 * service_update * rms2 * 0
    20-مايو -2013 14:36:23 * service_update * rms * 0
    20-مايو -2013 14:45:25 * service_update * rms2 * 0
    20-مايو -2013 14:46:07 * service_update * rms2 * 0
    20-مايو -2013 14:48:10 * service_update * rms * 0
    20-مايو -2013 20:26:57 * service_update * rms2 * 0
    20-مايو -2013 20:26:57 * service_update * rms * 0
    20-مايو -2013 20:27:06 * service_update * rms * 0
    20-مايو -2013 20:28:57 * service_update * rms * 0
    20-مايو -2013 20:30:00 * service_update * rms2 * 0
    20-مايو -2013 20:30:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.4.207)(PORT=4997 0)) * establish * rms * 0
    20-مايو -2013 20:32:03 * service_update * rms2 * 0
    20-مايو -2013 20:35:00 * service_update * rms * 0
    20-مايو -2013 20:37:55 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    20-مايو -2013 20:38:01 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    20-مايو -2013 20:38:01 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    20-مايو -2013 20:39:00 * service_update * rms * 0
    20-مايو -2013 20:39:06 * service_update * rms2 * 0
    20-مايو -2013 20:39:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Oracle1\product\10.2.0\db_1\bin\s qlplusw.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.4.207)(PORT=5036 7)) * establish * rms * 0
    20-مايو -2013 20:41:01 * service_update * rms * 0
    20-مايو -2013 20:44:13 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=504 00)) * establish * rms * 0
    20-مايو -2013 20:44:31 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\RUNITEL\InpursuitAR\inpursuit.exe )(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=504 01)) * establish * rms * 0
    20-مايو -2013 20:45:06 * service_update * rms2 * 0
    20-مايو -2013 20:46:06 * service_update * rms2 * 0
    20-مايو -2013 20:47:04 * service_update * rms * 0
    20-مايو -2013 20:47:59 * service_update * rms2 * 0
    20-مايو -2013 20:48:08 * service_died * rms2 * 12537
    20-مايو -2013 20:49:11 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=504 11)) * establish * rms * 0
    20-مايو -2013 20:53:05 * service_update * rms * 0
    20-مايو -2013 20:58:05 * service_update * rms * 0
    20-مايو -2013 20:59:05 * service_update * rms * 0
    20-مايو -2013 21:00:51 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.4.207)(PORT=5115 1)) * establish * rms * 0
    20-مايو -2013 21:04:08 * service_update * rms * 0
    20-مايو -2013 21:06:08 * service_update * rms * 0
    20-مايو -2013 21:10:08 * service_update * rms * 0
    20-مايو -2013 21:16:11 * service_update * rms * 0
    20-مايو -2013 21:18:11 * service_update * rms * 0
    20-مايو -2013 21:21:11 * service_update * rms * 0
    20-مايو -2013 21:21:55 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=517 83)) * establish * rms * 0
    20-مايو -2013 21:25:28 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=c:\oracle1\product\10.2.0\db_1\bin\s qlplus.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=518 59)) * establish * rms * 0
    20-مايو -2013 21:26:28 * service_update * rms * 0
    20-مايو -2013 21:27:04 * service_update * rms * 0
    20-مايو -2013 21:28:03 * service_died * rms * 12537
    20-مايو -2013 21:28:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=518 82)) * establish * rms * 12514
    TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
    20-مايو -2013 21:28:42 * service_register * rms * 0
    20-مايو -2013 21:28:48 * service_update * rms * 0
    20-مايو -2013 21:28:54 * service_update * rms * 0
    20-مايو -2013 21:28:57 * service_update * rms * 0
    20-مايو -2013 21:30:37 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=519 53)) * establish * rms * 0
    20-مايو -2013 21:31:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=adem))(C OMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VER SION=169870080)) * status * 0
    20-مايو -2013 21:33:06 * service_update * rms * 0
    20-مايو -2013 21:34:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=adem))(C OMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(V ERSION=169870080)) * services * 0
    20-مايو -2013 21:37:22 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=520 96)) * establish * rms * 0
    20-مايو -2013 21:39:07 * service_update * rms * 0
    20-مايو -2013 21:44:10 * service_update * rms * 0
    20-مايو -2013 21:45:10 * service_update * rms * 0
    ************************************************** *************

  6. #6
    Join Date
    Jan 2011
    Posts
    6
    Hello again!
    When I connect through SQLplus and provide the username and password without the service name it connects. However, it does not with Toad.

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >20-مايو -2013 21:21:55 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=517 83)) * establish * rms * 0
    >20-مايو -2013 21:37:22 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=rms) (CID=(PROGRAM=C:\Program?Files??x86?\Quest?Softwar e1\Toad?for?Oracle\toad.exe)(HOST=ADEM-PC)(USER=adem))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=520 96)) * establish * rms * 0

    Both records above show a successful connection to the DB by toad.exe
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •