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


ADVERTISEMENT

Server Utilities :: To Use Sqlldr In Fedora Linux

May 12, 2011

Im trying to use sqlldr in Fedora Linux but it doesnt work

The message:

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS

oracle.sh:

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib:/usr/include/oracle/11.2/client:/usr/share/oracle/11.2/client
export ORACLE_SID=zxin
export PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

View 6 Replies View Related

Free Oracle Download For Fedora 5

Nov 30, 2006

i am looking for a free download by oracle meant specifically for Linux. i am using fedora core 5 32 bit version of Linux.

View 1 Replies View Related

Way To Start Oracle Database 10g Express Edition On Fedora

Sep 29, 2007

am having problems starting Oracle Database 10g Express Edition on Fedora. Here is what I did in order to start it:

[root@x1-6-00-c0-9f-bb-ba-57 ~]# /etc/init.d/oracle-xe start
[root@x1-6-00-c0-9f-bb-ba-57 ~]# xhost +
access control disabled, clients can connect from any host

Not sure what I am doing wrong here.

View 2 Replies View Related

Oracle 10g On Linux System - ORA 12560 Error On Client Side?

Jan 2, 2011

i have installed oracle 10g on linux system. and i am using xp as a client when i use this

cmd>conn scott/tiger@database at client side i receive ora-12560 error

while my database is up and listener and tnsping also working at server side.

View 3 Replies View Related

Installation :: 11g R2 In Fedora 17 (32 Bits) System - Oracle Patch To Enable DB Console?

Apr 23, 2013

I have been working in the installation of oracle 11g r2 in my fedora 17 (32 bits) system for a few days and still have not gotten.Now I found that I need the OPtatch for enable the db console and even being a member of My Oracle Support I can not request the patch for a technical question.

1) Note to the Approver: I am that one because I am an end user (freelance)

2) Support Identifier: How can I get it?

View 6 Replies View Related

Datapump Error On Import To Linux Server?

Sep 27, 2011

have 2 Oracle server. One with Suse Linux (Oracle 10.2.0.4.0) and one with Windows 2003 Server x64 (Oracle 11.2.0.1.0).
I made a mistake by installing Oracle 11 x32 on a x64 server. Nevertheless it works for about half a year. Then my backups
with datapump don't work. I changed the SGA_TARGET down to 1024M and the datapump works again. Now I want to renew the Windows server and want to import the datapump schemes to the Linux server.

Exp: expdp SCHEMA1/****@db1 DIRECTORY=dmpdir DUMPFILE=SCHEMA1_EXPDAT.DMP LOGFILE=SCHEMA1_EXP.LOG VERSION=10.2.0.3 REUSE_DUMPFILES=YES
Imp: impdp SCHEMA1/**** DIRECTORY=dmpdir DUMPFILE=SCHEMA1_EXPDAT.DMP LOGFILE=SCHEMA1_IMP.LOG

Log:
..importing SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
..importing SCHEMA_EXPORT/SEQUENCE/SEQUENCE

[code]...

View 1 Replies View Related

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

Install Oracle 10g And 11g In Same Linux Server?

Jul 19, 2012

Looking to install oracle 10g in same server where i have installed already oracle 11g,

: i have looked at how to install oracle 11g and 10g on same linux server.but didn't quite get it ....

View 15 Replies View Related

PL/SQL :: Oracle 11g On Linux - Collapsing Rows

Jan 28, 2013

Oracle 11g on Linux. Previously submitted as Matching Rows.

I have the following table.
create table p
    (pid varchar2(10),
     first_name varchar2(10),
      last_name varchar2(10),
      type_code varchar2(5)     
      );
    
[Code]....

I used SELECT *
  FROM (SELECT pid,
               first_name,
               last_name,
               type_code,
               COUNT (*) OVER (PARTITION BY first_name, last_name, type_code)
                  cnt
          FROM p)
WHERE cnt > 1;

to get only the rows 1A and 3A

PID  FIRST_NAME    LAST_NAME     TYPE_CODE
1A   DENNIS               ALRIDGE          G5
3A   DENNIS               ALRIDGE          G5

but, a new requirement is to get it in the format:

PID1  FIRST_NAME1    LAST_NAME1     TYPE_CODE1                      PID2  FIRST_NAME2    LAST_NAME2     TYPE_CODE2
1A     DENNIS           ALRIDGE           G5                        3A    DENNIS         ALRIDGE          G5

I tried mod(rownum,2) != 0 to separate the row numbers, but the output is offset with null like:

PID1  FIRST_NAME1    LAST_NAME1     TYPE_CODE1                     PID2  FIRST_NAME2    LAST_NAME2     TYPE_CODE2
1A         DENNIS           ALRIDGE       G5           
                                                                        3A    DENNIS         ALRIDGE          G5

How do I  collapse the rows?

View 8 Replies View Related

XE :: Where To Download Oracle Database For X86 Linux

Jun 5, 2012

URL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....

View 2 Replies View Related

XE :: How To Install Oracle XE 11g On Linux 6 (x86_32)

Aug 9, 2012

Can I install Oracle XE 11g on Oracle linux 6 (x86_32). Where can I download XE rpm?

View 3 Replies View Related

How To Install Oracle EM Remote Agent In Linux

Nov 14, 2006

When I was installing the oracle DB and instance in my linux server, I chose not to use oracle EM to administer it. I want to add the EM now, may I know what is the procedure?

If I want to use oracle EM installed in another server (for example oracle windows server) to administer it. May I know how to install just the EM remote agent in the local linux server ? what is the procedure?

View 1 Replies View Related

Forms :: Configured Webutil For OAS On Oracle EBS R12 Linux 64?

May 1, 2010

I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.

Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"

webutil configuration steps on R12 or the error solution,

View 1 Replies View Related

Security :: Possible To Create New Directory On Linux Fs From Oracle

Nov 29, 2010

I understand how to create a database directory object to point to a directory on the server File System. Is there a way to take the next step and create a new directory on the host file system from within Oracle?

View 8 Replies View Related

Create Dummy User Like Oracle On Linux OS?

Aug 28, 2013

Is it possible to take export import to the Oracle DB/Schema/Table from other linux user? i have plan to create dummy user like oracle on Linux box, so developer will use this dummy user and logging to oracle BOX and take the dump.  I have created one user "TEST" in linux OS. but what is the next? what privilege is required or take dump from other linux user? 

oracle:x:501:502::/home/oracle:/bin/bashtest:x:502:504::/home/test:/bin/bash

View 19 Replies View Related

Reported When Migrating Oracle 11g From Solaris To Linux?

Oct 25, 2013

What are reported issues when migratin Oracle 11g from Solairs to Linux? 

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

Forms :: Migrating Oracle 10gr2 From Windows To Linux

Feb 10, 2010

We are planning to migrate the forms application from windows to linux.

View 1 Replies View Related

Migrate From Oracle 10gR2 In Windows To 11gR2 In Linux

Jun 22, 2012

Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:

1.     need to expdp all schemas/users from oracle 10gR2 in Windows,
2.     then impdp each schema/user into oracle 10gR2 in Linux first,
3.     then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4.     Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?

Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?

View 5 Replies View Related

Automatic Storage Management :: Build ASM In Linux Box Oracle 11g?

Dec 28, 2012

I have a Linux box with the below configurations:-

Linux blrulvremoradb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Last time my UNIX administrator have done a partition in this box. I have 100GB lun allocated to this box which is spilitted in two mount points.

/u01 is having 30GB and /u02 is having 70GB. I want to build a ASM in this box and install Oracle 11.2.0.1 and for that I need raw disk.

Is there any useful links or can you guide me to achieve this... My UNIX admin is on leave for new year and I want to do this by my own..

View 5 Replies View Related

Accessing Oracle Database From Windows Into RHEL (Linux)

Nov 12, 2012

We have a scenario where Oracle Database R1 is installed on Windows System and the Client is present on Linux. Both the system is on same network. We can access Windows -2-Windows using TNS entry.

I am unable to connect to this scenario where Database is on Windows and Client is on Linux.

View 8 Replies View Related

Installation :: Linux OS Suited For Running Oracle 11g Smoothly

Sep 19, 2013

What are the free linux OS's that are suited for running Oracle 11g smoothly? 

View 17 Replies View Related







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