-
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.
-
what happens when you start it from the command line
-
-
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>
-
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
-
What error do you get when you issue
?
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Originally Posted by SANJAY_G
What error do you get when you issue
?
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
-
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?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|