Run SQLPlus on UNIX with another user

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
esantos
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 7
Joined: Wed, 08 Mar 2006 11:26 am
Location: São Paulo

I have Oracle 9I installed on an HP 11i,

and would like to run SQLPlus with a user other than Oracle. I have another machine that it works, but I can not know how.

Example:

Select all

 
HP-UX usdauerp B.11.11 U 9000/800 (tt) 
 
login: esantos 
Password: ********* 
 
$ sqlplus 
 
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 8 11:50:19 2006 
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved. 
 
Enter user-name: system 
Enter password: 
 
Connected to: 
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP and Oracle Data Mining options 
JServer Release 9.2.0.1.0 - Production 
Embrace

Edenilson
Fabão
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Fri, 02 Jun 2006 9:01 am
Location: Mogi das Cruzes - SP
Fabio Alves - DBA em Learning Mode

Young, you need to adjust the environment variables:

Select all

ORACLE_HOME 
ORACLE_SID
and also include this other user in the DBA Group

Answer took it, but left !!
ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 324
Joined: Fri, 02 Jun 2006 1:48 pm
Location: sp
Contact:

Must also have

Select all

PATH=$PATH;$ORACLE_HOME/bin

there yes


Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 9 guests