Home » RDBMS Server » Server Administration » Unable to connect to database (Oracle 11.2.0 , Linux)
Unable to connect to database [message #596719] Thu, 26 September 2013 00:08 Go to next message
Mohan10g
Messages: 135
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
Re: Unable to connect to database [message #596720 is a reply to message #596719] Thu, 26 September 2013 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 21942
Registered: January 2009
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
Re: Unable to connect to database [message #596778 is a reply to message #596719] Thu, 26 September 2013 05:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And please describe what migration method you used.
Re: Unable to connect to database [message #596882 is a reply to message #596778] Fri, 27 September 2013 01:46 Go to previous messageGo to next message
Mohan10g
Messages: 135
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

icon5.gif  Re: Unable to connect to database [message #596883 is a reply to message #596882] Fri, 27 September 2013 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 57609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Which is exactly?

Re: Unable to connect to database [message #597749 is a reply to message #596883] Tue, 08 October 2013 04:35 Go to previous messageGo to next message
8939513598$
Messages: 101
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?

icon13.gif  Re: Unable to connect to database [message #597759 is a reply to message #597749] Tue, 08 October 2013 05:41 Go to previous message
Michel Cadot
Messages: 57609
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Fri Apr 18 09:06:00 CDT 2014

Total time taken to generate the page: 0.10841 seconds