Oracle 10gR1 on Win Xp SP1

[tonijel]

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.

[davey23uk]

what happens when you start it from the command line

[slimdave]

This is XP Pro, right?

[tonijel]

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>

[tonijel]

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

[SANJAY_G]

What error do you get when you issue

lsnrctl start

?

[tonijel]

What error do you get when you issue

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

[jmodic]

Check that ORACLE_HOME path specification in your listener.ora is correct. Something like in this example:

....
    (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.

[tonijel]

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

[tonijel]

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!