Oracle 11g Access From Different OS?

Feb 11, 2013

I have Oracle 11g installed in Windows 7 in a machine, now i have Linux distribution (OS) installed in the same machine(Dual boot). I have created database and have database tables available on the oracle database in Windows 7.

Is it possible to connect to the database from Linux distribution using shell script and access the data, execute a stored procedure etc?

View 10 Replies


ADVERTISEMENT

Application Express :: ORA-24247 / Network Access Denied By Access Control List

Apr 5, 2013

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]...

View 4 Replies View Related

ORA-24247 / Network Access Denied By Access Control List (ACL)

Dec 12, 2012

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?

View 1 Replies View Related

SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)

Nov 15, 2011

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]....

View 12 Replies View Related

SQL & PL/SQL :: MS Access 97 To Oracle 10g

Jul 20, 2010

I have a plan to migrate all MS Access 97 based applications into Oracle as backend database and .Net as Front end. I have done migration of MS Access data to Oracle using export, linked tables, etc. from time to time.

View 10 Replies View Related

Access Oracle DB Using Web Interface

Feb 10, 2012

We have implemented PeopleSoft with an Oracle database. What I need to do is provide clients with access to information stored in that database. Some additional information may come from other external databases, however for right now I am just trying to crawl, not run.

I am working on getting table information from the PS provider, so that I can understand what information is available. I am also working with the clients to determine if there are pieces of information that they need access to which are not currently native to the PS implementation. I need to identify these for step 2 of the process. My superiors were looking at using an SOA architecture using SOAP to move the data. I am open to suggestions and since the project is in its infancy, I have time to alter perceptions before it is too late.

View 1 Replies View Related

Access 2000 With Oracle 9i

Jan 23, 2008

I have linked all my tables in access 2000 to my oracle 9I database, created an odbc connection and I can open smaller tables, however when I try to open tables that are accessing more data from other tables, i get the error "ODBC -- call failed, [Microsoft][ODBC Driver Manager] Function sequence error (#0)" Am I using the wrong ODBC Driver? I installed the Oracle 10g SQL*Plus that should have included the correct driver for this setup.

The strange thing is that I do not think it is a driver issue because I can access the smaller tables in the set.

View 1 Replies View Related

Moving From MS Access To Oracle SQL Plus

Nov 20, 2012

I need to find information on the cost and difficulty in implementing the change from MS Access to Oracle.

View 3 Replies View Related

Networking And Gateways :: MS Access To Oracle DB

Jul 13, 2010

I have an Access DB which I'm using to connect to an Oracle DB at work. There are several Oracle DB's that I can connect to using Access but this one I'm not able to connect to. I get the Oracle error ORA-25153 Temporary Table Space is empty.

I don't have the ability to make changes to the Oracle DB only to read and query.

View 1 Replies View Related

Oracle 10g On Window 7 - Cannot Access EM By Using Command

Mar 6, 2012

I installed oracle 10g version 10.2.0.1.0 on window 7 sqlplus is working but when i try to access oracle EM by using command "emctl start dbconsole" it give error

"OC4J Configuration issue. E:\oracle\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_Console_192.168.1.3_orcl not found".

although i have assigned ip address as well .

View 3 Replies View Related

Migrate MySQL And Access Databases Over To Oracle 9i

Oct 2, 2008

I need to migrate MySQL and Access databases over to Oracle 9i. Is there a tool that will do this and also migrate sql scripts?

I heard of Oracle Workbench as one tool I could use?

View 4 Replies View Related

Forms :: Import Access Data To Oracle?

Jun 2, 2010

when i create db link then it show below:

SQL> conn sys as sysdba
Enter password: ********
Connected.
SQL> show user
USER is "SYS"
SQL> create database LINK orafaccess using 'ORAFACCESS';
Database link created.
SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD
SQL>

View 10 Replies View Related

Forms :: Data Field Access In Oracle

Feb 26, 2013

Is there a way to apply changes to a data field on oracle forms for specific users?

For example, I have an oracle form that applies the below masking code for a certain field called CUSTOMER_ID

IF :SYSTEM.BLOCK_STATUS = 'QUERY' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);
ELSE
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_FALSE);
END IF;

But I only want this masking to be applicable to CERTAIN users. For example, the psuedo code would be like

IF :SYSTEM.BLOCK_STATUS = 'QUERY' and USERS_LIST = 'SUPERVISORS' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);

Note that this users_list is a group of oracle database users, so I am a member of this group. Also note that this form is applied via the web via the application server.

View 1 Replies View Related

Forms :: How To Access Oracle Database From PDA Device

Feb 21, 2012

I have one PDA device. I need to run a Oracle form developed in Oracle forms 6i on this PDA by connecting it to the Oracle 10G database running on Linux Server.

I need to know is there any Oracle client for windows 6.0 OS. if yes then how can i install it on PDA and access the Oracle database through forms.

View 1 Replies View Related

Networking And Gateways :: Access Remote Oracle DB / VB-10G?

Jul 30, 2012

I'm using Vb and DB Oracle 10G.

What are the steps for connect oracle DB through internet.

View 10 Replies View Related

Networking And Gateways :: Connectivity Between MS-Access And Oracle SQL

Feb 3, 2011

I am currently using Oracle 10.2.0.1 version, in a single PC (test server) and MS-Access (2003) in it.

I was trying to use the logic of HS ODBC connectivity, but when i try to select the table from the MS-Access i am getting the following error.

"ORA-12154: TNS:could not resolve the connect identifier specified".

to create the successful connection between the MS-ACCESS and ORACLE. I just need to read some data from MS-ACCESS on a monthly base from a particular table.

View 1 Replies View Related

SQL & PL/SQL :: Translating Update Query In Access To Oracle

Apr 13, 2011

This is my working query in ms access...

UPDATE Caxnode AS A INNER JOIN Caxnode AS B ON A.node_alias = B.node_alias SET A.partition_Type = 'LDOM', A.node_mode = 'LOGICAL', A.host_id = b.host_id, A.num_of_proc = b.num_of_proc WHERE (((A.node_mode)='virtual' Or (A.node_mode)='regular') AND ((B.partition_Type)='LDOM'));

This doesn't work in oracle, I Googled and read that update doesn't work with inner join in oracle.

View 2 Replies View Related

SQL & PL/SQL :: MS Access Query With Linked Tables To Oracle DB

Mar 2, 2011

The code was originally an MS Access Query with linked tables to the Oracle DB however trying to remove the need for access and have it drop directly into Excel using Recordset.

SELECT
SWPRO.CASE_INFORMATION.CASEDESC,
SWPRO.OUTSTANDING_MAIL.CASENUM,
CASE_DATA_1.FIELD_VALUE,
SWPRO.OUTSTANDING_MAIL.SENTDATE,
SWPRO.OUTSTANDING_MAIL.DEADDATE
FROM

[code]....

View 20 Replies View Related

Access Oracle Database From Root User?

Dec 18, 2012

i have an linux instance running oracle 11g as oracle OS user. i am able to connect the DB from clients.

i need to access this DB from OS root user. what should i do.

View 7 Replies View Related

Access TNS_ADMIN Value In Oracle Through Command Prompt

Jul 6, 2012

I am trying to get the TNS_ADMIN value but I m an not getting Expected Results . My tnsNames.Ora are located at the following locations : -

1) C:oracleproduct10.2.0client_1NETWORKADMIN
2) C:oraclexeapporacleproduct11.2.0server

NetworkADMIN

As you can see from the belowcode, TNS_ADMIN is not displaying the correct location.

C:>set TNS_ADMIN=%ORACLE_HOME%
etworkadmin

C:>echo %TNS_ADMIN%
%ORACLE_HOME%
etworkadmin

C:>echo %ORACLE_SID%
%ORACLE_SID%

C:>

View 4 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is 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 Related

Forms :: Tracking Remote Desktop Access Using Oracle?

Sep 27, 2013

I have a form developed using Oracle 10g Forms Builder. It is deployed on server. I need to track who is remotely accessing the desktop and running this form. How can we track this. Are there any webutil commands to trace the application used to access the desktop? What is the work around for this?

View 2 Replies View Related

Replication :: Oracle Forms 10g Access Key Property For Button

Jan 22, 2013

just i want to ask about access key property for button..i'm using oracle forms 10g ,

suppose that i have 3 buttons in a module like the following:

1- buttonOne --access key property for this button is "1"
2- buttonTwo --access key property for this button is "2"
3- buttonThree --access key property for this button is "3"

when run this module then the user press "1" the trigger when-button-pressed not fire until he press Alt+1...how the user can press the "1" only to fire the trigger when-button-pressed? just like form 6i?

View 6 Replies View Related

SQL & PL/SQL :: Open Oracle Table In MS Access Frontend - Gives Error?

Oct 26, 2011

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.

View 7 Replies View Related

Windows / .NET :: Microsoft Access Attachment Field And Oracle

Oct 1, 2012

I'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.

View 2 Replies View Related

ORA-12547 / TNS / Lost Contact / Access Oracle Database 11.2.0.3

Dec 7, 2012

I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.

ID ORACLE
uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t

The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.This user belongs to dba.But when trying to access Oracle via sqlplus gives this error:

-bash-3.2$ sqlplus davinci/xxxxxxx
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:

However, if you connect using a network descriptor works correctly.

SQLPLUS DAVINCI/xxxx@tns_alias

So there must be a problem with access to local resources.This user has the same profile file variable (. Bash_profile)

View 6 Replies View Related

Windows / .NET :: Procedure To Connect To Oracle Database From MS Access?

Nov 29, 2012

let me know the procedure to connect to Oracle Database from Ms-Access.

We are using Windows as Operating System.

View 1 Replies View Related

Installation :: C Drive - Access Denied After Installing Oracle 11g

May 4, 2013

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 Related

Can Access Extract Data From Oracle DB For Automated Upload

Dec 14, 2012

Is it possible for Access to extract data from an Oracle database and upload it directly?

Currently we have a business process where data is being extracted in scheduled queries (30+) to Excel spreadsheets, then manually edited to remove heading lines and imported to an Access database. I see an opportunity to automate a time consuming manual activity by having the Access db extract the data and directly upload it.

View 3 Replies View Related

Windows :: Is 64-bit Oracle Data Access Components (ODAC) Possible For 9i

Jan 27, 2013

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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved