Sqlplus Is Not Working After Oracle 10g Client Installation On Linux Server

Oct 11, 2012

just now i installed oracle 10.2.0.1 client version in one my linux server. after successfully installation sqlplus is not working .

below are my .profile details.

# Set up the shell variables:
EDITOR=vi
export EDITOR
### Set the umask
umask 022
### Set ulimit

[code].....

View 4 Replies


ADVERTISEMENT

Installation :: Unable To Install Oracle Database Client On Linux?

Jan 4, 2013

I have installed Oracle virtual box on windows host and have created Oracle Linux virtual machine as guest. I have installed the database server on my host machine but rest of the things(Peoplesoft peopletools etc....) on Oracle Linux guest.Now, I am trying to installed database client on guest machine which is Linux so that I can connect to DB server running on host, but having difficulties in doing so.

, I am following the installation instruction given in the doc docs.oracle.com/cd/E11882_01/install.112/e24322.pdf, but when I finally run command runInstaller.sh doesn't happen anything.Actually, to install other software's I just double clicked the .sh file and it automatically started the installation process on a terminal window but when I clicked runInstaller.sh to install DB client, it didn't do anything.

Also, when I run the same command runInstaller.sh from command line after navigating to the directory where this file is present, It throws me error saying "no command found".By the way, why the steps given in doc are so complex, I wish If I could just double click runInstaller.sh just like others and it start the installation process.

View 22 Replies View Related

Server Administration :: Oracle Ocfs2 Not Working In Enterprise Linux 6.2

Mar 29, 2013

RPMS needed by OCFS2 for oracle enterprice linux 6.2,Since we unable to mount through OCFS2 console.

View 1 Replies View Related

Server Administration :: Installation Steps For Oracle 10g 10.2 On Linux 6 Using Vmware

Mar 16, 2012

A link which describe step by step with screen shots how can i install oracle 10 r2 on oracle linux server release 6.1 using vmware workshop 8.my actual os is windows server 64 bit in this in install vmware 8 and i install oracle linux server release 6.1 32 bit now i want to install oracle 10g r2 or oracle 11g r2 on this .

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

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

RAC/ASM Clusterware Installation :: 11gr2 On Vmware Server - Linux 5.5?

Feb 3, 2013

am trying to install rac 11gr2 config on linux 5.5 on vmware server.

following doc:

[URLs]...

but as in the first step VMware Server Installation:First, install the VMware Server software. On Linux you do this with the following command as the root user.

# rpm -Uvh VMware-server*.rpm

i couldn't find any where on linux disks.

View 2 Replies View Related

Oracle Installation Error On Ubuntu-sqlplus / Command Not Found

Mar 5, 2011

tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:

rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
[color="#000000"][/color]
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found

i have also tried to set the oracle_home, oracle path & oracle SID.

find the below configuration parameters which i have set to.

root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`

[code]....

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

Client Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC

Jul 11, 2012

I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.

View 4 Replies View Related

Installation :: Wrong Initial Group For Oracle Linux Account

Oct 19, 2013

Before I install the Oracle database 11.2.0.1 in Linux server 2.6.39-400.209.1.el6uek.x86_64, I created the following groups

oinstall, dba, oper, and asmadmin.  groupadd oinstall  # required from training groupadd dba # required from training groupadd oper  # and group asmdba, asmoper from training groupadd asmadmin  #

optional from training I made a mistake when I created Oracle user account. I created it with dba as initial group“ useradd -g dba -G oinstall,oper,asmadmin oracle”, instead of “useradd -g oinstall -G dba,oper,asmadmin oracle” After all I installed Oracle database, now I have concerns and questions. Should I use user mod to update the Oracle user account to install as initial group or just leave it alone? If I now do “usermod –g oinstall –G dba,oper,asmadmin oracle”, will it break anything, any impact to the database?

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

Client Tools :: SQLPLUS Windows In Oracle 11g

Feb 27, 2011

the reason for not availability of ISQLPLUS & SQLPLUSW window from oracle 11g.

View 3 Replies View Related

Client Tools :: Windows 7 / Oracle 10g - Not Getting Editor From Sqlplus

Jan 29, 2012

I am using Windows 7 and oracle 10g; From sqlplus* I can not use editor (using ed). but when I see the variable from DEFINE.. It shows that default editor is notepad..

I can use editor in winxp.How to get (use) editor ?

View 1 Replies View Related

Client Tools :: SQLPLUS For Oracle 11 Not Rolling Back

Sep 3, 2013

I have a shells script which invokes a SQL file. However even with AUTOCOMMIT OFF and on SQLERROR EXIT ROLLBACK. Sqlplus fails to rollback.

My sql file has 3 lines 3 are correct and 1 is incorrect. For example:
INSERT INTO TEST_ROUTING VALUES (24, 'ROUTING');
INSERT INTO TEST_ROUTING VALUES (25, 'ROUTING');
INSERT INTO TEST_ROUTING VALUES (26, 'ROUTING);

Lets say file is called 1.sql

My shell script invokes this SQL as follows: (Where $File1 = 1.sql)

$SQLPLUS_PATH/sqlplus -s /nolog <<-EOF>> ${LOGFILE}
connect $DB_USER/$Password1@$Database1
SET AUTOCOMMIT OFF
@$File1
WHENEVER SQLERROR EXIT ROLLBACK;
EOF
[code]......

So tried SET AUTOCOMMIT, tried SQLERROR ROLLBACK and tried few variations.

View 7 Replies View Related

Installation :: Client 32x And 64x Installation In Same Server

Jan 18, 2013

I have a Windows Server 2008 R2 64x with Oracle DB 11.2.0.1.0 64x and client 64x correctly installed and working. I need install the client 32x because some applications require.

View 2 Replies View Related

Installation :: Client 32x And 64x Installation In Same Server?

Jan 18, 2013

I have a Windows Server 2008 R2 64x with Oracle DB 11.2.0.1.0 64x and client 64x correctly installed and workingI need install the client 32x because some applications require.

View 8 Replies View Related

Client Tools :: Migration From Windows Mssql To Linux Oracle

Dec 10, 2012

Env destination-linux:2.6.18-308.13.1.el5,oracle:10.2.0.1 ,source:windows.mssql v:8.00760

I was try migrate one sample database from mssql "Pubs" using Oracle SQL Developer Tool.

After migraton i've got prefixes in tables like MD_<table_name> but i can not see tables from Pubs only a lot of tables like :

MD_COLUMNS
MD_GROUPS
etc...

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

Sqlplus UI - Not Working?

Apr 22, 2008

I'm having some minor trouble with my sqlplus in Windows. Don't know which feature I accidentally edited by cosole seems to be in debug mode. Everything is ok, except that it print the old and new values of my variables. How can't I restore it to it's original behavior.

View 3 Replies View Related

Client Tools :: Connect With Sqlplus Or Toad - Unable To Initialize Oracle Call Interface

Sep 6, 2012

when i try to connect with sqlplus or toad then i get an error

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Users>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
C:Users>

and i want to tell what i do before it-my all files were be converted in .FLT then i shorted out this problem after that when i tried to connect with sqlplus or toad then i get above error.and i have restarted my system but throwing same error.

i am using oracle 11.2.0.1 on windows 7

View 5 Replies View Related

Windows / .NET :: Oracle ODBC Drive In Linux Client To Connect With Mono Application

Aug 6, 2012

I am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine

Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager

For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string

Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager

but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database

View 1 Replies View Related

PL/SQL :: Calling Dbms_Scheduler From Forms Trigger To Invoke SqlPlus Script In Linux

Mar 25, 2013

I would like to use Dbms_Schedule to call SqlPlus script in Linux .

BEGIN     
sys.Dbms_Scheduler.Create_Job (
job_name => 'TEST_SQL_JOB',

[Code]....

This is giving me the error: ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory

BUT when I issue the command: /usr/local/bin/sqlplus -s s/ibs @/usr2/dms/run/lkp_sql_test.sql
it works fine.

View 4 Replies View Related

Server Administration :: Server Installation Gets Abruptly Ended For Client Get TNS Errors

Jan 11, 2011

after a long time,(i never remember when was the last time i installed 9i)i was asked to install 9i.So, whether i install server or cilent i get this error <attachment>

after i ignore it and finished the installation,The server installation gets abruptly ended for the client i get TNS errors.

View 2 Replies View Related

Forms :: Oracle 10g On Mac Client And JRE Settings Not Working?

May 30, 2010

I have an application server on windows 2003 server. Now i have one Mac Book and i want to use the application in that. I have searched and find that i have to change in formsweb.cfg. I have made the changes according to that but my screen is coming blank only. I have change the formsweb.cfg like this

[jpi]
baseHTMLJInitiator=basejpi.htm
form=d:accountlogin_form.fmx
workingdirectory=d:account
userid=account/account@ORCL
width=1200

[code]...

View 4 Replies View Related

Forms :: How To Run 6i From Server Without Runtime Installation On Client PC

Sep 20, 2013

How To Run Forms 6i from Server without Runtime Installation on Client Pc.

View 5 Replies View Related

PL/SQL :: Up And Down Arrow Keys Not Working Properly When Using SQL CLI On Linux?

Feb 27, 2013

Every time I hit up, down, left, and right arrow keys to return to a previous sql command I got ^[[D, fix this issue? The backspace works fine with me.

View 2 Replies View Related

Installation :: Oracle 11g Client Install

Jul 2, 2012

I rarely do client installs. I have not downloaded upgrades on a couple of years. I have been doing other stuff and oracle supports patching page has changed.

Need to install 11.2 on HP Itanium 64 bit. I can get 11.2.0.1 from otn.oracle.com.

1. I downloaded the 11.2.0.1 client from otn. I want to see if there is an 11.2.0.2 or 11.2.0.3 patch on Oracle support. I can only find upgrades that are specifically for the databsae server. Do I use this? See below for the notes I used so far. Note: Oracle Database Upgrade Path Reference List [ID 730365.1]

Which leads me to the following patch below. However, this download is much larger than the client download on otn. It also says 'database server' and does not break out to 'database client'.So not sure if this is what I use to patch the client or not. This upgrade is also much larger than the straight client download. So not sure if this is what I use to just upgrade the client.

Patch:10404530 Description 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
Product Oracle Database Family

This upgrade seems to be for the whole database and not just for the client install.

2. Do you apply PSU's to the client? I see them listed for the 'database'. Not sure if you apply to a separate client install.
3. We use the proC pre-compiler. When I look in the instant client download section, I see a seperate section for the proC pre-compiler download. I don't see that for the full blown client. Does the regular client download include the proC pre-compiler?

View 2 Replies View Related

Client Tools :: Installation Of Oracle 10g At Window 7 64 Bit?

Apr 3, 2012

can we install oracle 10g,developer 2000 at window7 64 bit

View 9 Replies View Related

Installation :: Oracle 11g Client 32bit And 64bit?

Sep 14, 2012

I have Windows 2008 R2 64 Bit Operating Server Installed.

Other software that are Installed :

1) Visual Studio 2010 Ultimate 32 Bit.

2) Microsoft SharePoint server 2010 64 Bit.

For my development purpose I want to install both oracle 11g client 32 bit and oracle 11g client 64 on the same machine.

Is it possible to install both 32 and 64 bit instance on the same machine.

View 5 Replies View Related







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