Unable to connect to Oracle 8i (method: OLEDB)

. I'm new to ASP .net. I'm trying to build a ASP .net (2.0) webapps to connect to Oracle 8i. I don't have Oracle client (per se) installed my development server, but I have installed Oracle SQL Plus 8.0 and SQL Navigator 4. I can happily connect to the same 8i with Navigator 4 (home folder is C:\orant). My question is (in order) 1. Do I need to install Oracle client or is SQL Plus 8.0 sufficient for me to connect to 8i using OLEDB method 2. If I have similar code such as the one listed below, why is it that I can't connect to my 8i Private objConn as Data.OleDB.OleDBConnection Sub Page_Load() If objConn.State =0 Then objConn.ConnectionString = "Provider=MSDAORA.1;Data Source=ORADB;Password=pass;User ID=user" objConn.Open() End If objConn.Close() End Sub Do I still need to add in and I've added \LOCALPC\ASPNET user in Security section of my Oracle home folder (including subfolders as well).

Posted On: Wednesday 21st of November 2012 02:05:59 AM Total Views:  375
View Complete with Replies

Related Messages:

unable to start up RAC DB   (328 Views)
I have RAC DB and I wasn't able to start it up, below is the error: SQL> startup ORA-01078: failure in processing system parameters ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings SQL> Obviously, there is a wrong value for shared_pool_reserved_size and I need to somehow get the value so I can change it to the right value. I wasn't able to oen, neither mount the DB so I can't get the information and correct it. How can I fix this issue thx.
unable to start oracle   (432 Views)
i have installed oracle 8.1.6 on windows2000. though it was working fine but recently whenever i try to start the oracle service thru services panel of windows 2000 it is unable to start the service and is throwing the following error ------------------------------- Could not start the OracleServiceANDY2 service Error 1053:the service did not respond to the start or control request in a timely fashion --------------------------------------- kindly give a way out. thanx
unable to start instance with srvctl   (368 Views)
I have configured the listener as per the Oracle documentation: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DCDELBILL1)(PORT = 1525)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home/oracle/product/920) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ccccc) (ORACLE_HOME = /home/oracle/product/920) (SID_NAME = ccccc1) ) ) In the same way I have included ccccc2 and ccccc3 on the listener.ora in the respective nodes! I get the following output when I type services: ---------------------------------------------------------------------------------------------------- $ lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version - Production on 20-MAR-2007 10:29:45 Copyright (c) 1991, 2006, Oracle Corporation. rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DCDELBILL3)(PORT=1525))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version - Production Start Date 20-MAR-2007 10:01:58 Uptime 0 days 0 hr. 27 min. 46 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /home/oracle/product/920/network/admin/listener.ora Listener Log File /home/oracle/product/920/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DCDELBILL3_svs)(PORT=1525))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))) Services Summary... Service "ccccc" has 1 instance(s). Instance "ccccc1", status READY, has 1 handler(s) for this service... Service "ccccc2" has 1 instance(s). Instance "ccccc2", status UNKNOWN, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully ---------------------------------Actual problem with registering the Instances----------------------------------------------------------------------------------- $ $ $ $ srvctl start instance -d ccccc -i ccccc1 PRKP-1040 : Failed to get status of the listeners associated with instance ccccc1 on nodeDCDELB ILL1 PRKP-1001 : Error starting instance ccccc1 on node DCDELBILL1 $ Could any one point out where the issue is if it is with the configuration of listener or elsewhere
unable to log into oracle   (399 Views)
hi, we have been running our oracle 9i rel 2 database installed on Win2k server supported by dual xeon processors for almost 4 months now. was ok till yesterday.. suddenly the bulk inserts failed and thereon the oracle server hanged. we could not log into the oracle server from any of the client machines nor could we do it from the server itself. it simply hanged with no error messages of any kind. the CPU usage of the xeon database server showed 25% being still utilized by the oracle server. This is a very high use of CPU by any standards. Normally it takes hardly 10 -12% of CPU time. How can that be possible when none of the users are connected to the database We have ran bulk inserts even before and never we faced this kind of problem. Finally we had to restart the database server and after doing that it seems its working fine. I have checked the alert log and the trace files but there also couldn't find any problem. Plz suggest me what could have gone wrong and how to find out what's wrong if the same thing reappears.. Parijat Paul
unable to connect to the database   (226 Views)
Hi While trying to connect to the database(TC) I got this error SQL> conn sys/orcl@TC as sysdba ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Can any please help me
i am unable to call my stored function (in oracle 8.1.5)   (290 Views)
i am unable to call my stored function (in oracle 8.1.5) from visual but the same function i am able to call if the server is oracle 8.1.7 what may be the problem CREATE OR REPLACE FUNCTION funCheckUser(varUserID USER.USER_ID%type,varPassword USER.PASSWORD%type) RETURN int is varCount int; begin select count(*) into varCount from USER where USER_ID = varUserID and PASSWORD = varPassword; if varCount = 1 then return 1; else return 0; end if; end funCheckUser;
unable to load dll oci.dll, here is the solution   (302 Views)
Hi . Using to connect to oracle database is really a headache thing, i figure out one solution, which is not very perfect, but at least can get the web applicaiton running. my product server is a win2k3 server, so i add the "Network Authority\Network Serveice" to the administrator group ( you can try the power user group, i havent testeed out yet). why do it like this, because under win2k3, the IIS deligate to the "Network services" user, not IUSER account. so no matter how you grant the permission to IUSER will not solve the problem. This is really not a good idea to do, it may expose some security loophole, so anyone got some good method (by the way, i try only give full control permission to "Network Service" user for Oracle folder, the unable load to load dll problem will solved, but another problem will come out).
unable to generate crystal reports in using mysql database   (291 Views)
hi, i am doing a project wherein i need to connect mysql database with & then generate crystalreports. i have already made the connection & it works fine with my first page set up.i need to take an item from the drop down list which i populated from myfirst webpage & then generate a crystal report for the same.the drop down list is being populated from the database which is myfrist page.later i need to bind this to a crystal report. i am doing it with the push model(mentioned in the site .intially i select a dataset item & then try to drop table from mysql gives me an error stating that the wizard detected the following problem when configuring the data adapter for "table name" error in select clause :expression near"" error in from clause :near"" unable to parse query text. when i do the same that is drag & drop with a diferent database that is sqlserver 2000 i don't face any such problem. would like to weather its not possible of generating a dataset for mysql database using the wizard.later i draged and droped a dataadapter from the tool box and then generated a dataset but i feel that i am conflicting the push method as i am again writing the code for it in the form .when i do this i get an error stating that the "pop up window is blocked". let me know what is the right way of generating a crystal report from mysql databse using a dataset.
unable to load dll (oci.dll) (I am using 9.i client)   (181 Views)
, I have been on many user groups researching this and so far none of the suggestions have helped get rid of this error message, "unable to load dll (oci.dll)" I was using the 8.i client yesterday and it was working great. We had to upgrade to the 9.i client because the 8.i client does not support pentium 4's or higher which is the specs on the target system where this web app will run. As soon as I upgraded none of my Oracle database calls worked any more. Here is the code I am using: Dim Conn As New OracleClient.OracleConnection(CONN_STR_DEV8V2) Dim SelectCommand As New OracleClient.OracleCommand("select IND from APPLICATION_USER where SSN = '" & ssn & "'", Conn) Try Conn.Open() GetInd = SelectCommand.ExecuteScalar() Catch ex As Exception Dim s As String s = ex.Message Finally Conn.Close() End Try The ASPNET account has full permissions on the Oracle directory (located of the root of c:\) The C:\oracle\ora9\bin is in the system path variable. this is currently running on my XP Pro box. Has anyone else found a way around this
unable to read the output parameter value of the stored procedure   (232 Views)
i am trying to retrive data from a oracle9i server using thru a stored procedure. the stored procedure takes in two input parameters and one output parameter. i am not able to get the value of the output parameter in my code. could some one see where i am making a mistake below is the stored procedure: CREATE OR REPLACE procedure sp_testing2 ( l_p number, l_p1 number, l_return out number) is begin if l_p > l_p1 then l_return := l_p; elsif l_p = l_p1 then l_return := 1; else l_return := l_p1; end if; exception when others then l_return := -1; dbms_output.put_line('err'); end; and here is the code which is trying to call the sp so that it can get the output value. Data.IDbConnection connection; Data.DataSet ds; connection = new Oracle.OracleConnection(); ds = new Data.DataSet(); connection.ConnectionString="Data Source=DLNSNA01;User ID=snaadm;password=snaadm;"; connection.Open(); Oracle.OracleCommand cmd = new Oracle.OracleCommand(); cmd.CommandText = "SNAADM.SP_TESTING"; cmd.CommandType = Data.CommandType.StoredProcedure; cmd.Parameters.Add("l_p",Oracle.OracleType.Number); cmd.Parameters[0].Direction = Data.ParameterDirection.Input; cmd.Parameters[0].Value = "20"; cmd.Parameters.Add("l_p1",Oracle.OracleType.Number); cmd.Parameters[1].Direction = Data.ParameterDirection.Input; cmd.Parameters[1].Value = "9"; cmd.Parameters.Add("out1",Oracle.OracleType.Number); cmd.Parameters[2].Direction = Data.ParameterDirection.Output; using (Data.Common.DataAdapter adapter = new Oracle.OracleDataAdapter(cmd)) { adapter.Fill(ds); } connection.Close(); } i am geting a system.error when adapter.Fill(ds) is called. could some one tell me how i can read the value of the output parameter
Periodically unable to connect to Oracle 10g database   (206 Views)
Periodically our ASP.NET 1.1 application fails to connect with our Oracle 10g database with the following error: Could not create an enviroment: OCIEnvCreate returned - 1 Restarting IIS generally corrects the issue and allows the application to continue operation. This became an issue after we installed .net 4.0 framework and Oracle 11.2.0 client to be used by 4.0 applications. Our enviroment is the following: Windows 2003 R2 SP2 Oracle 10.2.0 Oracle 11.2.0
Security Permission Issue - unable to connect to MySQL 4.1 from ASP.NET 2.0 website hosted on shared server   (214 Views)
Hi all, I have done a lot of study on the Internet, Googled countless times on my problem here, checked up with my technical support from the hosting company, yet I don't get a solution. It has something to do with medium trust level in the shared hosting server. Because I don't face any problem when I run the code on my local machine (apparently I have full trust level on my own local machine). The code breaks when it runs on the shared hosting server. I saw some suggestions on recompilation of the reference (I don't think that is a solution for me, since Microsoft should provide a more elegant way to solve this issue I guess), setting the trust level (which sounds very complicated until I don't know how to get them in). I appreciate if someone could help me with a simple working code that I can base on. After many days of searching for a solution, I don't really think there is an easy one out there. ow me to follow up with you in this forum if I can't get your idea in the first place. Thank you very much. The following is the error code I am getting when the ASP.NET 2.0 website runs on the shared hosting server. Server Error in '/' Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Source Error: Line 57: Line 58: OdbcConnection MyConnection = new OdbcConnection(constr);Line 59: MyConnection.Open();
unable to load dll (oci.dll) (I am using 9.i client)   (201 Views)
Im connecting to an oracle9i database and i know the connection string is correct. Ive run this same web application on my colleges computers and it works fine but when I tried running it at my home it returns this error: unable to load dll (oci.dll).I am using 9.i client. Im runnig on XP as admin. Im not sure if there is some configuration steps that i have to go through.
URGENT!! -Import failed : unable to Create Package Body, triggers , Package "Wrapped"   (218 Views)
Dear /Members I created an schema export dump file from my production database running (OS win 2000) When I tried to import into development (running, OS is win2000), a lot of objects (packages, triggers) do not get imported and I get the following error messages: Import failed : unable to Create Package Body, triggers , Package "Wrapped" ORA-03113: end-of-file on communication channel during import Would someone please let us know if they have seen this before and any suggestions as to how to overcome this problem will be highly appreciated!!!
unable to retrieve date format   (145 Views)
Hi I tried to insert a date format into oracle database from a perl script and select the date from the database. However, I encountered ora-01821 data format not recongized format! If i select without the hours&mins I will be able to retrieve it. why is this so insert into table values (to_date(sysdate,'dd-mm-yyyy hh24:mi:ss')); select to_char(datetime,'dd-mm-yyyy hh24:mi:ss') from table;
unable to open DB   (383 Views)
Only one instance is using this DB....coz while creation of DB i had given MAXINSTANCES 1...... am getting below error while opening DB....can any 1 let me know if i am going wrong ne where or do i have to set any thing else....or the very basic close and open wont work Code: SQL> alter database close; Database altered. SQL> alter database open; alter database open * ERROR at line 1: ORA-01531: a database already open by the instance SQL> shutdown ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> Am confused Abhay.
unable to extend index|table by 64000...   (220 Views)
Can someone help. I am running an oracle 8.1.7 on Linux. In one of my tablespaces, if I try to add a segment a following error occurs unable to extend ... by 64000. The initial extent is set to 1M then next extent is set to 1M the pctincrease is set to 0. For example if I create a table "create table xxx (num number) storage (initial 1M nextextent 1M pctincrease 0) tablespace bad_ts" then still the before mentioned error occurs. The tablespace is managed by dictionary. It happens only in bad_ts.
unable to connect to database   (139 Views)
Hi - I'm an Oracle newbie having just installed it on my winxp box for a university project. I've been trying for some time now to connect to it using sql+ but haven't been able to do so. I think I've got my tnsnames.ora file configured correctly: SIMONDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Oracle) ) ) I'd like to be able to connect using the service name "Oracle", but it just doesn't seem to work!
unable to connect / as sysdba   (168 Views)
, I'm using a solaris9 machine with oracle9i SE installed. When i try to connect / as sysdba in sqlplus, the following error came out. Error ORA-01031: insufficient privileges How do I configure so that the machine accept connect / as sysdba to login to sqlplus I login in as root. Thank you. Keith
preventing unable to extend tablespace   (133 Views)
I want to be able to monitor tablespace that is near 100% full. But only tablespaces that has datafile that are not autoextend. Also, if the datafile is autoextend on, i want to see the tablespace only if it is near his maxsize value. Complication: The thing is that i might have more than one datafile related to my tablespace. And i might have the following situation: tablespace USERS datafile 1: 99% autoextend on not near maxsize value datafile 2: 99% autoextend off; So i would not want to see that USERS tablespace in my query. Since it is not near his maxsize value. But i would like to see this scenario: tablespace USERS2 datafile 1: 99% autoextend on near maxsize value datafile 2: 99% autoextend off; Does any one has that kind of query This query is close to what i need but does not work well: select d.tablespace_name "TABLESPACE", sum(d.bytes)/1048576 "SIZE (M)", 100 -(round((FREESPCE/(sum(d.bytes)/1048576))*100)) "USED (%)" FROM dba_data_files d, ( SELECT round(sum(f.bytes)/1048576,2) FREESPCE, f.tablespace_name Tablespc FROM dba_free_space f GROUP BY f.tablespace_name) WHERE d.tablespace_name = Tablespc group by d.tablespace_name,FREESPCE order by 1 asc