Oracle10g Install On Z/OS

Apr 22, 2011

I am having a rough time trying to install Oacle 10.2.0.3.0 on Z/OS 1.7.

Since my installation does not allow us to use X Windows nor Telnet, I have been forced to try to install using a silent install response file. The install does not seem to get very far and throws out an informational message, but no actual errors. All this is being done via OMVS on USS (UNIX system services).

The message I am getting is:

INFO: INFO: Unable to read the list of homes from the inventory.

I think it may be a permissions issue, and the support people are pursuing this avenue as well, but so far, no concrete answers.

I execute ./runInstaller -silent -responsefile <my responsefile.rsp>

The above INFO message comes out.

The user I am logged in with has the following:

uid=1212 (HPCGBE) gid=101(OINSTALL) groups=102(ORADBA)

One problem is that there is a superuser account called BPXOINIT that is the group owner on some of the directories that I need to access:

uid=0 (BPXOINIT) gid=1(BPXOINIT) groups=101(OINSTALL),102(ORADBA)

View 2 Replies


ADVERTISEMENT

Forms :: Button On LOV - Oracle10g

May 17, 2011

I hava LOV and i want process events when click button Cancle on LOV then disable a canvas, but i don't know how process it.where could know events click mouse in button Cancle on LOV - Oracle Forms?

View 9 Replies View Related

SQL & PL/SQL :: How To Store PDF Files In Oracle10g DB

Dec 2, 2011

how to store pdf files in oracle10g database

View 13 Replies View Related

Installation :: Oracle10g For Windows 8

Mar 5, 2013

I need to install oracle10g with client 6i on windows 8 platform, provide me link to download 10g with no issues installing on windows8.

View 2 Replies View Related

Server Utilities :: Oracle10g Imp Tables Containing LOB

Nov 23, 2010

A full database exported from Oracle 10.2.0.4 and import back to the same instance with different user/schema name. The whole database is in single tablespace, SOURCE_TS. Since SOURCE_TS already exist in the same instance. A brand new user and its default tablespace will be created before the import. SOURCE_TS cannot be access by this new user.

Since my database has many tables containing LOB column, those LOB tables will be pre-create before the import start. Initially, those LOB tables imported successfully but at one stage, it fails. Subsequent LOB tables all failed since then.

Quote:IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "I43NAV_LOC_VEC" ("VID" NUMBER NOT NULL ENABLE, "BLK_NO" N"
"UMBER NOT NULL ENABLE, "DATATYPE" NUMBER, "VEC_STORAGE_TYPE" VARCHAR2(12) N"
"OT NULL ENABLE, "REL_PATH" VARCHAR2(256), "BYTES_USED" NUMBER, "BLOB_DAT"
"A" BLOB, "BFILE_DATA" BFILE) PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 "
[code].......

I am not able to find out any reason why it fails, since out of 150, 80 of my tables containing LOB column were imported correctly suggested that my imp parameters were correct.

It doesn't seems to be my backup file problem too, I tried twice and the first LOB table failed is not the same with the previous attempts.

Initially I thought might be quota, but unlimited quota to the new tablespace is granted. Even if it is not granted, the error returned would be complaining about quota limit reached in the new tablespace, not SOURCE_TS.

If this is not about disk space or quota issue, in what condition the imp will tries to create table in SOURCE_TS, instead of my new tablespace? I will need to understand the IMP utility logic to sort this out.

View 12 Replies View Related

SQL & PL/SQL :: Control Session In Database Oracle10g

Sep 30, 2010

i want to control our session in database oracle10g which means that:x is not allowed to connect to the database, if x try to connect to the database his session will be blocked and a message must be sent to the administrator.

View 8 Replies View Related

ODP.NET :: Is ODAC Free For Oracle10g User

Aug 6, 2012

My company brought Oracle10g server some years ago. I've noticed that ODAC support Linq and could be used to connect Oracle 10g.

Can we use ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio for commerical use due we already purchased Oracle 10g server?

View 1 Replies View Related

RAC & Failsafe :: Enable Audit_trail On 2 Node RAC ENV On Oracle10g

Nov 23, 2011

I have a production database with 2 node Physical RAC ENV on two separate machines , and we are going to enable audit trail parameter to DB values to capture all failed login attempts on a database.

we have done this on our testing ENV but dont know the procedure to deploy this steps on 2 node RAC ENV . I have done the below steps on our standalone testing ENV

1.Log in as SYS and connect with the SYSDBA privilege.
oUser Name: SYS
oPassword: Enter your password.
oConnect As: SYSDBA

2.To enable audit on DB use below command
SQL>alter system set audit_trail=DB scope=SPFILE;

3.Then restart the database.

4.After successful startup use the below command to capture log
SQL> audit create session whenever not successful;

steps to enable audit_trail to capture failed login attempts on two node RAC ENV.

View 4 Replies View Related

Precompilers, OCI & OCCI :: Oracle10g Pre Compilation Error

Apr 23, 2009

i am getting below error when i compiler a pro*c program with Oracle 10g client with IBM C compiler version 9.0 on AIX 6.1

Syntax error at line 183, column 2, file /usr/include/sys/socket.h:
....
PCC-S-02201, Encountered the symbol "sa_family_t" when expecting one of the foll
owing:
....

My pcscfg.cfg contents

sys_include=(/usr/include)
ltype=short

View 1 Replies View Related

PL/SQL :: How To Implement Exception Handling On MERGE Statement In Oracle10g

Jul 19, 2012

How to handle the exception on below MERGE statement?

MERGE INTO COMM_EXSTS_COMIT_AGGR TARGET

USING
(
select  * from   ABC ) SRC
ON
(
SRC.COMMITMENT_ID = TARGET.COMMITMENT_ID
)
WHEN MATCHED THEN
UPDATE
WHEN NOT MATCHED THEN
INSERT ;

View 4 Replies View Related

Performance Tuning :: Oracle10g Standard Edition On Linux Machine

Jan 16, 2012

In my production ENV there is two node RAC database is running , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.

SGA SGA_TARGET DB_BLOCK_SIZE DB_MULTIBLOCK_READ_COUNT
NODE1 16G 14G 8K 16K
NODE2 16G 14G 8K 16K

Our Database size is 700GB approx.

The above SGA configuration is ok or need to be increase the size of SGA , our HIT RATIO is almost 99%.

View 5 Replies View Related

Cannot Connect After Install

Nov 1, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files.

tnsnames.ora
CODEXE =
(DESCRIPTION =

[Code]....

View 1 Replies View Related

How To Install Oracle On Linux

Feb 25, 2012

how to install oracle on Linux.

View 2 Replies View Related

Install Oracle 9i In Windows XP

Mar 11, 2004

I wanted to install oracle 9i in windows xp.My configuration is intel celeron,2.5ghz,256 mb ram ,5.5 gb of free hard disk space.I do no anything about the oracle ,was trying to install oracle on redhat 9 but had some problems..I just wanted the step by step documentation of installing oracle 9i in xp.

View 2 Replies View Related

Install And Remove Oracle 10 G

May 26, 2008

I install oracle 10 g but I don't remember password . so I then remove oracle 10 g by select Universal Installer and click Deinstall and then reinstall but I can't reinstall because I don't remove/delete oracle_home I then delete folder in path C:Oracle and reinstall Question

1.in this remove oracle 10 g method true or wrong if wrong , How effect on my computer
2.why after reinstall my computer is very slow.

View 5 Replies View Related

Install OracleASM In CentOS 6?

Apr 19, 2012

Can I install the oracleASM in centOS 6?

My kernel version is 2.6.32.

And the last version for oracleasm release is 2.6.18-308.1.1.el5. [URL] And they aren't compatible...

Are there any way to install these lib with this kernel version? (2.32...)?

View 1 Replies View Related

Windows :: How To Install 10gr2 In Win 7

May 1, 2010

Is it possible to install 10gr2 in windows 7?

View 12 Replies View Related

RAC & Failsafe :: Can Just Install CRS Only If OS Crashed

Aug 3, 2012

we have RAC database on two node here on windows server 2008 unfortunately today morning my one my one node os crash its on windows server 2008 my other node its working ok so my database is accessible so i just want to ask if i install again this os on node -1 system so i just want to install only again crs only.because my database is accessible through my other node-2

View 6 Replies View Related

Windows :: Install Oracle In XP?

Sep 7, 2010

I've dual booting (Ubuntu and xp). I've already installed oracle 9i in xp. And planning to install 10g in Ubuntu soon.

1) How to check the os block size whether it is 32 or 64bit before installing 10g on XP?

2) (eventhough not necessary) is it possible to have 9i and 10g in a same XP platform?

3) Can I change the bit size between 32 and 64 bit while installing a new oracle software?

View 2 Replies View Related

Windows :: Install Oracle 10g In 7?

Nov 1, 2010

I have dell inspiron 15R model N5010 laptop, I have windows 7 64 bit operating system, intel i5 processor, 4 gb ram,500gb hdd. how does install oracle 10g in my system.

View 1 Replies View Related

Installation :: Not Install 100% Oracle 8i

May 2, 2013

Caused our sql 8i not install 100%, while we are using windows 7.

View 2 Replies View Related

XE :: Install Oracle 10g With Different Database

Feb 4, 2013

Oracle database 10g Express Edition...I need to install "Oracle database 10g Express Edition" with different database name example dev but it is taking default name that is XE and there is no option come during installation where i can put the name of database as per my desire.

And also explain why we use "Oracle database 10g Express Edition" instead of Oracle database 10g. what is the meaning of Express Edition.

View 2 Replies View Related

Installation :: Install On SAN Vs Blade?

Aug 21, 2013

, We are doing a fresh setup on new hardware.  On the old hardware Oracle is installed on the SAN and all data files are on there as well.  Our new blades are Dell M620 with 2 mirrored 500GB drives and our SAN is Dell Complaint Storage and Complaint TLS Controller.  The SAN uses hybrid SSD storage so it keeps the most used data cached. 

 I'm feeling it would be best to install the Oracle Server on the SAN.  On top of that we have a single 620GB fusion IO NAND flash card in the mix.  I am still researching the configuration of that.

View 0 Replies View Related

Migrate Install From RHEL4 To RHEL5

Oct 14, 2010

I need to build a new server for my Oracle 10gR2 due to compatibilities with the new storage system that we have purchased, this server will run RHEL5 x64 and will replace a RHEL4 x64. Since doing an upgrade poses greater risk as the upgrade may fail, I am thinking about building a new server with RHEL5 x64 doing all the config/tuning and then simply running the same Oracle installation (after a full backup) which I was running on the RHEL4 x64.

For this to work I will just need to mount the SAN drives on the new server but and this may be a big but, considering that some versions of some libraries will change do I need to relink anything in my Oracle? I have never manually relinked anything but Oracle may have done so during the initial install.

View 7 Replies View Related

Possible To Install Oracle Grid Infrastructure

Jan 11, 2012

I'm trying to install Grid Infrastructure for Oracle RAC 11g. I followed each step of pre installation tasks, but when I run run Installer it blocks without any error message.

What I see on my shell is this:
./runInstaller
Avvio di Oracle Universal Installer in corso...

Verifica dello spazio Temp: deve essere maggiore di 120 MB. Effettivi 17276 MB Superato
Verifica dello spazio di swap: deve essere maggiore di 150 MB. Effettivi 23999 MB Superato
Verifica del monitor: deve essere configurato per visualizzare almeno 256 colori. Effettivo 16777216 Superato
Preparazione per l'avvio di Oracle Universal Installer da /tmp/OraInstall2012-01-11_03-35-57AM. Attendere...[oracle@ssts2cora1 grid]$

Everything seems ok. But the window of oracle installation does not appear. The java process is active:

[oracle@ssts2cora1 grid]$ ps -ef | grep java
oracle 4553 1 0 03:35 pts/0 00:00:00 /tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui/lib/linux -Doracle.installer.oui_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_location=/home/software_ssts/grid/install -Doracle.installer.jre_loc=/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre -Doracle.installer.nlsEnabled="TRUE" -Doracle.installer.prereqConfigLoc= -Doracle.installer.unixVersion=2.6.32-100.34.1.el6uek.x86_64 -mx150m -cp
[code]....

but it does nothing!! Nothing appears to me. I attach the log file generated by the installation process.

Using paramFile: /home/software_ssts/grid/install/oraparam.ini

Checking Temp space: must be greater than 120 MB. Actual 17276 MB Passed
Checking swap space: must be greater than 150 MB. Actual 23999 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

The commandline for unzip:

/home/software_ssts/grid/install/unzip -qqqo ../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles/\*.jar -d /tmp/OraInstall2012-01-11_03-35-57AM
Verr� utilizzato il valore di umask '022' disponibile in oraparam.ini

Execvp of the child jre : the cmdline is /tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java, and the argv is
/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java
-Doracle.installer.library_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui/lib/linux
-Doracle.installer.oui_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui
-Doracle.installer.bootstrap=TRUE
-Doracle.installer.startup_location=/home/software_ssts/grid/install
-Doracle.installer.jre_loc=/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre
[code].......

View 2 Replies View Related

Windows :: Install Forms And Reports 11g

Nov 1, 2011

Ar you have manual to install oracle forms and reports on windows seven

View 2 Replies View Related

Windows :: Install Oracle R12 On Computer?

Sep 18, 2012

I need steps to install Oracle R12 on my Windows computer.

View 1 Replies View Related

Forms :: Install Oracle 11g Client

Aug 20, 2012

I just installed WEBLOGIC server on linux with oracle forms 11g builder and report builder on the server.

On the client machine , i have probleme to intsall oracle forms 11g , in one of the steps it asks me to enter the absolute location of server weblogic , i enter the location of the weblogic on the server , but it dosent' work. is it mean that i have to install the weblogic on the client machine too!! if not to install forms builder 11g on the client

View 2 Replies View Related

Windows :: Unable To Install Oracle 10g On Win 7

Jan 8, 2011

Is oracle 10g availble for Windows 7, I downloaded oracle 10g from ORACLE'S website. The name of the file is "10203_ vista_ w2k8_ x86_ production_ db.zip" but when I m installing it, I m getting error at the very beginning regarding the system requirements failure.

below is the message which i receive at the PRODUCT-SPECIFIC PREREQUISITE CHECK
======================================
Checking operating system requirements ...

Expected result: One of 5.0,5.1,5.2,6.0
Actual Result: 6.1
Check complete. The overall result of this check is: Failed <<<<
Problem: Oracle Database 10g is not certified on the current operating system.
Recommendation: Make sure you are installing the software on the correct platform.
=======================================================================
[code]....

View 6 Replies View Related

Windows :: Does Win 7 Support Oracle 11g To Install

Nov 16, 2011

that windows7 will support oracle 11g and oracle 10 g

View 1 Replies View Related







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