Moving Oracle 11g UNIX Sun Solaries To Oracle 11g Linux Readhat OS

Aug 8, 2012

We would be moving oracle 11g unix sun solaries to oracle 11g Linux readhat OS. what would be the disadvantage and what are the item needs to be verified. Basically advantage of oracle 11g Linux readhat OS.

View 2 Replies


ADVERTISEMENT

Moving Schema From One Database To Another Of Different Unix Flavour With Minimal Downtime

Aug 14, 2013

Oracle version : 10g, 11g (applicable to both) Consider a schema named 'UNIVERSE' present in the database A running on Linux platform where this schema needs to be moved to another database B running on  windows platform or AIX platform with no downtime provided and data needs to be consistent.  Is this practically possible?

View 13 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

Oracle 10G To 11G Upgrade On Unix Env

Jan 21, 2011

Iam planning to upgrade my Oracle Database from 10G to 11G .

Its on HP Unix Environment 11.23 and
Oracle CRS 10.2.0.4
Oracle ASM 10.2.0.4
Oracle RDBMS 10.2.0.4

Its in RAC env...and Active-Active DB running controlled by tnsnames.ora .

View 8 Replies View Related

Moving From MS Access To Oracle SQL Plus

Nov 20, 2012

I need to find information on the cost and difficulty in implementing the change from MS Access to Oracle.

View 3 Replies View Related

RAC & Failsafe :: Oracle 11gR2 RAC On Unix

Aug 8, 2011

I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?

View 3 Replies View Related

SQL & PL/SQL :: Date Conversion From Unix To Oracle

Jun 14, 2010

I have a UNIX shell script as following,

#runs the selected process
${ORACLE_HOME}/bin/sqlplus -s ${USER_PASS} >${TMP_FILE} <<EOF
set pause off
set verify off
set pagesize 0
set linesize 2000
set timing off
[code].........

I am passing a Date to the Oracle Procedure in `date +'%b_%d-%H:%M:%S'` format.

rmsqa813.2 /home/ashlaksh> echo `date +'%b_%d-%H:%M:%S'`
Jun_14-02:26:37

The oracle Procedure's SQL is as following,

SELECT ffdh.fiscal_doc_id INVOICE_ID,
ffdh.location_id LOCATION_ID
FROM fm_fiscal_doc_header ffdh,
fm_schedule fs
[code]........

The above SQL is not getting the data as the Date format "AND ffdh.last_update_datetime <=i_last_update_datetime " is not matching..

Do I need to convert the Date ? ( But i_last_update_datetime is DATE)

View 1 Replies View Related

PL/SQL :: Execute Unix Command From Oracle

Oct 17, 2013

I'm on Oracle 11g R1. I've a requirement where user will be putting CSV files on Unix server and I've to create a job which runs periodically to check if any new file is added by user in the folder. If it finds a new file (s), then it needs to identify it and insert its name in an Oracle table. Once file's name is noted, it has to move file from that directory to another one.

View 2 Replies View Related

Forms :: Print Oracle Report 10g Using UNIX

Mar 25, 2010

I installed a printer(HP Laserjet 3390) in UNIX(Solaris).Followed the instructions while installing as to the path it should be present for Reports to read it etc.,Also modified the uiprint.txt file with the desired .hpd file.Logging on to the UNIX machine, I am using the below command

rwrun.sh report=xyz.rdf userid=XXXX/XXX@xxx paramform=no p_orig_org='0825' desformat=pdf destype=printer desname=xxxx batch=yes
This command invokes the printer and
^[%12345X@PJL
@PJL SET RESOLUTION=300
@PJL SET PAGEPROTECT=OFF
@PJL SET ENTER LANGUAGE=PCL
^[%1A^[E^
@PJL RESET
^[%12345X

is what it prints.Realizing that this is because of the missing parameter,tried to change paramform=yes but I am not sure how to pass the parameter.

View 11 Replies View Related

Forms :: Launch Application From Oracle In Unix OS

Jul 1, 2010

my problem is this. I created the java classes using itext to create a document library. Rtf, or. Odt. I integrated classes in Oralce form and everything works. I created a file. Odt application server on a folder and now only remains for me to open the file. The roads are two:

1. Directly from the server, you can?

2. From the client using the API or openoffice launching the executable with cmd?

Oracle Forms is a command to transfer files on the client and run the executable swriter of openoffice?

View 4 Replies View Related

Forms :: FRM-92100 Error In Oracle 10.1.0.4 Under UNIX B.11.11

Jul 30, 2010

We have recently migrated from IAS 9.0 to IAS 10.1.2 in one of our development Server hosted in UNIX B.11.11. We are using Oracle forms as front end. We have re-compiled all the existing forms and libraries using IAS 10. There were no changes in the forms and libraries. We deployed the forms in our development box and configured it, since we are using our own environment specific copy of default.env file. With few of forms we are facing the FRM-92100 error mentioning the "Connection to Server was interrupted". Most of the forms are running fine but with few forms we are facing this error. Some of details are:-

Oracle 10.1.0.4
UNIX B.11.11
IAS 10.1.2

NLS_LANG parameter in default.env is set to "american_america.WE8ISO8859P1"..We have even tried copying the libraries in our local system and then opening and saving them and ftp'ng them back in to UNIX server and then recompiling there with full permissions but still unable to resolve this error.

View 2 Replies View Related

PL/SQL :: Connectivity Code To Connect Oracle DB In UNIX?

Jun 13, 2013

i need a connectivity code to connect oracle DB in UNIX.pls send me a code exactly.

View 2 Replies View Related

Backup & Recovery :: Moving From One Windows Environment To Another Linux Environment?

Jun 19, 2012

I'm trying to move my backup sets from windows database environment, to OEL 5.7 environment on another server.

I've found a manual [URL] by which I am trying to do it.I took backup sets from last night's backup using RMAN,and the current parameter(initSID.ora) file from the running live database.Now i need to configure control files in the pfile accordingly.

1. can i take current control files from the running system, to restore and recover backup sets from last night, to the state the database was at backup time?

2. how can i find out if control files are backed up and know by RMAN? "list backup completed after '2012-JUN-19';" >> gives me Archive redo logs, datafiles, but don't see the control files(or don't reconize them).

View 15 Replies View Related

Moving Oracle Binaries BTW Volume Managers

Dec 15, 2010

We have Root disk on all the unix servers and is mirrored using SVM using the internal disks. Also VxVM 5.0 MP3 is used as the volume manager to manage the SAN space allocated to the servers. On some instances, SVM is also used for allocating filesystem for application and database

We are required to move all the files from SVM to VxVM.

In the process we are Copying our Oracle binaries from SVM to VXVM.I am planning to use the CPIO command to do the same.Once i move to VXVM (Veritas Volume Manager), i will bring down the SVM.

View 2 Replies View Related

SQL & PL/SQL :: Moving Images From Server To Oracle Database?

Jun 28, 2011

I have a problem(illega use of LONG) while moving image data from SQL Server 2005 database to Oracle10G table in BLOB.

insert into table
select [[mailto:.....tablename@odbc SQL|.....tablename@odbc_SQL]]

I am using HS connection and DBLink.

View 10 Replies View Related

SQL & PL/SQL :: Transfer Excel Files From Unix To Oracle Database?

Jun 6, 2013

I would like to ask you if you know which built-in can I use for transferring a excel file from our Unix box to a table in oracle database, right now we are using webutil_file_transfer.Client_To_DB_with_progress using forms developer, but I need to run as an automatic process uploading form unix into oracle directly without using forms.

View 22 Replies View Related

SQL & PL/SQL :: Attaching A File Residing On Unix And Emailing It Through Oracle?

Nov 11, 2011

I have a file which is placed on a certain location on unix server. I want to write a code which picks up that file and emails it to certain recipients.

View 3 Replies View Related

SQL & PL/SQL :: Insert Into Oracle Table Of UNIX Script Values

Dec 24, 2012

I want to insert STAT and ENDTIME values for each job in joblist into TBL_DAILY_STATUS table.

E.g. : insert into tbl_daily_status values(STAT,ENDTIME);

#!/bin/ksh
joblist="com_abc_job com_abc_dot_job com_abc_seq com_abc_det"
for i in $joblist
do
STAT=`./JobStatus.pl -i NP1 -z Z8PIMBN -p $i|awk '{print $6}'`
ENDTIME=`./JobStatus.pl -i NP1 -z Z8PIMBN -p $i|awk '{print $4" " $5}'`
echo "$STAT"
echo "$ENDTIME"
done

View 2 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 :: Oracle 10gR2 RAC - Moving Archivelog Location

May 25, 2010

We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.

View 1 Replies View Related

Security :: Network Data Encryption Between Oracle Client And Server On Unix?

Jun 4, 2010

We have an application that fetches and writes data into oracle database through pro c. oracle datyabase is on another server.

We are storing some secure information into oracle database so we want to encrypt the data sent by our aplication into oracle database.We do not want to use SSL(i.e certificates) and also do not want to make use of Advance Security Option available in oracle and also do not want to make any changes in sqlnet.ora file on server side.

achieve encryption of traffic between our application and Oracle database?

View 13 Replies View Related

PL/SQL :: Overcome Prompt User ID And Password To Connect Oracle DB From Unix Environment?

Mar 23, 2013

How to overcome the prompt user id & password to connect oracle DB from Unix environment.

View 2 Replies View Related

Oracle 11g EM Not Working (Linux OS)

Jan 20, 2011

I am unable to configure EM(Oracle 11.2g) on Redhat Linux 5 Enterprise edition(32 bit). Environment variables are set to correct SID. If I try to run dbca the wizard does not display the Enterprise manager configuration screen. I have tried to create repository by using emca -config dbcontrol -db config.

But it throws exception that database instance is unavailable?

View 5 Replies View Related

How To Install Oracle On Linux

Feb 25, 2012

how to install oracle on Linux.

View 2 Replies View Related

Oracle 11g R2 Installation On Linux 5.5 - Non-RAC / Non-ASM

Jul 25, 2012

SQL>startup

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora'

Unfortunately I can not find initora11g.ora

[oracle@localhost db_1] cd dbs
[oracle@localhost dbs] ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora

so create pfile from spfile='/home//oracle/product/11.2.0/db_1/dbs/spfileora11.ora will not work

[oracle@localhost dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora

I don't see initora11g.ora file - as shown above in oratab also - it showed sid as orcl but I changed into

I have set oracle_sid = ora11g in .bash_profile as well

View 1 Replies View Related

Oracle 11g Client Linux 32 Bit

Nov 18, 2012

share with me a linnk of oracle 11g client on RHEL 5 32 bit due to i search in oracle web site and found only 64 bit URL.....share with me a link of installation guide of this client?

View 4 Replies View Related

Oracle 9i For Linux Environment (64 Bit)?

Jul 18, 2013

link where can i get oracle 9i for Linux OS??Is 9i available for 64 bit ?

View 4 Replies View Related

Oracle Linux Account

Oct 22, 2012

I have installed oracle enterprise linux 6.2 on my laptop, and I installed the database 11gR2 on it, know the user account I used to log in with (os level) is not accessible any more :

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

if I remove the account and recreate it does it will cause problems to the database?

View 5 Replies View Related

Oracle Error In Linux Fedora

Nov 20, 2006

I get this error when trying to log in to SQLPlus in Oracle

ERROR:

ORA-12516: TNS:listener could not find available handler with matching protocol stack

View 1 Replies View Related

Oracle RAC 11g R1 On Linux Using VMware Server

Jun 15, 2011

During installation of Oracle RAC 11g r1 on Linux using VMware server for Two Nodes, all the pre cluster installation test was successful, and execution of root.sh on node 1 was successful too, but whenever I run the root.sh script on the second node I get error message "Failure at final check of oracle CRS stack. 10"

View 3 Replies View Related







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