OraFAQ Forum: Server Administration » Not able to login remotely with my sys acct after upgrade only locally

Home » RDBMS Server » Server Administration » Not able to login remotely with my sys acct after upgrade only locally (10.2 Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to login remotely with my sys acct after upgrade only locally [message #301486]

Wed, 20 February 2008 17:57

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

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 ?

Report message to a moderator

[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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback, this may help.

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:53:13 CDT 2024