OraFAQ Forum: Server Administration » ODP.net connection giving me headaches

Home » RDBMS Server » Server Administration » ODP.net connection giving me headaches

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ODP.net connection giving me headaches [message #119977]

Tue, 17 May 2005 02:00

Donrajah
Messages: 6
Registered: May 2005

Junior Member

I have never tried to work on Oracle before,i have to admit that before i post this troublesome question.Now the client requires me so for a project

I am asking for help on connectivity to oracle on my local machine.These are below are my ora files

# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

# NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST=
       (ADDRESS = (PROTOCOL = TCP)(HOST = Donrajah)(PORT = 1521))
     )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

# listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

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

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = sanu-lh8aj1c8zf)(PORT = 1521))
      )
    )
  )

Problmes are here
1. I am building a .net application that requires me to connect to backend database.
I keep getting this error

Error Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleConnection.Open()
at ODP.Program.Main(String[] args) in D:\Documents and Settings\Donrajah\Desktop\ODP\ODP\ODP\Program.cs:line 17
Disconnected

2.When i tnsping orcl i get
Used parameter files:
C:\Oracle\product\10.1.0\Client_1\network\admin\sqlnet.ora error???

3.I cannot start the TNSLIstener from Services manually gives me this error
Cannot start TNSListener on local computer.
Error 3: The system cannot find the path specified

. I cannot connect to my local database.In few days have to show up something that would require me to connect to a remote database.Pls tell me what to check for so that i may have a successful connectivity and demonstrate my work

Cheers n all possible help needed

DonRajah

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120018 is a reply to message #119977]

Tue, 17 May 2005 05:39

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

in sqlnet.ora

Comment this by putting # symbol
SQLNET.AUTHENTICATION_SERVICES= (NTS)
and uncomment this by removing any # symbols
# NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120141 is a reply to message #119977]

Tue, 17 May 2005 22:40

Donrajah
Messages: 6
Registered: May 2005

Junior Member

Hello Girish

Thanks for your response.I did make the changes but no luck..

Error Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleConnection.Open()
at ODP.Program.Main(String[] args) in D:\Documents and Settings\Sanu P\Desktop\ODP\ODP\ODP\Program.cs:line 17
Disconnected

I still get this error:
These are services that ran when i ran the programme
OracleCSService,
OracleDBConsoleorcl,
OracleMTSRecoveryService,
OracleOraDb10g_home1iSQL*Plus
OracleOraDb10g_home1SNMPPeerEncapsulator,
OracleOraDb10g_home1SNMPPeerMasterAgent,
OracleOraDb10g_home1TNSListener---> giving me error not started
OracleServiceORCL

I have another question is all of them required to start.Otherwise the ones needed for ODP.net connectivity i can start manually .I mean those i need.

Please help

DonRajah

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120147 is a reply to message #119977]

Wed, 18 May 2005 00:07

Donrajah
Messages: 6
Registered: May 2005

Junior Member

also when i start the listener this is wht i get

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-MAY-2005 04:55
:03

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start listener
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
------------------------
# sqlnet.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
-----------------------------------------------------
# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = sanu-lh8aj1c8zf)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

--------------------------------------
# listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

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

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sanu-lh8aj1c8zf)(PORT = 1521))
)
)
)

--------------------------------------
Still no luck!!
Thanks
DonR

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120161 is a reply to message #120147]

Wed, 18 May 2005 02:16

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

Use the following listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sanu-lh8aj1c8zf)(PORT = 1521))
)
)
)

This shd resolve the issue.

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120301 is a reply to message #119977]

Wed, 18 May 2005 19:22

Donrajah
Messages: 6
Registered: May 2005

Junior Member

buddy still giving me error..

LSNRCTL> start
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

this is the error i get when i start the listener.I am sure i am missing something here..Is there anything i should do before starting the listener.

Sorry guys for the trouble i am givin ya

Cheers
DonRajah

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120474 is a reply to message #120301]

Fri, 20 May 2005 01:03

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

U r connecting to OS using which user?

Try connecting using the administrator...

Sorry for this really vague reply... but it worked for Ashok Shinde from India.
Source: http://asktom.oracle.com/pls/ask/f?p=4950:8:12909640354414541474::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1281675938015

Well, as for error 997: its reason in windows is:

C:\>net helpmsg 997

Overlapped I/O operation is in progress.

Regds
Girish

Report message to a moderator

Re: ODP.net connection giving me headaches [message #120475 is a reply to message #120474]

Fri, 20 May 2005 01:09

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Also, pls check if u r running any firewall service on ur machine. Do try after stopping/bypassing that,
As operation bloack can be cause by firewalls as well.

Report message to a moderator

Previous Topic:	Unknown error (for me)
Next Topic:	unable to lock file - alread y in use

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 08:27:16 CST 2025