Home » RDBMS Server » Server Administration » Not able to login remotely with my sys acct after upgrade only locally (10.2 Windows)
Not able to login remotely with my sys acct after upgrade only locally [message #301486] Wed, 20 February 2008 17:57 Go to next message
bogey
Messages: 53
Registered: February 2006
Member
I did an upgrade on one of my Oracle 10.2 databases today and I'm not able to login that database from my Enterprise Manager Dataguard using my sys acct from which I manage all my databases.

My paramater file show the password exclusive value but I'm still not able to login using sys sysdba acct remotely, only on the local machine.

[Updated on: Wed, 20 February 2008 18:12]

Report message to a moderator

Re: Not able to login remotely with my sys acct after upgrade only locally [message #301508 is a reply to message #301486] Wed, 20 February 2008 21:48 Go to previous messageGo to next message
borg
Messages: 5
Registered: February 2008
Location: Indonesia
Junior Member

Have u try check component version from dba_registry or running catpatch.sql ?

are u manage from OEM/Gridcontrol ?

icon14.gif  [ANS]Re: Not able to login remotely with my sys acct after upgrade only locally [message #301967 is a reply to message #301508] Fri, 22 February 2008 09:05 Go to previous messageGo to next message
bogey
Messages: 53
Registered: February 2006
Member
Found that I needed to recreate the pwd file. There is a parameter called [force]. I set that value to 'n' and I'm able to login remotely

thanks.
Re: [ANS]Re: Not able to login remotely with my sys acct after upgrade only locally [message #301968 is a reply to message #301967] Fri, 22 February 2008 09:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback, this may help.

Regards
Michel
Re: [ANS]Re: Not able to login remotely with my sys acct after upgrade only locally [message #302678 is a reply to message #301967] Tue, 26 February 2008 10:06 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>There is a parameter called [force]. I set that value to 'n' >and I'm able to login remotely
Can you please give me more details on this.
which parameter "FORCE=N" it is with ORAPWD file clause or it is separate INIT parameter.




Previous Topic: dbca hangs at 85%
Next Topic: TEMP TABLESPACE
Goto Forum:
  


Current Time: Sat Dec 10 01:00:17 CST 2016

Total time taken to generate the page: 0.11754 seconds