Migrating from Oracle 8.0.6 on HPUX to Oracle 8.1.7 on Linux

We are migrating from Oracle 8.0.6 on HPUX to Oracle 8.1.7 on Linux.What kind of changes would be required ? Would there be any problems ? How does one go about this upgrade ? I would really appreciate any assistance. ...

Mounting Oracle Filesystems with CIO

Ive not used concurrent I/O before, so i just want to check what im doing is correct.I have a system being built with Oracle 10g & SAP ECC6.0.I have laid out the filesystems as below, and have mounted the oracle data, archive, redo, mirror filesystems as namefs with cio.The parent /oracle filesy ...

oracle transparent gateway sql server ORA.28511

I tried to install the gateway for ms sql server and failed, can anyone help me?the 1. computer - database server is a hpux with oracle 8.1.7the 2. computer - gateway computer is a win 2k with oracle transparent gateway 9.0.1the 3. computer - Sql Server is a Computer with WinXP and SQL Server 2000 S ...

Oracle instantclient+apache+php and more ...

First sorry, if my English is not correct.So I've some problems with instantclient.I have a server HPUX with ORACLE 7.3.4, and it's work very well. I can connect to the DB with SQLPLUS on WinNT.So, now I try to connect on this DB with InstantClient on Linux RedHat 9.0 and no way .... I set $ORACLE_H ...

Oracle How do I setup application for public use through firewall?

We are ready to begin deploying applications to the internet, not just the intranet. In so doing though we have some security issues. We need to be able to have the end users see a specific static URL that does not contain port numbers, f?p notation, or any other indicators of our internal system. C ...

Oracle Urgent : Is this Installation Possible

I want to run Application on HPUX and Oracle database 10g on Sun Sorarisis it possible. and if so what are the shortcoming. Please give me some tips. ...

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

I am unable to launch sqlplus on HPUX for oracle 10g.These are the Oracle parameters set$ set | grep ORA ORACLE_BASE=/opt/oracle/app/oracle ORACLE_DATA=/opt/oradata ORACLE_DOC=/opt/oracle/app/oracle/product/DB/doc ORACLE_DOMAIN=OSMF.COM ORACLE_HOME=/opt/oracle/app/oracle/product/DB ORACLE_PATH=/opt/ ...

Problem Oracle client + Ubuntu 10.4

I installed the oracle on ubuntu-server clientt 10.4, now I need to incorporate a Nagios plugin to monitor oracle databases, the steps I performed are:Rpm packages to parse the alien utilityoracle-instantclient-basiclite-10.2.0.3-1.i386.rpmoracle-instantclient-devel-10.2.0.3-1.i386.rpmoracle-instant ...

Oracle em agent problem.

I have installed oracle EM Grid Control 10.2.0.2.0 on my windows xp systemdatabase version is 10.2.0.1.0than i have installed same version agent on another windows system and provided management servers host name as my system host name( where em grid control is installed) so it works perfectly and i ...

Oracle Restore a database (not with RMAN) when not having the controlfile

i'm trying the following on HPUX with Oracle 9.2:Having all necessary datafiles, the arch files and init.ora file i would like to restore them on some other hpux host.It works when i have a copy of the original controlfile available.But would it be possible when i dont have a copy of the controlfile ...

Oracle sysman getting locked repeatedly.

I have installed oracle em grid contol on my windows xp system and agents are installed on hpux serveroracle version is 10g Release 2but whenever i m oppening em control using this linki [https://01hw172211:1159/em] i m getting below error..503 Service UnavailableService is not initialized correctly ...

Oracle db performance confusion.

HPUX 11XOracle 10.2.0.2I'm trying to tune my db. I've made vast improvements by tuning the redo logs. I increased from three groups, 1 member each at 50M.....to now having three groups, 2 members each, each file being 250M. But I'm sitting here watching the db, and the redo buffer will drop in perfo ...

Oracle recovery question using archive log

HPUX 11XOracle 10.2.0.2I have a standby database that the customers want to test the ability to fail over. They also want to test the data integrity of the standby once it's brought on line as the primary.I've already told the customer that any writes that they do on the standby during the test time ...

Oracle remote_os_authentication

We are using oracle 11.1.0.6.0 on hpuxSince oracle 11g "remote_os_othentication" parameter has been deprecated. and it may be possible that this parameter will be obsoleted from 11g second release all my oracle user are os authenticated and os users are exist on different server and database is on d ...

Perl Oracle package DBD::oracle install fails

I installed perl DBI package and then tried installing DBD-Oracle I get errors . Uninstalled perl and redid it but get same error. Can someone please help? cpan> install DBIDBI is up to date (1.609). cpan> install DBD::OracleRunning install for module 'DBD::Oracle'Running make for P/PY/PYTHIAN ...

Oracle We are planning to change the HOSTNAME

We are planning to change the hostname:OS: HPUXDatabase: Oracle 10gDo we need to change anything in the database except the host entry in TNSNAMES.ORA and LISTNER.ORA after changing the hostname. ...

Oracle datafile permissions

I am facing a strange problem in my database.On system 1(HPUX and Oracle v9.2.0.5.0) : Database 1 is in mount stage with controlfiles permissions 646 and ownership root:root and all datafiles permissions 644 and ownership root:root.I queried "select * from v$datafile_header;" . It took a lot of time ...

Oracle 9 IAS - HPUX MC/SG

Is it feasible for HPUX MC/SG to provide the high availability solution for ORACLE 9 IAS ? ...

Oracle and HPUX Memory

I am not a DBA but responsible for a clients set of HPUX servers. So sorry for asking what is possibly a silly question.I am wondering if anyone knows of any documents/whitepapers that have some advisory on the recommended amount of memory you should have on a server to run Oracle databases.We have ...

installation of oracle 9i on HPUX form cdrom

i want to install oracle 9i on a HPUX 11.11 workstation. the hdd is to small to put all 4 CDs on it. it is not possible to mount the CD with the normal mount command because the file names are too long, so you have to use the pfs_mount tool. but if you use this tool and you umount the CD, it is not ...

oracle 9 and HPUX

I have some problems to install oracle on a HPUX workstation. First I tried to install Oracle 9i releas2 but during the installations occurred some problems. It was not possible to install it error free. So I tried to install Oracle 9i releas1, because I thought there are maybe some faults in the ne ...

Can I install Oracle 9.2.02.0 in HPUX 11.00 (32 bit)

I need your help and expert advise on this .I'm about to install the Oracle 9i in my HPUX 11.00 but I've read in the Installation guide that the OS requirements for HPUX is the HPUX 11.11 (64 bit)? Is this really true? ...

Oracle problem on HPUX

I have installed Oracle 920 client on HPUX 11. When i try to sqlplus i get the error/usr/lib/pa20_64/dld.sl: Unsatisfied code symbol 'gethrtime' in load module '/home/oracle/product/9.2.0/bin/sqlplus'.I have set the Oracle_HOME and $SHLIB_PATH correctly. The SHLIB_PATH is pointing to $ORACLE_HOME/li ...

Oracle cics 4.2 XA problem with oralce 8.1.6 HPUX 11.0

Now I have a problem need your help. Summarize as following:I have setup cics sucessfully with 'cicsterm ' connect OK.while use IBM provided samples 'uxa1' and ORACLE provided samples 'oraclexa.c' and oraclexa.mk' to compile and setup XA with ORACLE 8.1.6, and cold start up the region,the 'cicsas' s ...

Oracle cics 4.2 XA problem with oralce 8.1.6 HPUX 11.0

Now I have a problem need your help. Summarize as following:I have setup cics sucessfully with 'cicsterm ' connect OK. while use IBM provided samples 'uxa1' and ORACLE provided samples 'oraclexa.c' and oraclexa.mk' to compile and setup XA with ORACLE 8.1.6, and cold start up the region,the 'cicsas' ...

Oracle Migration from HPUX to Linux

I am having a system running HPUX 10.2 with Oracle 7.3.No we have decided to move from HPUX to Linux 8.0 with Oracle 9iCan anyone tell me the procedure to do this.I know only one procedure i.e take an export backup and then import it to the new Oracle 9i System.I am not sure whether it will work or ...

Oracle 9.2.0.2 installation on HPUX -- execute permission denied

I am trying to install Oracle 9.2.0.2. on HPUX 11.11. When I run the runInstaller script I get "Execute permission denied". I go to run the actual install in Disk1/install/hpunix directory, I get same "Execute permission denied".The installation files were downloaded from Oracle and extracted to the ...

Oracle Ora 8.1.7 on HPUX 10.20?

Can Oracle 8.1.7 be installed on HPUX 10.20? The 8.1.7 Install guide says HPUX 11 is required, but I've found references in various third-party software application install guides that have 8.1.7 on HPUX 10.20, so it's been done. Does HPUX 10.20 need specific patches for 8.1.7, or is this a case of ...

Please Assist Oracle Install on HPUX

Issue multiple versions of oracle (8.1.7,9.0.1,9.2.1) are not installing correctly on my HPUX 11.0 box. I am running a 64 bit kernel. I have installed every patch recommened per the Oracle 9.2 Install Guide. I have also set ever kernel parm per that guide. I continue to have the same problem while i ...

Oracle HPUX 32 bit Installation

I am running HPUX 11.11 (11i). The machine is a 32-bit machine. I need to know what version of oracle database I need to install. In reading docs for 9.2.0.1.0 it installs only on 64 bit machines.Any help appreciated. ...

Oracle RPC error: (ORA-28575) and (HPUX Error: 32: Broken pipe)

I have many Oracle instances on an HP-RISC box, that has HP-UX 11 installed.I have properly configured listener.ora, tnsnames.ora and sqlnet.ora, according to many docs from Metalink, but I cannot call external procedures because I receive an RPC connection error, according to the messages below.It ...

Oracle HPUX response file for 10g

Can anyone provide example response file(s) for doing a 'silent' install ( -silent ) on an HPUX platform for Oracle 10g? Oracle provides some for Solaris, but has indicated none exist for HPUX. When we tried to use the -record feature, it failed, so that was no help in providing any further informat ...

Oracle 8i R3 Installer for HPUX

Does somebody still have an Oracle 8i R2 installer for HPUX? I will appreciate any help. ...

Oracle Client installation on Unix (HPUX)

I can not install the client on an HPUX box, here is what I have done:I have downloaded and extracted 10g Enterprise/Standard Edition into /home/oracle/Disk1 [the client software should be here?]I have successfully installed the 10.2 Server on my HPUX (11.11) box. The Oracle database installation gu ...

oracle client on hpux 11

I want to install and configure oracle client on hpux 11.Can anyone let me which is link to download the software ?and how to configure it ? ...

Need to know the link for oracle 9i client for hpux 11i

I just wanted to install the oracle 9i client for hpux 11.Can anyone suggest the link for free download of this software ? ...

Oracle HPUX 11.11 Kernel Parameters

I have a RP7410 HPUX 11.11 server running Oracle 8.1.7. We are going to upgrade to Oracle 9i. The current kernel sets are a little off from recommended by Oracle/HPAny formula that has nproc as part of it are hard coded to a number that is generally low or very low from the recommended. i.e. not usi ...

Oracle Migration of VLDB from HPUX to Linux

We are in the process of migrating the majority of our oracle database environment from HPUX 11 - 64-bit to RedHat ES 4.0 64-bit. We have some databases that are over 100gig running either Oracle8i or Oracle9i. In most cases we can upgrade to Oracle10g as part of the migration and in the case of the ...

Oracle Shared server ? 9i - HPUX

I want to pass of dedicated server to server shared. I have a BD Oracle 9i on an itanium with HPUX. For the DBCA I don't see the direct option to make it for modification of BDWhat parameters should modify and that you value approximate I should give them. ...

Oracle 8.1.7 and HPUX IA64

I have been requested to install an oracle 8.1.7 on a HP IA system running HP-UX11.23 , I thinks it is not support but not sure? did any one have this experience to install an ORA 8.1.7 into HPUX 11.23 IA system. BTW both are in 64 bit version ...

Oracle OCIEnvCreate fails on hpux 11.11 using instant client 10_2

I have this same C app running on Windows, Linux and Solaris, but on hpux!??!?It have been cleanly recompiled on this hpux system with libclntsh.sl and runs except OCIEnvCreate() returns -1.- Only instant client installed (no other Oracle s/w)- Same tnsnames.ora (as used on other platforms) which re ...

Linking oracle in HPUX Itanium (64 Bit)

HiI am trying to relink Oracle 9.2.0.7 on HPUX Itanium. I get the following error message. Could someone help me out to resolve this.Thanks and RegardsJai"ld: Can't find library or mismatched ABI for -lskgxn9Fatal error.*** Error exit code 1"Here are the steps i followedSet the environment variable: ...

Oracle 10g R2 installation on a directory with cio (concurrent IO) option

I tried to reinstall my Oracle 10g R2 (10.2.0.1) on AXI 5.3L with -o cio option. If I want to mount the subdir with cio option, do I have mount it before I install the Oracle using the subdir or after the installation? tried once yesterday and it was very slow. That was not like such 2 months ago, w ...

Oracle Cluster Configuration File not found (HPUX)

I'm trying to configure Clusterware in HPUX 11i version2 with MC/ServiceGuard and when i arrive in specifying Cluster configuration, oracle installer ask to enter the Cluster configuration file, i can't locate it in my system, and i'm hanging on it. So if someone can help me for this problem, what a ...

Oracle 10g Cluster Configuration file not find (HPUX)

I'm trying to configure Clusterware in HPUX 11i version2 with MC/ServiceGuard and when i arrive in specifying Cluster configuration, oracle installer ask to enter the Cluster configuration file, i can't locate it in my system, and i'm hanging on it. So if someone can help me for this problem, what a ...

Oracle OCIEnvCreate fails on hpux 11.11 using instant client 10_2

(this is posted on Instant Client forum - no response so modified and reposted here)I have this same C app running on Windows, Linux and Solaris, but on hpux!??!?It have been cleanly recompiled on this hpux system with libclntsh.sl and runs except OCIEnvCreate() returns -1.- The app and Oracle compo ...

Oracle 10g install on HPUX PA RISC

I tried to install 10g on HPUX PA RISC. During OS analysis phase it found a couple of missing patches & halted installation.I found that these OS patches were part of the OS patch bundle,so I could continue installation of Oracle 10g without appying OS patches. Since these patches are already pa ...

Oracle HPUX 11.31

We have an HPUX Itanium with 11.31. Which one is the correct Oracle version for this OS?Can we take the Itanium version or exists a version for 11.31?is this one correct: Oracle Database 10g Release 2 (10.2.0.1.0) for HP-UX Itanium ?(we will use it with ASM) ...

Oracle automatic startup on hpux

is setting up the /etc/oratab good enough for automatic startup of oracle instance after reboot? i have not had success with that.do i also need to set something up under /sbin/init.d directory?db version is 10g and OS is hpux. ...

Oracle Segmentation fault after connecting in HPUX 11.23 (ia64)

I've got some code that connects to the database and runs a query and works in all of the OS's I've tried porting to so far (Windows, Sun 5.7 and 5.9, 3 flavors on Linux, AIX and HPUX 11.11.In HPUX 11.23, I compile fine. When I run the code, all of the initialization checks (conf files and prop. dat ...