Moving From MS Access To Oracle SQL Plus
Nov 20, 2012I need to find information on the cost and difficulty in implementing the change from MS Access to Oracle.
View 3 Replies
ADVERTISEMENT
Moving Oracle 11g UNIX Sun Solaries To Oracle 11g Linux Readhat OS
Aug 8, 2012We would be moving oracle 11g unix sun solaries to oracle 11g Linux readhat OS. what would be the disadvantage and what are the item needs to be verified. Basically advantage of oracle 11g Linux readhat OS.
View 2 Replies View RelatedMoving Oracle Binaries BTW Volume Managers
Dec 15, 2010We have Root disk on all the unix servers and is mirrored using SVM using the internal disks. Also VxVM 5.0 MP3 is used as the volume manager to manage the SAN space allocated to the servers. On some instances, SVM is also used for allocating filesystem for application and database
We are required to move all the files from SVM to VxVM.
In the process we are Copying our Oracle binaries from SVM to VXVM.I am planning to use the CPIO command to do the same.Once i move to VXVM (Veritas Volume Manager), i will bring down the SVM.
SQL & PL/SQL :: Moving Images From Server To Oracle Database?
Jun 28, 2011I have a problem(illega use of LONG) while moving image data from SQL Server 2005 database to Oracle10G table in BLOB.
insert into table
select [[mailto:.....tablename@odbc SQL|.....tablename@odbc_SQL]]
I am using HS connection and DBLink.
Server Administration :: Oracle 10gR2 RAC - Moving Archivelog Location
May 25, 2010We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.
View 1 Replies View RelatedApplication Express :: ORA-24247 / Network Access Denied By Access Control List
Apr 5, 2013When 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]...
ORA-24247 / Network Access Denied By Access Control List (ACL)
Dec 12, 2012I 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?
SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)
Nov 15, 2011While 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]....
Oracle 11g Access From Different OS?
Feb 11, 2013I 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?
SQL & PL/SQL :: MS Access 97 To Oracle 10g
Jul 20, 2010I 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 RelatedReports & Discoverer :: Moving Fields In Oracle Reports?
Nov 13, 2010In my requirement i have to move a field from bottom to the first page of report. I try to drag the field but i think it's in multiple frame .i am very new to oracle how can i work with multiple frame in layout wizard.
View 2 Replies View RelatedSecurity :: Moving Application Security To Oracle From Sybase
Aug 18, 2010In Sybase, my application was using system tables to perform application login security. Those tables obviously don't exist in Oracle. I am looking for ways to provide the following functionality in an Oracle world:
1. How to determine 'x' days of inactivity based on "last login date"?
2. How to determine when a new user logs in for the first time and force them to change their password?
3. If we need to reset a users password, how can we require the user to change their password?
4. Is there any other option other than storing a user-id/password in the application code for locking a user's account if their account needs to be locked due to inactivity?
5. In the USER_USERS view there is a status column. What the different status's can be?
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.
Access 2000 With Oracle 9i
Jan 23, 2008I 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.
Networking And Gateways :: MS Access To Oracle DB
Jul 13, 2010I 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.
Oracle 10g On Window 7 - Cannot Access EM By Using Command
Mar 6, 2012I 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 .
Migrate MySQL And Access Databases Over To Oracle 9i
Oct 2, 2008I 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?
Forms :: Import Access Data To Oracle?
Jun 2, 2010when 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>
Forms :: Data Field Access In Oracle
Feb 26, 2013Is 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.
Forms :: How To Access Oracle Database From PDA Device
Feb 21, 2012I 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.
Networking And Gateways :: Access Remote Oracle DB / VB-10G?
Jul 30, 2012I'm using Vb and DB Oracle 10G.
What are the steps for connect oracle DB through internet.
Networking And Gateways :: Connectivity Between MS-Access And Oracle SQL
Feb 3, 2011I 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.
SQL & PL/SQL :: Translating Update Query In Access To Oracle
Apr 13, 2011This 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.
SQL & PL/SQL :: MS Access Query With Linked Tables To Oracle DB
Mar 2, 2011The 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]....
Access Oracle Database From Root User?
Dec 18, 2012i 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.
Access TNS_ADMIN Value In Oracle Through Command Prompt
Jul 6, 2012I 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:>
Windows :: Connecting Oracle To Remote Access Server?
Mar 2, 2011Is 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 RelatedForms :: Tracking Remote Desktop Access Using Oracle?
Sep 27, 2013I 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 RelatedReplication :: Oracle Forms 10g Access Key Property For Button
Jan 22, 2013just 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?
SQL & PL/SQL :: Open Oracle Table In MS Access Frontend - Gives Error?
Oct 26, 2011I 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.