How To Create Central Inventory For Oracle 11g Running On Windows Server

Dec 26, 2012

--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.

We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.

View 3 Replies


ADVERTISEMENT

Installation :: 11gr2 Silent Install Error - Unable To Create A New Central Inventory Directory

Apr 2, 2013

I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:

[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.

The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.

I am running this command to install oracle:

/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs

[code]....

View 5 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

View 4 Replies View Related

Mobile Server :: Oracle Lite - Can Be Used To Create Offline Windows (net) Applications?

Jul 31, 2012

I am exploring the options for file based databases for offline applications where there are no overheads of database installations. We have a system which has Oracle database with more than 500 tables. We need to write a lightweight application (offline) in .net which will run from USB drive and write data to USB drive only.

Existing system has a data layer which writes data to Oracle 10g Enterprise Edition database. The offline application will have more or less similar data entry forms and storage structure. In order to reuse data layer of existing system (stored procedures) can the Oracle Lite be used as a database which can run from USB drive?

I understand Oracle Lite has a suport for synchronization with the server (our main database in this case) by which data can be synchronized with minimum overheads. How the Oracle Lite is licenced if I have 300 odd users of this offline applications. I need to use only database part of Oracle Lite and not mobile server.

View 6 Replies View Related

See If PMON Or SMON Running On Windows Server?

Feb 27, 2013

On windows server how can we see if the PMON or SMON is running? Is there a way, as we can see on linux using?

View 6 Replies View Related

Reports & Discoverer :: Create One Inventory Label Report With Barcode?

Sep 18, 2013

I am trying create one Inventory label report with bar code ,This reports working fine stand alone,Once i am added this report on Oracle Apps concurrent Program ,Output came without bar code.

View 6 Replies View Related

ORA-12154 Running 32 Bit Oracle Software 0n 64 Bit Windows?

Oct 7, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:\Program Files (x86) on 64 bit windows, The PATH variable doesnt recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client.

Oracle Client: 10.2.0.3 32 bit

Windows OS: Windows server 2008 R2 64 bit

I have referred the below document from the metalink(which states that the bug is fixed in 10.2.0.3 client).

ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS [ID 334528.1]

View 1 Replies View Related

Forms :: Running Oracle Database 10g On Windows 7

Nov 12, 2009

I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs

View 9 Replies View Related

Cons Of Running 8 Production Database Instance On One Windows Server

Dec 3, 2010

We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.

I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.

My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)

View 6 Replies View Related

Oracle Inventory / Sql Table Not Pulling Any Data

Aug 14, 2013

There are two oracle inventory tables, I found that used to pull up data before but not anymore . It is

�INVFV_INV_BY_PERIOD_AND_ITEM�

and �MTL_BIS_INV_BY_PERIOD� .

I need to use all the columns/data that are in these two tables. I am not finding any equivalent table. where can I retrieve these information from?

Select * from INVFV_INV_BY_PERIOD_AND_ITEM;
Select * from MTL_BIS_INV_BY_PERIOD;

View 3 Replies View Related

Forms :: Inventory Sale Program In Oracle

Apr 15, 2010

I have made the inventory sale program in oracle. Its working from 7 years. Now its speed is very slow.It take much time to execute query.

View 17 Replies View Related

Unable To Create Database (Oracle 12c R1 12.1.0.1.0 / Windows 2012 )

Aug 30, 2013

I have been trying out the new 12c on Windows 2012 Essentials with the same type of errors.  The OraDim step fails and cannot create the services.  It fails a bit differently if I choose "Create New Windows User", choose a "Use Existing Windows User", or choose the Windows Built-in user. 

View 3 Replies View Related

Server Administration :: Why Oracle Scheduler Is Not Running

May 14, 2013

Why Oracle shceduler is not running.What could be the cause.

CREATE TABLE dept1 AS SELECT * FROM dept;
CREATE OR REPLACE
procedure update_record(p_deptno number)is
BEGIN
insert into dept1 values(p_deptno,'xxx','xxx');
end;

[code]....

View 15 Replies View Related

Efficient Way To Connect SQL Server From Oracle Which Is Running On HP-UNIX

Mar 8, 2011

I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.

View 1 Replies View Related

Server Administration :: Creating / Running Jobs In Oracle 9i For Solaris

Sep 5, 2005

How to

1) to define a job in oracle9i for solaris
2) to schedule this job

Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.

View 4 Replies View Related

Windows :: Test If Database Is Running?

Sep 15, 2010

I have a unix script that will check if the database is up and running. I need a similar script but this time in windows batch file.

this is the snippet of the code from the unix script:

#! /bin/sh
sqlplus -s /nolog > /dev/null 2>&1 <<EOF
whenever sqlerror exit failure

[Code].....

View 2 Replies View Related

Forms :: Running Reports 6i On Windows 7?

Nov 2, 2009

would like to check if anybody running Form/Report 6i on Windows 7 ? I meant not XP mode.

View 3 Replies View Related

Networking And Gateways :: Running DML Statement On Oracle Transparent Gateway For SQL Server?

Dec 5, 2011

how can i run dml statement on the oracle transparent gateway for sql server ,such as insert ,update,delete.

View 4 Replies View Related

Windows :: Error When Running Macro Excel

Jan 13, 2012

I installed Oracle 11gR2 database for windows 7. I believe it's 32 bit. I keep getting an error when I run my macro excel: Error while trying to retrieve text for error ORA-01019.

View 1 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related

How To Create Ocr Disk Or Voting Disk On Windows Server 2008

Feb 17, 2011

I have 2 servers both having windows server 2008 64 bit as operating system installed on both I need to install oracle clusterware 11g r1 on both servers with clustering on external storage. I have configured the network(private,public and virtual) for both servers and have started the installation.

In the installation of oracle I add both servers but then I reach to a point where they ask me for voting disk or ocr disk in the cluster configuration storage but no disk is present how can i create ocr disk or voting disk on windows server 2008? And the external storage should I buy a special type of storage that supports clustering to continue my work?

View 2 Replies View Related

Windows :: ORACLE 11g R1 Or R2 For Server 2008 R2

Jan 7, 2011

Oracle 11g R1 or R2 is availble for Windows Server and If YES then any link for the same.

View 2 Replies View Related

Server Administration :: Oracle XE On Windows XP

Apr 26, 2012

I have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.

1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.

However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.

Is a fresh install the only option? or is there any way to correct this using the sys/sys user?

View 9 Replies View Related

Oracle 10g RAC On Windows 2008 Enterprise Server

Oct 7, 2010

I'm installing Oracle 10g (10.2.0.4) RAC on Windows enterprise Server. Am able to install cluster ware (10.2.0.4). While installing ASM (10.2.0.3)/ DB its going to restart both the servers automatically. Is there any problem with this Versions (OS and Oracle) combination. Is it compatible or Not?

View 4 Replies View Related

How To Eliminate Windows NT Authentication In Oracle DB Server

Feb 18, 2013

I have oracle database server set with Windows NT authentication. How can I get rid of this kind of authentication as this is holding up additional Windows Domain with its own PDS and so on. Or is it possible to move Oracle Database server to a different Domain and authentication to be coming from new domain?

View 4 Replies View Related

Server Administration :: Installing Oracle 10G On Windows 7?

May 21, 2010

I already succeded to setyup Oracle 10 G on my machine , when trying to connect by system/system it does not connect.The listener is OK and instance ok.

View 10 Replies View Related







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