Oracle 10gR1 on Win Xp SP1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Oracle 10gR1 on Win Xp SP1

  1. #1
    Join Date
    Oct 2005
    Posts
    9

    Question Oracle 10gR1 on Win Xp SP1

    Hello,
    after I installed Oracle RDBMS I run DBCA to create database-General purpose....
    After successfully created database I found out that in Services I could not start my Listener service so I get this pop-up window:
    "Could not start OracleOraDb10g_home1TNSListener service on Local computer.
    Error 3: The system could not find the path specified."

    My firewall(Zone Alarm) is turned off all the time and in User variable named Path first value is C:\oracle\product\10.1.0\Db1\bin; , same as the first value in System variable PATH.

    Please for You advice.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what happens when you start it from the command line

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    This is XP Pro, right?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Oct 2005
    Posts
    9
    Quote Originally Posted by davey23uk
    what happens when you start it from the command line
    C:\>sqlplus /nolog

    SQL*Plus: Release 10.1.0.2.0 - Production on ╚et Lis 13 01:56:06 2005

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    SQL> conn sys/sistem00@mojabaza as sysdba
    ERROR:
    ORA-12154: TNS:could not resolve the connect identifier specified


    SQL> conn /as sysdba
    Connected.
    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    mojabaza

    SQL>

  5. #5
    Join Date
    Oct 2005
    Posts
    9
    C:\>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-LIS-2005 01:59:05

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MASHINA)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory

    & TNSPING give this result:

    C:\>tnsping listener

    TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-LIS-2005 02:00:00

    Copyright (c) 1997, 2003, Oracle. All rights reserved.

    Used parameter files:
    C:\oracle\product\10.1.0\Db1\network\admin\sqlnet.ora

    TNS-03505: Failed to resolve name

    ...if would help I could paste my listener.ora file here,either way thanks 4 Your time guys.... :o

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What error do you get when you issue
    Code:
    lsnrctl start
    ?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  7. #7
    Join Date
    Oct 2005
    Posts
    9
    Quote Originally Posted by SANJAY_G
    What error do you get when you issue
    Code:
    lsnrctl start
    ?

    C:\>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-LIS-2005 12:27:37

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

    Starting tnslsnr: please wait...

    Failed to start service, error 3.
    TNS-12536: TNS:operation would block
    TNS-12560: TNS:protocol adapter error
    TNS-00506: Operation would block
    32-bit Windows Error: 997: Unknown error



    please help me with some advice

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Check that ORACLE_HOME path specification in your listener.ora is correct. Something like in this example:
    Code:
    ....
        (SID_DESC =
          (GLOBAL_DBNAME = O101)
          (ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
          (SID_NAME = O101)
        )
    ....
    Better yet, post your listener.ora and sqlnet.ora.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Oct 2005
    Posts
    9
    listener.ora

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (PROGRAM = extproc)
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\product\10.1.0\Db1)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MASHINA)(PORT = 1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )

    TRACE_LEVEL_LISTENER = ADMIN



    & sqlnet.ora


    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES)


    & tnsnames doesn't exists in my C:\oracle\product\10.1.0\Db1\NETWORK\ADMIN folder where sqlnet & listener are

  10. #10
    Join Date
    Oct 2005
    Posts
    9
    2 all who were trying to help me & giving they're free time 4 my problems BIG thanks.

    LISTENER service somehow was pointing to C:\oracle\product\10.1.0\db_1\BIN\TNSLSNR.EXE & should have to
    C:\oracle\product\10.1.0\db1\BIN\TNSLSNR.EXE

    so I created new folder & named it db_1 where I paste all folders from db1 because db1 folder just like path to exec. in listener service properties could not be changed.....

    after that I restarted PC and my listener was started, >lsnrctl status gave healty report & problem is solved!

    cheers!
    Last edited by tonijel; 10-13-2005 at 06:17 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width