Oracle only works under 'root' ...

Thread View: comp.sys.next.programmer

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Florian Gutzwiller Tue, 06 Oct 1992 10:16

#1752

Author: Florian Gutzwiller
Date: Tue, 06 Oct 1992 10:16

16 lines
1102 bytes

I recently installed Oracle 6 under NeXTSTEP3.0. First of all the installation  
software that handles the thousands of diskettes and messages with Installer  
doesn't work anymore. That wasn't a problem, Installer alone did it as well.

But after running the installation script 'oracle.install' and checking that  
all the processes were running, I can only access Oracle from DBModeler when  
logged in as root. 'sqplus' never worked.

What am I missing ...

-Florian

--
Florian A. Gutzwiller	Phone:  +41-61-281-8600 
Open Systems AG		Fax:    +41-61-281-8603
Basel/Switzerland	E-Mail: flog@open.ch (NeXT)

Re: Oracle only works under 'root' ...

#1759

Author: Neil Greene
Date: Tue, 06 Oct 1992 17:08

25 lines
1606 bytes

In article <1992Oct6.101636.21539@bernina.ethz.ch> flog@open.ch (Florian  
Gutzwiller) writes:
> I recently installed Oracle 6 under NeXTSTEP3.0. First of all the  
installation  
> software that handles the thousands of diskettes and messages with  
Installer  
> doesn't work anymore. That wasn't a problem, Installer alone did it as  
well.
> 
> But after running the installation script 'oracle.install' and checking  
that  
> all the processes were running, I can only access Oracle from DBModeler  
when  
> logged in as root. 'sqplus' never worked.

DBModeler is going to attempt to find tables owned by the current user  
login id unless you have done the appropriate dwrites to look for tables  
owned by "SYSTEM", "SYS" or any other user.

Have you created additional oracle accounts??  Can you access oracle  
through sqldba or sql*plus??  If so, what accounts are you accessing  
oracle through?

I do not know what tables DBModeler is going to try and read when logged  
in as root.  Have you created additional tables under Oracle accounts??

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads