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
rt-setup-database(8)					     Request Tracker Reference					      rt-setup-database(8)

NAME
rt-setup-database - Set-up the database for Request Tracker SYNOPSIS
rt-setup-database --action ... OPTIONS
action Several actions can be combined using comma separated list. init Initialize the database. This is combination of multiple actions listed below. Create DB, schema, setup acl, insert core data and initial data. upgrade Apply all needed schema/acl/content updates (will ask for version to upgrade from) create Create the database. drop Drop the database. This will ERASE ALL YOUR DATA. schema Initialize only the database schema To use a local or supplementary datafile, specify it using the '--datadir' option below. acl Initialize only the database ACLs To use a local or supplementary datafile, specify it using the '--datadir' option below. coredata Insert data into RT's database. This data is required for normal functioning of any RT instance. insert Insert data into RT's database. By default, will use RT's installation data. To use a local or supplementary datafile, specify it using the '--datafile' option below. datafile file path of the data you want to action on e.g. "--datafile /path/to/datafile" datadir Used to specify a path to find the local database schema and acls to be installed. e.g. "--datadir /path/to/" dba dba's username dba-password dba's password prompt-for-dba-password Ask for the database administrator's password interactively skip-create for 'init': skip creating the database and the user account, so we don't need administrator privileges root-password-file for 'init' and 'insert': rather than using the default administrative password for RT's "root" user, use the password in this file. perl v5.14.2 2013-05-22 rt-setup-database(8)
All times are GMT -4. The time now is 08:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy