Re: INTERNAL PROFILE = SYS?

Daniel

First step, get rid of your boss! ;)

OK, on to the serious stuff.

1. The service names are listed in your TNSNAMES.ORA file, located under c:\orant\net80\admin.
2. Yes
3. From memory, SYS is the only one that has this ability by default. You can check this on a newly created database by issuing "select * from v$pwfile_users".
4. What tool? You can always do it through SQL Worksheet in OEM, not sure about the other tools.

INTERNAL is a superset of SYS. If you can't get the sys password from your boss, go to the NT box the database is on, open an MS-DOS prompt, type in "svrmgr30" and hit return, then connect as internal. You can then change the SYS password back again.

HTH. Pete

Daniel Guzman wrote:

> -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:
>
> 1. How do you find out the service name?
> 2. Is the HOST STRING(SQL PLUS) the same as the service name?
> 3. Is there a way to grant sysoper or sysdba using system or sys?
> 4. 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 - 10:21:39 CDT