Sponsored Content
Full Discussion: Not able to connect Oracle
Top Forums UNIX for Dummies Questions & Answers Not able to connect Oracle Post 302608079 by cero on Friday 16th of March 2012 05:15:45 AM
Old 03-16-2012
Did you install the database as root or is root member of the os-group dba ? If non of both you will not be able to connect as sysdba.
Usually sqlplus is located at $ORACLE_HOME/bin. You specified ORACLE_HOME during installation of the database (or the database-client).
The default ORACLE_HOME varies between Oracle-releases.

Usually databases are not installed by root but a seperate user (the default username is oracle). Find out if there is such a user on your system (an easy way would be to view /etc/passwd). Oracle-Versions >= 8i come with a script that sets up the environment for you which is /usr/local/bin/oraenv. /usr/local/bin usually is part of your standard PATH. So assuming your database-user is oracle logging in would look like this after you log in to root:
Code:
su - oracle
. oraenv
-- here you're asked which ORACLE_SID you'd like to work with
sqlplus / as sysdba

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to connect to oracle ??

Hi, I am a new user, who wants to connect to oracle through shell scripting. Can anybody help me? Regards, Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies

2. Shell Programming and Scripting

How to connect ORACLE using PERL

Hi Friends, I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement. Could anyone pls let me know. I've tried below command which i found in some website, But it throws some error.:confused: Executed: perl -e 'use DBI; print... (1 Reply)
Discussion started by: Vijayakumarpc
1 Replies

3. Shell Programming and Scripting

How to connect oracle from unix

Hi All, I am trying to connect oracle from unix mechine but i am getting an error like Ksh: sqlplus: not found Any one please tell me how to connect oracle from unix mechine. I would appreciate if any one send the query. Regards, Ravi kumar.Gongati (2 Replies)
Discussion started by: ravi gongati
2 Replies

4. Solaris

Connect Oracle from NATted IP

We have a Sun solaris 9 server (say A), with oracle 9 installed and running, at one place(say X). We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the... (0 Replies)
Discussion started by: skbpk_in
0 Replies

5. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies

6. Shell Programming and Scripting

Unix - Oracle DB Connect

Hello, Returing to Unix scripts after a long while, This might be a simple question for most of you , I need to connect from a .sh script to oracle, select XYZ.nextval from dual , , meaning either get the Current Val or Next Val for a sequence. How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies

7. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

8. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

9. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

10. Shell Programming and Scripting

Connect to Oracle database

could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever. requirement: 1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME
make-sqldeveloper-package - Oracle SQL Developer Debian package builder SYNOPSIS
make-sqldeveloper-package [options] <file> DESCRIPTION
make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer. The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on when downloading the source. This utility will require you to download the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technet- work/developer-tools/sql-developer/> to create the Debian package from. OPTIONS
-b|--build-dir <dir> base directory to build package (autogenerated) -e|--email <email> local maintainer email (use DEBEMAIL or auto-generate) -i|--install install the generated package - needs root privilege (no) -k|--keep-dir keep the build directory (no) -l|--revision <number> local revision to append to package version (1) -m|--maintainer <name> local maintainer name (use DEBFULLNAME or leave empty) -r|--root-command <command> command to gain root privilege for package build (fakeroot) -u|--upstream-version <version> force the upstream version (autodetected) -h|--help display the help screen -v|--version show the program version <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/> AUTHOR
make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>. This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others). GNU
2012-11-13 MAKE-SQLDEVELOPER-PACKAGE(1)
All times are GMT -4. The time now is 02:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy