Windows :: JREW.EXE Has Stopped Working?
May 19, 2011jrew.exe has stopped working when iam trying to install oracle8i on WINDOWS 2008 SERVER.
View 1 Replies
ADVERTISEMENT
Windows / .NET :: ODBC Administrator Has Stopped Working
Dec 8, 2012I installed the Oracle instant client version 10.2.0.3 and the corresponding ODBC driver. When I try to add a DSN in ODBC Manager using the Oracle driver, it crashes and I get this message:
"ODBC Administrator has stopped working"
"Windows is checking for a solution to the problem..."
Trying to isolate this problem, I ran odbcad32.exe under DependencyWalker and it worked correctly without crashing. According to the Dependency Walker FAQ, this can be due to a "buffer overrun, stray/bad/freed pointer, etc.". They have a switch to set SET NODEBUG_HEAP=1 to check for this. When I did this, it crashes insider DependencyWalker also.
Forms :: Oracle 6i Runform Has Stopped Working Windows 7
Nov 25, 2012I have an oracle application (Froms 6i) that is being accessed from a PC client running Windows 7 Professional. Whenever I try to access the the application I get a "Oracle Forms Runform has stopped working" error. I tried installing the runtime over and over again withn no use. This is not the first problem I encounter with "Windows 7- Oracle 6i" combination.
View 1 Replies View RelatedInstallation :: Jrew Error While Installing Oracle 9i On Windows 7
Aug 22, 2013I installed oracle 9i from cd's (3 cd pack) all the three cd's installed perfectly but after the installation of these three cd's , a window appears (which is default installation ) in which some below mentioned tools were installed:-
1. Net Configuration Assitant
2. HTTP server etc. when installation of net configuration assistant is going on then a window is popped up saying "jrew.exe stops working" and the process of installation keeps going on and going on..........then when i stopped listener ,then another tool installation starts and after sometime again a window is popped with same message "jrew.exe stops working". means all the 4 tools are not successfully installed ...installing oracle 9i database on windows7.
Reports & Discoverer :: 10g Suddenly Stopped Working?
Mar 21, 2012Im not able to open the oracle reports 10g under Oracle Developer Suite Using win 7 enterprise version It gives me no error but unable to see the reports opening.It is running in the task manager but it is not opening.
View 2 Replies View RelatedForms :: Reports Background Engine Stopped Working
Jun 28, 2011When i run my reports on Windows 7 i receive the following error Reports Background engine Stopped working
When i view the detail of the error it shows
Problem Event Name APPCRASH
Application name RWRBE60.EXE
Application Version 3.0.0.0
Application Timestamp 38a27e49
Fault Module Name rwlib60.dll
Fault Module Version 0.0.0.0
I think it is sufficient information for you experts to resolve this issue reports are designed in developer 6i please view the attached image for report error detail.
Client Tools :: ISQLPlus Stopped Working Unexpectedly
Mar 20, 2011I'm having some trouble with iSQL*Plus.I instaled oracle database and at first it worked fine, but then I installed client on the same maschine and all products that come with client, and somewhere in the meantime iSQL*Plus stopped working.
Then I uninstalled client and products that go with him (Policy Manager, Oracle Wallet...) because I thought that they have "broken" iSQL*Plus, but it still doesn't work. Finally, I re-installed iSQL*Plus, but that didn't work either. Interesting thing is that when I type in command line
" c:/miljana/bin/isqlplusctl start "
it says that iSQLPlus is started, but when I go to browser there is an error:
" Firefox can't establish a connection to the server at miljana.localhost.com:5560. "
Also from Administrative tools/Services if a try to start iSQL*Plus there is an error:
" Could not start the OracleOraDb10g_home1iSQL*Plus service on Local Computer.
Error 1067: The process terminated unexpectedly. "
I know that there is a lot of topics for this, but most of solutions where for Linux, and didn't work for me.I'm using Oracle 10g Enterprise Edition on WindowsXP
Windows :: Oracle Connection Not Working?
Jun 23, 2012I'm having great difficulty connecting to two separate databases on my PC. Here are the details.
c:>echo %TNS_ADMIN%
C:TNS_ADMIN
#C:TNS_ADMIN nsnames.ora
XE =
(DESCRIPTION =
[code]...
DB Stopped Choosing Index
Aug 26, 2010Have an issue where after several months, our Oracle database has stopped choosing an index.
Here's some background information:
For the sake of simplification, the table has two key fields, SITE and ID, and the table is partitioned by SITE. Since the query is doing an ORDER BY ID DESC, we had to create a function-based DESC index as well as a regular index to convince the database to choose the index:
INDEX_1: SITE Asc, ID Asc
INDEX_2: SITE Desc, ID Desc
So when the index is chosen the showplan displays INDEX RANGE SCAN DESCENDING on INDEX_1
Now, after several months where the index was being chosen for all 4 SITEs, the index only works for 3 of the 4 SITEs.
And for 1 of the SITEs it shows 'TABLE ACCESS FULL'.
Strangely, we created another instance of the database (a byte for byte image) for troubleshooting purposes, with the same database engine version (but different OS version) and the index is being chosen for that new instance. Of course there's an explaination for this, but it's beyond my comprehension as to why you have an exact image with a different behavior.
Here's what Oracle version:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
PL/SQL Release 9.2.0.7.0 - Production
CORE9.2.0.7.0Production
TNS for Solaris: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
By the way, HINTS are not an option since the application that executes this query doesn't allow us to modify the SQL.
Installation :: Stopped At 59 % - Oracle 12c 64 Bit
Jul 30, 2013I have Windows 7 Enterprise, 64 bit operating system. I downloaded Oracle 12c for 64 bits. I downloaded both zipped files in one folder that I created and un-zipped in the same folder as well.Once I start setup.exe,
I got three times File not found message as follows:
File not found C:app....admindr0ulib.sql.sbsFile not found C:app...installsbs rcsess.batFile not found C:app...schemamk_dir.sql.sbs
On all of the above situations, I clicked "Continue" since I have no idea where to find these files.At 59% installation, it is in the process of setup and displaying the message "updating registry key "HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraDB12Home1" At this point it pretty much hangs up for ever.
Server Administration :: Dba_jobs Stopped Running
Feb 19, 2011I have a dba_job that is scheduled to run every hour and for the past couple of weeke it is behaving strangely. It fails running every alternate hour. I have checked the alert log whenever it fails but nothing is reported in the alert log. The job is not broken.
View 4 Replies View RelatedORA-00932 - Sample Code Working Fine In 10g And Not Working Now In 11g
Apr 1, 2013Below is the sample code working fine in 10g and not working now in 11g.
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....
we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class
Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
PL/SQL :: To_char Not Working / (||) Is Working With Join Query
Mar 22, 2013I have two tables : oa_membership_dtl(in this created_by field is varchar2(200 byte) ,oa_partner_usr_dtl(in this table partner_userid is number(8,0) i need to do join on above fields.
I am using following two queries:
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on to_char(partner_user.partner_userid,'9999')=membership.created_by
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on rtrim(ltrim(partner_user.partner_userid||' '))=rtrim(ltrim(membership.created_by))
by using first data is not fetched but 2nd is working fine , i am getting the matched records using 2nd query.
whats the diff between to_char and || symbol?
Backup & Recovery :: Transfer Database From Windows 2003 32 Bit To Windows 2008 64 Bit
Mar 30, 2011I 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 RelatedWindows :: Unable To Install Oracle 10g Client On 64bit Windows 2008
Jul 16, 2008We 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 .
Windows :: Installing 10g Database Software On Windows 2008 Server?
Sep 28, 2010I'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.
Windows :: Installation Process Of Oracle 10g At Windows 7 Ultimate 32 Bit?
Feb 27, 2012can i install oracle 10g at windows 7 ultimate 32 bit
View 1 Replies View RelatedWindows :: Does Oracle Database 10.1.0.2 (64-bit) Compatible With Windows 2003 R2
Jan 9, 2011Does Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.
View 1 Replies View RelatedWindows :: Installation Of 10g R2 On Windows Server 2008?
Sep 30, 2010I want to install Oracle 10g R2 on Windows Server 2008.
View 22 Replies View RelatedWindows ODBC :: Connect To Oracle 9i From Windows 7?
Dec 20, 2012Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client
Is there a way to connect to oracle 9i database from C:WindowsSysWow64odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?What we need is to run crystal reports from windows 7.
Windows :: ASM Configuration For Windows XP Platform
May 21, 2011Need 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
======================================
Windows :: Install 11G In Windows XP (32 Bit)?
Sep 19, 2010I'm trying to install oracle 11G at my windows XP platform. This shows error.
1) Is 11G not supporting with XP. Is it only supports to windows 7?
2) At the installation, it prompt me for either FILE SYSTEM or AUTOMATIC STORAGE MANAGEMENT. What is the difference, which one should I select for practicing.
3) Which edition is better to practice and to have morethings available (in terms of having advanced options as same as production DB have)
4) Can't we install RAC on my desktop?
5) Can I choose SERVER CLASS instead of DESKTOP CLASS?
Sqlplus UI - Not Working?
Apr 22, 2008I'm having some minor trouble with my sqlplus in Windows. Don't know which feature I accidentally edited by cosole seems to be in debug mode. Everything is ok, except that it print the old and new values of my variables. How can't I restore it to it's original behavior.
View 3 Replies View RelatedSQL & PL/SQL :: How To Calculate Working Day
Jan 1, 2013I need a query to find out the working days. I have attached the sample script to create table and data. Here is the description of the tables.
Emp1 : To record the employe's information and weekly rest day.
Attendance :- To record daily attendance.
Leave_appovd : To record the approved leaves.
Holiday : To record the holidays.
W = Attendance
R = Weekly Rest
L = Leave
H = Holiday
A = Absent
Required output is
Emp No.In Date Out Date Type
736912/1/201212/1/2012W
736912/2/201212/2/2012R
736912/3/201212/3/2012W
736912/4/201212/4/2012W
736912/5/201212/5/2012W
736912/6/201212/6/2012L
736912/7/201212/7/2012H
736912/8/201212/8/2012H
736912/9/201212/9/2012R
736912/10/201212/10/2012A
736912/11/201212/11/2012W
736912/12/201212/12/2012W
736912/13/201212/13/2012W
736912/14/201212/14/2012W
736912/15/201212/15/2012L
736912/16/201212/16/2012L
736912/17/201212/17/2012L
736912/18/201212/18/2012W
736912/19/201212/19/2012W
736912/20/201212/20/2012W
736912/21/201212/21/2012W
736912/22/201212/22/2012W
736912/23/201212/23/2012R
736912/24/201212/24/2012A
736912/25/201212/25/2012A
736912/26/201212/26/2012A
736912/27/201212/27/2012W
736912/28/201212/28/2012W
736912/29/201212/29/2012W
736912/30/201212/30/2012R
736912/31/201212/31/2012W
778212/1/201212/1/2012W
778212/2/201212/2/2012W
778212/3/201212/3/2012W
778212/4/201212/4/2012W
778212/5/201212/5/2012W
778212/6/201212/6/2012W
Separate Query will be run for the following output.
Wroking Days
EmpnoAttend WeeklyRestsLeavesHolidays TotalAbsentsG. Total
7369 17 4 4 2 27 4 31
7782 6 0 0 0 6 25 31
If any body work on weekly rest or holiday, it will be considered as weekly rest and holiday. There working on these days will be treated separately.
SQL & PL/SQL :: Update Is Not Working
Apr 27, 2012with a as (
SELECT subscriber_agn,max(ixml_id) ixml_id, claim_id
FROM
(
[Code].....
i want to combine above two and need only one sql stmt.
SQL & PL/SQL :: DDL Trigger Not Working?
May 14, 2013I have a trigger to automate grants to a Role whenever a table is created in my schema.I have dba rights.
CREATE OR REPLACE PROCEDURE deepa.myddl
(p_ddl IN VARCHAR2) IS
BEGIN
EXECUTE IMMEDIATE p_ddl;
[Code].....
This works perfectly when i create a table as deepa user. But say when another User creates a table in my schema
like create table deepa.test1 ( a number) This trigger is not fired. Whenever a table is created by me or by any other user in my Schema, i need the trigger to be fired.
SQL & PL/SQL :: In Clause Is Not Working?
Sep 18, 2013SELECT sno,mid,mname
FROM manage_date
WHERE mname IN
('KIRAN-KUMAR',
'RAHUL-RAJ',
'KAUSHAL-SONI');
IF I use this query directly in DB it's working fine. But when this query is calling in .net using parameter as below it's not giving any records for more than one value. IN (:p_mname)
If I pass one name 'KIRAN-KUMAR' from .net It's working.
If I pass multiple names from .net query not returning any records.
Oradim Is Not Working
Dec 13, 2010I trying to create the new service for my physical standby database. It's on the same vista machine. But somehow it's not working.
C:\Oracle\product\10.2.0\mayuprd\database>oradim -new -sid -intpwd ananya -start
mode manual
DIM-00003: An argument is missing for the parameter.
SQL & PL/SQL :: Recycle Bin Not Working
Jun 14, 2010I went through the link given in orafaq and tried to work on my system but the things did not work.
SQL> select *
2 from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> ALTER SYSTEM SET recyclebin = ON;
System altered.
SQL> SELECT Value FROM V$parameter WHERE Name = 'recyclebin';
VALUE
--------------------------------------------------------------------------------
ON
SQL> CREATE TABLE TEST_RBIN(VAL NUMBER);
Table created.
SQL> INSERT INTO TEST_RBIN(VAL) VALUES(10);
1 row created.
SQL> COMMIT;
Commit complete.
SQL>
SQL>
SQL> DROP TABLE TEST_RBIN;
Table dropped.
SQL> SHOW RECYCLEBIN;
SQL> SELECT * FROM USER_RECYCLEBIN;
no rows selected
SQL & PL/SQL :: Select INTO Is Not Working
Mar 8, 2013why my "select into" not working.i also create the table testjobs but also not working
SQL> select *
2 into testjobs
3 from jobs;
into testjobs
*
ERROR at line 2:
ORA-00905: missing keyword