|
| | | Supreme Being
Group: Forum Members
Last Login: Tuesday, March 31, 2009
Posts: 15, Visits: 47 |
| | Below is a copy of the exception i am getting while trying to connect to an Orcale DB and below that are copies of the sqlnet.ora files and the tnsnames.ora files The SQL Plus client connect is successful so the servers are able to connect to each other My reaction is that the tnsnames.ora file is in the wrong location for skelta to find it... i have tried placing a copy in the skelta bin folder Skelta Logger Console content onnection), Module - C:\WINDOWS\assembly\GAC_MSIL\Workflow.NET.NET2\3.5.0.0__c93
2f724c984e915\Workflow.NET.NET2.dll, rgl-pc2953301, Process - SkeltaFarmConfigMg
r, 11/02/2008 07:21:27 AM ! - Connectionstring is invalid, - Could not establish connection to the Oracle
datasource, ORA-12514: TNS:listener does not currently know of service requested
in connect descriptor
, severityLevel: Critical, Module - E:\wwwroot\Applications\Skelta\BPM.NET 2007\
Bin\SkeltaFarmConfigMgr.exe, Source - at Workflow.NET.ConnectionPool.GetDataH
andler()
at Workflow.NET.Storage.DataHandlerFactory.GetDataHandler(String ConnectionSt
ring, String DatabaseType, Int32 MaxRetries, String UserName, String UserPasswor
d, String UserDomain, Int32 DebugLevel)
at Skelta_Console_Setup.CommonInstallationFunctions.CanConnectToCentralConfig
File(String connectionString, String databaseType, String& invalidMsg), rgl-pc29
53301, Process - SkeltaFarmConfigMgr, 11/02/2008 07:21:27 AM i - Connection is invalid, Module - E:\wwwroot\Applications\Skelta\BPM.NET 2007\
Bin\SkeltaFarmConfigMgr.exe, rgl-pc2953301, Process - SkeltaFarmConfigMgr, 11/02
/2008 07:21:32 AM i - Checking if the connection is valid., Module - E:\wwwroot\Applications\Skelt
a\BPM.NET 2007\Bin\SkeltaFarmConfigMgr.exe, rgl-pc2953301, Process - SkeltaFarmC
onfigMgr, 11/02/2008 07:21:53 AM i - Exception while Initialize for OracleDataHandler, System.Data.OracleClient.O
racleException: ORA-12514: TNS:listener does not currently know of service reque
sted in connect descriptor at Workflow.NET.DataHandler.OracleDataHandler.Initialize(Boolean impersonateC
onnection), Module - C:\WINDOWS\assembly\GAC_MSIL\Workflow.NET.NET2\3.5.0.0__c93
2f724c984e915\Workflow.NET.NET2.dll, rgl-pc2953301, Process - SkeltaFarmConfigMg
r, 11/02/2008 07:21:54 AM sqlnet.ora file content TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = LINTEST.WORLD
name.default_zone = world
automatic_ipc = off tnsnames.ora content LINTEST.WORLD=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rgllint)(PORT = 1521))
(CONNECT_DATA =
(SID = lintest)
)
) |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, February 12, 2011
Posts: 133, Visits: 427 |
| Hi,
Skelta uses System.Data.OracleClient.OracleConnection class for creating a connection to oracle dat abase
Can you try opening a test connection from console application and make sure the connection settings are correct
OracleConnection connection = new OracleConnection();
connection.ConnectionString = strConnectionString;
connection.Open();
The below information i took from internet
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
Action: - Wait a moment and try to connect a second time.- Check which services are currently known by the listener by executing: lsnrctl services <listener name>
- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.
- Check for an event in the listener.log file
regards,
Moderator |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Tuesday, March 31, 2009
Posts: 15, Visits: 47 |
| | I have managed to connect to the database via ODBC and via SQL Plus (oracle) client application.. all with the same credentials etc Initially we were having a tns listener problem with the database but have fixed this problem and now the client can connect... however skelta is still throwing the same error I think i found that same solution on google and tried what it said but still not working |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, February 12, 2011
Posts: 133, Visits: 427 |
| Hi,
Can you try opening the connection using System.Data.OracleClient.OracleConnection class.
using System.Data.OracleClient;OracleConnection connection = new OracleConnection();
connection.ConnectionString = strConnectionString;
connection.Open();
Moderator |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Tuesday, March 31, 2009
Posts: 15, Visits: 47 |
| | just posting the solution for anyone who might need it. Skelta requires the Microsoft Transaction Server .dll to be installed. This dll ships with the new versions of the oracle client (and db) but do not install by default. To install these files you need to get back into the OUI (oracle universal installer) after installation and choose the MTS components. Make sure you use the version of the dll that ships with your product or a later version if you are using a version prior to 10.1 otherwise the problem will still occur. Hope this helps Josh |
| |
|
|