Re: Connecting to a database from server manager

If you want to use the sysdba and sysoper accounts to log in to the remote database you need to create a password file using orapwd (unix) or orapwdxx on NT, change remote_login_passwordfile to exclusive and reload your database. Finally you need to grant sysoper or sysdba privileges to the account you wish to login with. Querying v$pwfile_users shows who has what privilige.
HTH,
Kristian Cookes
ICL Outsourcing Oracle DBA.

The opinions above have absolutely nothing to do with the company that employs me and should they not help in anyway, shape or form then I'm sorry ;->

Environment Waikato wrote in message <35513A96.1EDC_at_wairc.govt.nz>...
>DeremiO_at_hotmail.com wrote:
>>
>> I have created a database using Instance Manager. The database is called
>> GAVI_DB, the SID is GAVI, the DBA password entered in Instance Manager is
>> gaviola. The REMOTE_LOGIN_PASSWORDFILE Initialization Parameter is set as
>>
>> REMOTE_LOGIN_PASSWORDFILE= SHARED with the db_name=GAVI_DB.
>>
>> When I run SERVER MANAGER svrmgr23 under Windows NT 4.0 I have problems
>> connecting to the database. I am connecting as INTERNAL with the password
>> gaviola.
>>
>> Any suggestions will be appreciated.
>>
>> Deremi
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
>You don't say what the error is.
>
>However one thing you need to do is make sure that oracle_sid is set.
>Either set the oracle_sid registry variable or type set oracle_sid=<sid>
>before going into server manager.
>
>Erica Harris
>Oracle DBA/System Administrator
>Environment Waikato
>Hamilton
>New Zealand
>
Received on Fri May 08 1998 - 08:01:12 CDT