ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Oracle Hangs When Creating a Database

Updated on January 8, 2018
tamarawilhite profile image

Tamara Wilhite is a technical writer, industrial engineer, mother of 2, and a published sci-fi and horror author.

Introduction

A database hangs when it fails to process data. Databases hang when the Oracle database is too busy to communicate with users, locked up or cannot resolve errors and complete transactions.

Communication errors between servers and remote clusters interfere and leave transactions hanging during the process of copying existing databases, creating new ones and restoring backup databases.

What can you do when Oracle hangs while you are creating a database?

Database backups and updates will error if the database's connection times out.
Database backups and updates will error if the database's connection times out. | Source

Space and Tablespaces

Oracle uses a temporary tablespace to hold information on database users while the new database is created. If the temporary tablespace runs out of space during the creation process, Oracle will hang. This problem is solved by using the autextend feature to increase the datafile size.

Tablespaces hold the logical structure used to build Oracle databases. Tablespaces contain at least one data file that defines its table structure and indexes. Creating separate tablespaces for user data and database indexes reduces the risk of a database hanging due to corruption or loss. Copying multiple tablespaces allows them to be backed up, copied and restored more easily.

Oracle may hang while you are simply copying an existing database.
Oracle may hang while you are simply copying an existing database. | Source

Hanging When Copying Databases

Oracle database creation via the export and import functions copies an existing database to create a new one. Database copying will hang if the source database has gone down or the network connection fails. If an Oracle table is deleted while it is being read, Oracle will hang or generate an error message. Copying corrupted databases will leave Oracle hanging.

The Oracle database may need to be restored from a backup file to get a clean database to copy. Lag monitoring scripts indicate when a database is slow to respond or stopped responding to copy requests.

The Database Configuration Assistant creates new, standalone databases and new databases on Real Application Clusters or RAC. When creating new databases in the RAC, the administrator must have the administrative and root level access. If the cluster is down, the database creation process may hang.

Hanging When Restoring Databases

The Oracle Recovery Manager or RMAN creates backups of databases. Restoring a database requires the RMAN backup and archive redo log files. When the RMAN backup file runs out of space, the backup aborts. If the archive log file directory runs out of space, the database will hang because it cannot save changes made to the database.

If the archive redo log file is missing, the database restoration may hang. When an Operating System utility is copying the data files, database users may also be altering that information. This corrupts the backup data file. Waiting until users are not on the system to create backups prevents this problem.

Replicat Left Hanging

Oracle Golden Gate Replicat captures real time transactions on Oracle databases and can be used to capture information as two databases share information. Replicat reads data from remote trail files on a database using SQL statements.

Relpicat hangs when it cannot access or process information on a target Oracle database. Replicat will hang if the source database has gone down or the network connection fails. Lag monitoring scripts indicate when a database is slow to respond or stopped responding.

Comments

Submit a Comment

No comments yet.

working

This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

Show Details
Necessary
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
Features
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Marketing
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Statistics
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)