Unable to start new database in 9i

Published: 12 Jul 2004

I am unable to start up a new database in Oracle 9i. If I give the end command startup nomount=pfile then problems arise, but my init.ora file is correct. Also, the RMAN backup is not working. Can you help?

There could be any number of reasons why you cannot start your new database. Did you connect to the database as someone in the SYSDBA or SYSOPER group? After that, the syntax to start the database in NOMOUNT mode is:

START NOMOUNT PFILE=/directory/initSID.ora

Since there are a number of reasons why the database won't start, we'll need more information from you. Please resubmit your question with a complete cut-and-paste of your exact command and any and all errors messages.

Dig Deeper on Oracle database backup and recovery

How to copy Oracle Database 9i to a new server Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.

Functions of PFILE, SPFILE and INIT.ORA What is the difference between the PFILE, SPFILE and INIT.ORA, and what is the function of each?

Cannot create services in Oracle 9i I am trying to create a database manually in Oracle 9i. I successfully created a password file but am unable to create services.

How to increase SGA_MAX_SIZE in Oracle How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup.

ORA-00204 and ORA-07373 errors during database recovery Attempting to recover an Oracle database on a new Unix server, the system returns an ORA-00204 error when trying to start up the databases.

Can't connect to Oracle after running alter statement After running an alter statement and restarting the system I cannot connect to Oracle. It gives me the errors "ORA-01034: ORACLE not available" and "ORA-27101: shared memory realm does not exist."

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Unable to start new database in 9i

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchSAP

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SearchSQLServer

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

TheServerSide.com

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

SearchDataCenter

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Why reducing hiring bias isn't easy

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.