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".
I am able to start SQLPLUS from Start | Program files | Oracle - OraHome92 | Application development |
Unfortunately, when trying to start it from the "command prompt" window with the following command SQLPLUS, it generates the infamous error message like
"... unknown etc... "
Any variables i need to change on my client machine ?
We have siebel server on windows machine and db server on unix box. We have done some modification(added columns) in siebel tools level. Now we want to ddl synch through command line prompt. how ot do ddl sync?
I have a requirement in which i have list pdf files(from thousands of pdf files) having particular string from a command prompt.I have tried find command but that has some limitation. its working upto 3 digit string only.how can i acheive this.remember i have to do this through command prompt only.
Is it possible to take this schema export in windows command prompt mode and any guess how long it would take to complete the export ?Because based on the time it takes, i am going to perform the export in windows command prompt.
Is it possible to ignore the sql command prompt and the command entered while spooling. I tried the to set echo off,term off and some more options but it did not work.
Example:
SQL> spool c: est.log SQL> Prompt "This is a test" "This is a test" SQL> spool off;
The spool file has the following
SQL> Prompt "This is a test" "This is a test" SQL> spool off;
Is it possible to set some options so that the spool file only contains output.
we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?
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;
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
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?
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.
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.
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.
I want to use oracle 9 select * from tab .And use the output to issue "desc XXX " for every row of output in select statement.. .How can I do it automatically ???
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.
I have an agent, actor, movie and producer table, I want to list the details of all agents who represented actors casting in movies produced by "X" (X is the name of producer). I want to know the command for doing this.I have the following tables:
table agent( agentID(pk), fname, sname, city, sex [code]...
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>
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.
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.
