Windows :: Detect Oracle Version And Platform Installed?

Mar 14, 2012

Is there a way to check which versions or oracle installed on the machine from command line?

The thing is I don't want to login to the database so I can't use SQL Plus also, till now I ran tnsping and checked the output but in case there are several versions of different platform I got only one version that was first on the path env.

View 1 Replies


ADVERTISEMENT

Forms :: Migration From Oracle 10g 32 Bit Windows To 11g Linux Platform

Oct 25, 2013

Migration of oracle forms 10g 32 bit windows platform to 11g 64bit Linux platform . I have about 500 fmb on my 10g environment which are currently working fine but when i go to compile it on 11g an error file is generated. All my path is set in proper manner .

I have a object library which has multiple tabs and every tab has its own object. While compiling, the forms are not inheriting the object values only few values from the object are considered.

View 5 Replies View Related

Installed Oracle 11.2.0 On Windows 7 64 Bit - Initialization Error

Mar 20, 2011

I install Oracle 11.2.0 on Windows 7 64bit and i install PL/SQL Developer.

when i run the PL/SQL and connect to Oracle i get this error:

Initialization error
Could not load "C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll"

OCIDLL forced to C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll) returned 0

View 7 Replies View Related

Server Administration :: Upgrade Oracle 9.2.0.1.0 From RHEL4 Platform To Oracle 11g Rel 2 On RHEL5 Platform

Feb 4, 2012

Can I directly upgrade Oracle 9.2.0.1.0 From RHEL-4 platform to Oracle 11g Rel 2 on RHEL -5 platform?I have the export dump and cold backup of Oracle 9.2.0.1.0 database.

View 11 Replies View Related

Oracle 9 Is Incompatible With Version Or Windows

Nov 9, 2010

I am trying to install Oracle 9i 32bit client on a windows 2008 server 64 bit OS. In the installation once I select the Oracle home directory and click on Next the whole pc just hangs. Nothing happens. When I checked the Application log I see an error with the following information.

the application (Oracle 9, from vendor Oracle) has the following problem. Oracle 9 is incompatible with this version or windows. For more information, contact Oracle.

View 13 Replies View Related

Windows :: Oracle Version Mismatch

Jul 1, 2011

I have installed oracle 10g version 10.2.0.4.0 on Windows 7 64 bit from the following link.

[URL].........

After login to SQL* plus, when i see the version, it shows as 10.2.0.3.0. Is this correct?

View 8 Replies View Related

Windows :: Which Version Of 32 Bit Oracle Client Should Install

Aug 22, 2011

Which version of 32 bit oracle client should I install on 10204_vista_w2k8_x64_production_db and Windows Server 2008 R2 x64 operating system?

10203_vista_w2k8_x86_production_client - This version does not work (no pre-requisite checks found in oraparam.ini)

View 15 Replies View Related

Windows :: Oracle Database Compatible Version With Win 7

May 10, 2012

I have Windows 7 (System Type - 64-bit OPerating System & ACPI X64 PC Type) and want to install Oracle Database.

The compatible version with the above operating system and send me the direct link for downloading.

View 17 Replies View Related

Windows :: ASM Configuration For Windows XP Platform

May 21, 2011

Need 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
======================================

View 3 Replies View Related

Forms :: Read / Write In Unix From Oracle Forms Installed In Windows

Nov 24, 2011

I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.

I tried TEXT_IO package.But that is not allowing to access Unix path.

View 2 Replies View Related

Forms :: Getting Oracle Developer Suite 9i Version For XP And Windows 7?

Dec 14, 2011

i need Oracle Developer Suite 9i version for windows xp and windows 7.

tell me where i can download it?

View 6 Replies View Related

Windows :: Mismatched Oracle Drivers / Upgrade Version

Jun 26, 2012

We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here [URL] .....) where the apparent mismatch between the oracle drivers are causing the errors.

Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.

Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server using Express version (I don't have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?

Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?

View 2 Replies View Related

Forms :: Migrate Application From Linux Platform To Windows 7?

Oct 17, 2010

I'm trying to migrate our forms application from a Linux platform to Windows 7. We have a common pll which is attached to all forms and unfortunately relies heavily on globals.

Attempting to run the application with the standard library attached to the login form has the effect that the globals are lost between the login form and subsequent forms. If I incorporate the library code directly into the login form, it functions correctly. If I use the debugger to track where the clearing occurs, it functions correctly.

View 2 Replies View Related

Windows :: OScanner - Java JRE Installed On Machine

Mar 16, 2011

I have recently downloaded (the zip file for) OScanner (1.0.6) and have Java JRE installed on my machine. However, I am experiencing some difficulty in running the scanner. how I should start to use this tool, once I have downloaded the zip file.

View 8 Replies View Related

Forms :: Modifying Form On UNIX Server Using Builder Installed On Windows Desktop

May 20, 2010

We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.

My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:

Failed to load the following objects: APPSTAND, etc etc.

Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?

View 2 Replies View Related

SQL & PL/SQL :: Detect And Fix Negative Time In Oracle

Jul 15, 2011

I found the data in DB with negative time as below

Quote:
1 SELECT
2 c.time
3 FROM partition c
4 WHERE
5* c.time < to_date('0001-01-01','YYYY-MM-DD')
SQL> /

DEACTIVATION_TIME
------------------------------------------------------------------------
17-JUN-08 04.06.22.893 PM

The data type for c.time is Timestamp.

When I use JDBC to retrieve the data and convert it to mill seconds, and it also shows as negative time. My question is the retrieved time doesn't show the negative date, but obvious it is a BC date and earlier than 0001-01-01.

1. How can we detect/show the date to show correctly for the BC date without checking c.time < to_date('0001-01-01','YYYY-MM-DD')? (I am wondering if there is format configuration to show the time like 17-JUN-08 04.06.22.893 PM BC, or something to show the time is negative )

2.how could we fix it negative time to positive ?

View 6 Replies View Related

SQL & PL/SQL :: Check If A Particular Version Available In Earlier Version Of Oracle

Mar 30, 2012

I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?

View 4 Replies View Related

Forms :: Version 10.1.2.0.2 With Windows Server 2008 64 Bit

Dec 12, 2011

is Forms [32 Bit] Version 10.1.2.0.2 not supported with Windows Server 2008 64 bit ?? i tried to install it and it was failed.!

View 2 Replies View Related

Windows :: Installing Multiple Version Of Client On A Single PC?

Sep 17, 2010

installing Oracle 9i and Oracle 10 g client on a single PC.

What are the things I should take not of for the installation?

View 4 Replies View Related

Moving From 32 Bit Linux To 64 Bit Windows Version On Database Standard Edition

Aug 16, 2013

when migrating from  32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of? 

View 2 Replies View Related

Does Oracle Has Any Solutions For Mobile Platform

Apr 12, 2013

Does Oracle has any solutions for mobile platform ? something to build the application on smartphone...

View 2 Replies View Related

Forms :: (32Bit) Version 10.1.2.0.2 Crashed With Windows Server 2008 64bit

Dec 19, 2011

i need to upgrade this version to 10.1.2.3, and i don't have an account in metalink to download the patch.

View 11 Replies View Related

Can Oracle 9 / 10 And 11 Be Installed On Same PC

Nov 4, 2010

I have new PC going to be used for Oracle 9, 10 & 11. It has Windows 2008, system processor - Intel® Xeon® CPU, Installed memory 2.00 GB and it is 64-bit operating system. My question is if it is possible to have 3 different versions of Oracle on the same box. I want to make sure that they are not going to create any problem! If it is ok to install all three on the same box then should i start installing from the lowest version (9)?

View 4 Replies View Related

Oracle 11g R2 Installed With Zero Bytes On IBM AIX

Dec 27, 2012

I have installed 11g r2 using silent mode. but all the executable like lsnrctl, expdp, sqlldr,impdp etc.... installed with 0 (zero) bytes.

couldn't trace out what the problem is,

View 1 Replies View Related

Import Oracle 10g Database Table Into 8i On Linux Platform?

Apr 13, 2013

can we import oracle 10g database table into oracle 8i database on linux platform?

View 7 Replies View Related

Oracle Installed In Workgroup - Not Able To Login Database

Oct 15, 2011

I am new in oracle I have installed Oracle in work group, while i work group it is working fine. But latter I have change the server from work group to domain. At that time Oracle was not working , not able to connect.

After that I change the Domain to work group again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc

View 1 Replies View Related

Server Administration :: Installed Database Oracle With Installation

Nov 17, 2011

Yesterday i installed oracle 11g r2 by default i installed database Oracle with the installation .but today i tried to create the database with the name green tat also completed successfully..the problem is in startup

export oracle_sid=green
sqlplus '/ as sysdba'
startup
database mounted

select instance_name from v$instance; But it SHowing the instance name as Oracle...i tried with the other method also

export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba

database mounted

select instance_name from V$parameter;

and it shows instance name as green..i tried to see the datafile location for green database

select file_name from dba_data_files; it shows the orcl datafile locations.

View 6 Replies View Related

Oracle 11gr2 64 Bit Database Software Installed - Not Register

Feb 19, 2013

1. oracle 11gr2 64 bit database software installed
2. oracle 11gr2 32 bit clinet software installed

The above software has been installed on server, Pop pup- Error messages coming during installing 3rd party software packages...on server.

Error is - igrORASPConnect412.dll not register...

what could be issues & how to resolve this problem? do we need to reinstall client software again not available this DLL file after searching on oralce home directory .

View 1 Replies View Related

Server Administration :: How To Spot Which Oracle Packages Are Installed / Licensed

Feb 22, 2011

I need to figure out which Oracle Database packages are installed on a certain server.

First problem: no Enterprise Manager available. So I need some command line tools or SQL statements.

I've already found some with them I was able to spot RAC, partitioning and so on. But I'm still missing a option/command to spot

- diagnistic pack
- tuning pack
- web logic
- web server

View 3 Replies View Related

Precompilers, OCI & OCCI :: PRO*C Compiler Version Versus Database Version

Oct 15, 2010

We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.

if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.

Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.

View 3 Replies View Related







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