I got an error while trying to install Oracle 9i on a Win XP machine. So, I decided to wipe out Oracle completely and starting again. I deleted all the Oracle entries from the registry and then tried deleting the folder. But while doing that, I am getting the following error - "Cannot delete oci:Access denied"
The disk is neither write-protected nor is the oci.dll file in use.
When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;
[code]...
I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18
is it possible to send mails from oracle database in STANDARD Edition?
While Running the proc,it's raising the below error.
Error report:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33
ORA-06512: at line 1
[code]....
I installed oracle 11g successfully in my windows7 operating system. After installation it is not allowing me to access C drive. And in the properties of the drive the memory of C drive is shown 0 bytes. And other applications installed in C drive are also not working. Even after uninstalling oracle 11g access to C drive is denied.
View 7 Replies View RelatedWhile I am installing oracle 10g on vista i am getting the error ora-12546:tns:permission denied at database configuration Assistant.
View 1 Replies View RelatedI receive errors when trying to backup my database (version 9.2.0.2.0) to an NFS device.
I mounted the NFS device in the HP-UX 11.11 server with the folowing comand :
CODEmount -F nfs -o hard,rw,rsize=32768,wsize=32768,suid,proto=tcp ip_adress:/nfs/RMAN_BACKUPS /rman_backups
the device is succefully mounted.
drwxrwxrwx 2 99 100 17 Nov 25 16:17 rman_backups
When i begin a backup with rman i receive the folwing error :
CODEcanal ORA_DISK_1 : dM-imarrage de l'M-ilM-iment 1 dans 25/11/11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/25/2011 16:35:00
ORA-19504: Echec de crM-iation du fichier "/rman_backups/DB_6jmsi811_1_1.bkupset"
ORA-27041: ouverture du fichier impossible
HP-UX Error: 13: Permission denied
Additional information: 2
Gestionnaire de rM-icupM-iration (Recovery Manager) terminM-i.
It say permission denied but it is set to drwxrwxrwx and i can create and change any file in the directory.
i am getting ORA-01017 error frequently .
we have an application that is running from remote host to connect database using JDBC driver 10.2.0.2
but i am getting ORA-01017 error intermittently. we fetching stored username/pwd after every 5 min but for certain interval it's giving error and we get connection sucessful after some time with same username pwd.
the application monitor more number of databases but facing problem with only 1 instance.
I am learning oracle DBA training course. I tried to find disc space and mail alert .I got permission denied error message.I was running this script in my own pc.
CODE #!/bin/sh
# Shell script to monitor or watch the disk space
# It will send an email to $ADMIN, if the (free avilable) percentage
# of space is >= 90%
[code]...
Using Server 2008 Standard Edition 64 bit. We have been running full client (admin) version 10.2.0 and just installed full client (admin) 11.2.0. Both homes are in my path variable with 11.2 first.
From ODBC Administrator, I can can create new system data sources using the 11.2 client driver and the testing widget built into the data source creator says my connection is good to both 10.2 dbs and 11.2 dbs. So the 11.2 odbc driver would seem to be working.
However, from MS Access, I can only see 10.2 drivers and 10.2 data sources, which fail unless I put the 10.2 home in first place in my path.
I cannot find a way to "access" the 11.2 drivers from MS Access. If I try to create a new data source from inside MS Access, I only see the old 10.2 driver.
I have successfully installed Oracle DBMS 11g R2 on Windows 7 64-bit Ultimate. I can only access the EM using only one user which SYSTEM. Although, I created different users which are unlocked but no success in accessing the EM even with the user name 'SYS'.
View 2 Replies View RelatedHow to connect forms 6i with ms access.
View 1 Replies View RelatedIs it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.
View 5 Replies View RelatedI'm using Microsoft Access 2007 as a front end to Oracle 10g tables using an ODBC Connection. I need to be able to add attachments to the records in one of my linked tables to hold emails, screen shots, log entries etc.
Access 2007 handles this capability with a field format called Attachment. I don't want to store the attachments locally but want them to be stored in Oracle, but I'm not sure what format the field in Oracle needs to be so that it will come across in Access as an Attachment field.
let me know the procedure to connect to Oracle Database from Ms-Access.
We are using Windows as Operating System.
I want to connect to oracle in windows server2008-64 bit by Microsoft OLE DB provider for oracle..is 64-bit Oracle Data Access Components (ODAC) possible for oracle9i?
View 3 Replies View RelatedI was having troubles with deleting some files and folders in windows 7, I used a software called SPAM. It works fine. Do I have any other options to do that thing? Or is it ok to be with SPAM? This tool has more options too.
View -1 Replies View RelatedOS Windows Server2008 R2 64 bit (virtual machine), DB Oracle 11.2.0.1,
emctl:
C: Oracle product 11.2.0 dbhome_2BIN>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
[code]...
I can access database with sql plus.When I try to access dbconsole with IE I get a certificate error (see uploaded picture),clicking "Laden dieser Webseite fortsetzen" has no effect. Disable Windows firewall does not change anything.
There are 2 further databases of same oracle version on this machine. They show the same problem with dbconsole.
I tried to add content of C: Oracleproduct11.2.0dbhome_2200864ORADB.it.ixsystems_CHAMPsysmanlog (for which i stopped service OracleDBConsoleCHAMP). But I can upload only one file, no ZIP.
-- after creation of this topic failed with "You cannot use links until you have posted more than 5 messages" I try to send it without attachment --
In my database smon tracefile was huge,now we want to delete the same,I also tried with ordebug operation but no use, delete tracfile which Smon generates.
View 5 Replies View RelatedON windows environment...i am trying to delete the asm disk recently created with asmtool but it is not allowing me to do that . it seems asmtool gives some system assigned name to it . How to find the name so that i can drop the disk.
1. asmtool -create e:asmasm2.dsk 1024M;
2. asmtool -delete e:asma2.dsk
ASM:00204 : Ignoring ORACLDISKE:E:ASMASM2.DSK not a valid ASM paritition
Successfull installation of my Oracle Client was done.When i opened Enterprise Manage Console and i try to login to a database, the following error occurs
" The procedure entry point kpufhndl() could not be located in the dynamic link library OCI.dll "
What can be done to resovle this error?
I'm attempting to write some SQL to delete a record where it doesn't exist in one of three other tables. My SQL is below:
SELECT COUNT(*) FROM GAZETTEER_ADDRESSES
WHERE NOT EXISTS (
SELECT MEDICALS.*, REVIEWS.*, ADDRESS_HISTORIES.*
FROM MEDICALS INNER JOIN REVIEWS
ON MEDICALS.GADDRE_IDENTIFIER = REVIEWS.GADDRE_IDENTIFIER
JOIN ADDRESS_HISTORIES
ON REVIEWS.GADDRE_IDENTIFIER = ADDRESS_HISTORIES.GADDRE_IDENTIFIER
WHERE GAZETTEER_ADDRESSES.IDENTIFIER = MEDICALS.GADDRE_IDENTIFIER);
When I attempt to run this I receive the following error: ORA-00600: internal error code, arguments: [qcopcovm2], [0], [], [], [], [], [], []
I know it's not generally a good idea to delete records but in this case a large number of cases are incorrect and need to be reinserted and this is the quickest way of doing it.
Declare
Cursor Cur_Emp Is
Select Empno,Ename
From Emp;
Type Type_Emp Is Table Of Cur_Emp%Rowtype Index By Binary_Integer;
[code].......
What i have to do to overcome the following error..whenever im using toad im getting this error since start writing and executing procedures and functions.
access violation at address 006b5b1b in module 'toad.exe' read of address 0000011d
I have a Database that has a frontend in MS Access and a backend in Oracle. When I try to open the Oracle Table/s in the MS Access Frontend, it gives me this error message:
Reserved error (-7711); there is no message for this error.
There is some stuff on the internet about this error but none of it fixes my issue. It seems to be an MS Access error rather than an Oracle error. Only thing is this issue is only on Machines that are running on XP. I have no problem on mine which is Windows 7.
I am trying to create an EXT table but is constantly having the following problem, not sure why. I have done a few checks and used the scripts used as a standard but still is experiencing an error.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "minussign": expecting one of: "double-quoted-string, identifier, single-quoted-string"
KUP-01007: at line 9 column 1
The Table creation script is
CREATE TABLE TABLE1_EXT
(
BUSINESS_DATE VARCHAR2(50 BYTE),
CIN_CODE VARCHAR2(50 BYTE),
CIS_CODE VARCHAR2(50 BYTE)
)
[code]....
And the data used as a sample is
BusinessDate|CIN|CISCode
19062012|1000026697|CTTGLIE
19062012|1000079416|Z29MBGB
We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.
Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.
But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.
ERROR: ORA-12545: Connect failed because target host or object does not exist
I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.
I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:
jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :
I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.
If I change the URL syntax to following, it works
jdbc:oracle:thin:@IP address:port/service_name
But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":" does not work and "/" works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same?
We are test Uniform ODBC drivers. When we run a new Database in Microsoft Access to import tables through the ODBC we get this error
Internal Error – unable to initialise NLS during driver load.
I receive the following error message
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "binary_double,
[code].....
when I select count(*) on the external table created below.
SQL> CREATE TABLE cac_500_load
2 (
3 EMAILADDRESS VARCHAR2(80),
4 FIRSTNAME VARCHAR2(60),
5 LASTNAME VARCHAR2(60),
6 STREETADDRESS VARCHAR2(100),
[code].....
Here is the db version info:
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT