The problem is, while installing the Oracle Form and Report 11G R2, my installation got stuck on step 15, i.e configuration progress. Waited for 3hrs and still no progress.
Installing on Win 7 64-Bit, with 4gb ram.
Installed Weblogic Server 10.3.5 64bit(using JDK).
My workflow stuck in Active status and user is not able to proceed further. But it is not happening every time. Sometimes the process activity gets stuck.
View 5 Replies View RelatedI already have 9i installed at my desktop.I tried to install oracle 10g version 1. But it got struck with "oracle database configurations assistant" on configuration assistants window.Then I did the below.
1) I clicked stop, but still didn't get stop.
2) And also the window didn't enable the 'Retro' button
can i install oracle 10g at windows 7 ultimate 32 bit
View 1 Replies View RelatedNeed some input from you on ASM Configuration for Windows XP platform.
1)First I executed the script as below:
<orahome>inlocalconfig add
2) And I had created folder like below manually.
c:asmdisksasmdisk1
3) And now I am firing the below command:
ASMTOOL -create c:asmdisksasmdisk1 250
At this stage I am getting the below error.
======================================
O/S-Error: <OS 5> Access is Denied
======================================
I have installed oracle 10g in D drive . The installation says it is successful, without asking the database name or the password . I have followed the steps given in the attached file .
However it is not asking the database name or password ( no configuration set up is appearing for the user to interact with the system ) . So, after installation I can not give the username and password .
While 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 Relatedwe have third party application which uses oracle database (version 10.2.0.5) on WINDOWS. Our no of process used keeps increasing by 15-20 everyday.
However number of sessions remain constant 32-35 . So in couple of days we reach our limit of max processes and DB needs to be restarted to release processes.
How to identify unwanted process ?? is it safe to kill process(windows threads) which have V$PROCESS.ADDR not equal to V$SESSION.PADDR using orakill or some other third party utility or should I use another way ??
No of sessions remains constant and currently we don't have control over application.
I am trying to trouleshoot an issue with Oracle and want to see what commands are being sent by by process. By reading the documentation it appears there is client logging to do this but I can not get it to work. I added the following commands to my SQLNET.ORA file but no log file is created:
tnsping.trace_directory = C:appproduct11.2.0client_4
etwork race
tnsping.trace_level = admin
trace_level_client = user
trace_directory_client = C:log
log_directory_client = C:log
trace_unique_client = on
trace_timestamp_client = on
Ths TNSPING works just fine it logs the information I expect. The client logging, however, never creates a file .
I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.
View 1 Replies View RelatedI am trying to invoke program from my local Windows machine (exactly java executor, which is in my environment on c:javajdkinjava) using database package with Java stored procedure.
Everything is fired by SQLPLUS script, this script invokes package with Java stored procedure (jar loaded into Oracle) and that procedure is trying to invoke runtime process (syntax:
c:javajdkinjava -cp
and here ara my classes and main jar) using my local java executor. I added all permissions using dbms_java.grant_permisions (execution forced me to give permissions java.io.FilePermission to <<ALL_FILES>> for execute), moreover I added to my database user JAVASYSPRIV and JAVAUSERPRIV role. Unfortunately, beside this I am still getting error:
C:javajdkinjava not found (Note that lookup with PATH isn't done due to the oracle executable being setuid.)
i am using one stored procedure
in which one query is there that is
SELECT to_char(Inpunch,'HH24:mi:ss') into v_Inpunch1 FROM ProcessingPunches
ORDER BY Inpunch ASC WHERE ROWNUM <= 1;
in this i am fetching top 1 value and storing Inpunch value in v_Inpunch1 variable is this query is correct? because i am getting error.
I would like to mention that I won't be able to give the data,specific information(like query or table names) about the issue as this concerns the privacy of some multinational company(where I work).
We have windows server and we are currently using Oracle 10g.
Issue-
We have a ProC, which has a SQL statement where it is trying to OPEN a cursor. The cursor query is huge and fetches data from 3 tables. 3 tables have 5k, 600k and 1.7 millions records respectively but the 'where' condition in cursor query makes the total count to 3k lines only.
Now the problem is , we have a schedule reboot of the server every Saturday night and the next day(Sunday night) when the program runs it gets stuck in the query --> OPEN <cursor> . We wait for 5 hours but this OPEN cursor query never executes or completes, that means our program gets stuck here.Eventually we have to kill the program.We have tried running it after killing as well but it again gets stuck.
Now the interesting part. On Monday business happens as usual but in the night when we again run this program it runs within minutes. The records in the tables are more or less same. Open cursor does not get stuck at all. It runs every night properly but every Sunday night it gets stuck. note that the program does not run on Saturday nights. So on Sunday night it runs for the first time after server reboot.
So there is something with Open cursor statement(with so much data) after server reboot. What exactly Open cursor does in memory or database.
I always get stuck with to_date function.
I keep getting errors when I run this query.
select * FROM table1 WHERE AS_OF_DATE = to_date('9/30/2010 12:00:00 AM','YYYYMMDD HH24:MI:SS')
Error code is : ORA-01858
I have One .FMB Screen and in this Screen One Table , I Compile and attach in ERP System but when I tried to open thst screen is not open and also application is stucking.
View 1 Replies View RelatedI am in process of installing Oracle 11g R2 Grid Infrastructure on 2-node virtual RAC. All went very well until the Grid Installation stuck on 65%. It is saying copying file on remote node ('Copying Oracle Home '/u01/app/11.2.0/grid' to remote nodes 'cxm-vl-rman02'). From the logs it is difficult to figure out where the bottlenecks lies.
View 2 Replies View RelatedI am working on Workflow and the issue is When a person leaves for vacation he can set his vacation rules so that someone has to attend / approve his workflow notifications. But when we set vocation rules all notification goes into errors state and this error can resolve by refreshing/Retry this notification. And the error detail is mentioned below An Error occurred in the following Workflow.
Item Type = CONCSPL
Item Key = 086937-15990
User Key =
Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(cust_f_test.f_find_approver, CONCSPL, 086937-15990, 180198, RUN)
[code]....
Bottom line is all notifition should be successfully process and send to dedicated person.
I installed oracle 11.2.0.1.0 in redhat linux 5 using silent installation(using response file). Then i created a database manualy. While configuring the OEM, iam getting below error messages..
[oracle@meldc1~]$ emca -config dbcontrol db
STARTED EMCA at Apr 6, 2011 11:36:43 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright © 2003, 2005, Oracle. All rights reserved.
[Code].....
I configured listner,tnsnames and sqlnet files and able to login to oracle database using listner.
before executing emca -config dbcontrol db, i have executed emca -repos create to create a oem repository and repository got created successfully.
We have a listener with the password set to it. We are trying to configure that listener to the OEM grid. However, its not getting configured. The status shows as down.
However, when we try to set up without the password, we are able to configure it on the OEM console.
Need to understand, that if passwords are set to the listener; then won't that get configured over the OEM. or is there something where we are lacking.
ISSUE : I have to create ORACLE 10G R2 RAC. This cluster will host two databases pre-prod and prod. Both databases will be on different networks. pre-prod on 10.88.119 and prod on 10.88.118. I just have two hosts forming the this cluster.
How can i configure my hosts file and during clusterware installation what entries should i make for hosts and interfaces. Can this be done in 10g or will have to switch to 11g.
Having below setup : (All this is testing environment)
1.One virtual Machine Guest OS is Windows 8 Pro 64 bit in Oracle Virtual Box
2.In the guest I have Microsoft Visual Studio 64 bit Ultimate Edition
3.Oracle 11.2.0.1 on same host machine windows 7 64 bit
In above Visual studio I wish to use Oracle 11.2.0.1 on same host machine. When I adds sql datasource control, Visual Studio is saying for installation of either one :
(A) Oracle Developer Tools for Visual Studio
(B) Oracle client software version 8.1.7 or greater.
So, I downloaded ODTwithODAC1120320_32bit.zip from below link:
[URL].........
and installation run successfully with a message regarding running installAllOracleASPNETProviders.sql after a new installation. My questions are :
1.When I opened command prompt and said sqlplus / as sysdba it is saying ORA-12560.
2.When I says sqlplus scott/tiger@orcl (I created tnsnames.ora) c:app
ishaproduct11.2.0client_1NetworkAdmin with like this :
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
In above HOST = i am giving IP address of host machine on which this VM is installed and this is also oracle server database machine too, on which I am running Oracle database;
so, after few seconds I am getting, ORA-12154.
How do I connect my orcl database which is running on the same host machine by using above configurations. My virtual machine is visible from other machines as well as oracle database machine too i.e. ping to VM IP is working fine.
I want to Transfer Oracle Database 11g Release 11.1.0.7.0 on windows 2003 32 bit server to Windows 2008 server 64 bit I have Cold RMAN backup. and directory structure of both server are same Do i need to do anything to change datafile to 64 bit or do i need to apply any change to any object
View 6 Replies View RelatedWe have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.
We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:
Problem Event Name: APPCRASH
Application Name: javaw.exe
Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?
We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .
I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:
Checking Operating system version: must be 5.0,5.1,5.2 or 6.0
Actual 6.1
FAILED <<<<
Exiting Oracle Universal Installer
Press any key to Exit.
We are in the design phase of a project and wanting to implement a 4 node RAC with a DR site. However to get around some licensing costs, management are insisting that only 1 node be up accepting data at the DR site. In the event of a disaster, the remaining nodes will be switched on.
View 3 Replies View Relatedi have installed oracle 11g r2 rac with 2 nodes. i want to configure the client side load balancing and server side load balancing. For the client side load balancing the i have configured with the
(FAILOVER=ON) (CONNECT_TIMEOUT=5) (RETRY_COUNT =3).
and to configure server side load balancing i have modified the service as follows:
execute (DBMS_SERVICE.MODIFY_SERVICE (service_name=>'service_name', clb_goal=>DBMS_SERVICE.CLB_GOAL_SHORT);
now i have few questions:
1. for the server side load balancing do we have to configure the REMOTE_LISTENER on each node so that the instance on each node registers with the listeners on other node.
2. if we have 3 nodes does this mean that we have to configure the REMOTE_LISTENER on 3 nodes to register with the listeners on the other remaining 2 nodes.
3. does the listener have to be registered with the vip network address (where the clients usually use to connect).
I get following error when i'm configuring ASM.
I'm using Enterprise Linux and Oracle 11.1.0.6.0
[U]Note:[/U]
[root@RAC1 ~]# rpm -qa|grep asm
oracleasm-2.6.9-78.0.0.0.1.EL-2.0.3-2
oracleasm-support-2.0.3-2
only these two packages in my server. should i have to install oracleasmlib??
[root@RAC1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [ OK ]
[B]Loading module "oracleasm": Unable to load module "oracleasm"
[FAILED][/B]
I don't have this package in my installation cd, when i searched in the web i could not find
I have created a procedure and i am scheduling the procedure to run in dbms jobs. In the procedure, i am using UTL_SMTP connection to receive mail everything is working fine it. In the receipent if i give one email id it is working fine. if i give multiple email id in it am getting error.
View 13 Replies View RelatedI am getting a duplicate SID (ABC1 (2)) on UNIX. I have checked all the possibilities how to remove it but unable to find it. As you you see below:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORATAB:
================================================
ABC1:/oraclehome/oracle10g:Y
================================================
/oraclehome/oracle10g/bin/tnslsnr LISTENER_ABC1 -inherit
================================================
SID_LIST_LISTENFCATDR =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oraclehome/oracle10g)
[Code]...
Result:
ls -lad /orahome/ora10g/dbs/initABC1 (2).ora
ls -lad /orahome/ora10g/dbs/initABC1 (2).ora ; echo ;
/bin/sh: 0403-057 Syntax error: `(' is not expected.
--------------------------------------------------------------------------------------------------------------
what to need to do to avoid this duplication? Is it something wrong with Oracle Listener.ora as it have two listeners (ABC and ABC1) that might be causing duplication?
Specs are as follows:
Linux kernel 2.6.18-274.12.1.el5
Total physical memory - 96G
Oracle version:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production (Standard Edition)
I am having trouble making my spfile parameters take effect and would like to set them manually. Disk reads are very slow, so I thought I would look at the db_cache_size in the spfile:
<INSTANCE>.__db_cache_size=805306368
But, when I look at the parameter via 'show parameter cache':
db_cache_size big integer 0
Digging deeper, I noticed none of my <INSTANCE>.__ parameters match the values returned from 'show parameter'. Most of my concern is sga_target & pga_aggregate_target both being zero.
My memory targets:
memory_max_target big integer 49G
memory_target big integer 49G
I would like to increase the db_cache_size in an attempt to reduce the table scan time.