INTERNAL PROFILE = SYS?

From: Daniel Guzman <dan_at_guzman.net>
Date: Fri, 17 Sep 1999 14:30:31 GMT
Message-ID: <7rtja7$a7l$1@nnrp1.deja.com>

-hope this doesn't appear twice. lost my session while posting.
Hello. We are using an Oracle 8.0.5 DB on NT and I am having problems getting into it via sqlplus. I have a couple of newbie questions:

How do you find out the service name?
Is the HOST STRING(SQL PLUS) the same as the service name?
Is there a way to grant sysoper or sysdba using system or sys?
Can you grant sysdba through gui interface?

My boss changed the sys password and I can't get in using the interal profile anymore on the box. I thought the INTERNAL profile was and alias to SYS or SYSTEM. I also tried the SYSTEM profile's pwd. We need to create a profile and give this profile the sysdba role so we can start and stop the server. Forgive the newbie questions normally a dba would handling this, but we don't have one. And aren't getting one. Thanks,

--

Web Application Programmer
3Com Corporation

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 17 1999 - 09:30:31 CDT