Database Backup and Recovery (MOSC)

MOSC Banner

OMS jobs starting causes problems with process limit

edited May 27, 2020 5:11AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

I am looking for a way to more quickly setup test databases, and to more our production database to a new server...  I would like to use the Oracle data files to do this.

I made a test database on a test server (server1) using a production full export and import.   That worked fine and is up and running on it.   It took a long time.  I then shutdown that database and made a copy of the database files and configuration files.

  

I have a second test database server where I wanted to duplicate the database on.  On setting up the new database, I am using the same SID, database storage structures, and spfile.  I copied over the data files and data structures from server1 to the new server (server2).    I  created a new empty instance on server2 using the same SID using oradim.  It started up fine that night, but when I came in during the morning, I could not log in normally (sqlplus sys/pwd as sysdba).   Received ORA-00020 too many processes error.   I logged in with the -prelim parameter and

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center