OraFAQ Forum: Server Administration » Unable to connect to database

Home » RDBMS Server » Server Administration » Unable to connect to database (Oracle 11.2.0 , Linux)

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

Unable to connect to database [message #596719]

Thu, 26 September 2013 00:08

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi,

I migrated one database ( DB1) from old database server to new database server where
user accounts were locked before migrating the database.But migration was successful and database
and accounts got created in new database server.

In old database server , user accounts status is locked and in new database server user accounts are open
but still i am unable to connect to database using new user in new database server.

Could you tell me why im unable to connect to database whose accounts are open ?

Thank you

Report message to a moderator

Re: Unable to connect to database [message #596720 is a reply to message #596719]

Thu, 26 September 2013 00:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

all we know is what you post.
you claim to have a problem but we have no idea
what you do
what you see
what Oracle does.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

I'd like to help more but you have provided no useful details

Report message to a moderator

Re: Unable to connect to database [message #596778 is a reply to message #596719]

Thu, 26 September 2013 05:24

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And please describe what migration method you used.

Report message to a moderator

Re: Unable to connect to database [message #596882 is a reply to message #596778]

Fri, 27 September 2013 01:46

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi Mahesh,

Quote:

And please describe what migration method you used.

I use logical backup method.

[Updated on: Fri, 27 September 2013 01:47]

Report message to a moderator

Re: Unable to connect to database [message #596883 is a reply to message #596882]

Fri, 27 September 2013 01:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which is exactly?

Report message to a moderator

Re: Unable to connect to database [message #597749 is a reply to message #596883]

Tue, 08 October 2013 04:35

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

Hi Mohan, Since you had mentioned logical backup, i think you were trying to migrate database from one server to different server, are you using datapump?

Report message to a moderator

Re: Unable to connect to database [message #597759 is a reply to message #597749]

Tue, 08 October 2013 05:41

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As he didn't answer till now I think he doesn't want or care to give us what he did.

Report message to a moderator

Previous Topic:	Oracle Scheduler Agent licensing
Next Topic:	Getting Thousands of DB_STRUCTURE_INTEGRITY_CHECK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 01:16:34 CST 2025