Home » RDBMS Server » Server Administration » Help In creating the Database
Help In creating the Database [message #51004] Fri, 19 April 2002 02:38 Go to next message
Milind S Deobhankar
Messages: 33
Registered: January 2002
Member
Hi,

I need help in creating the database on NT.
Previously i was having one database and had performed the following operations on it:
1) drop the database by removing all data, log, controlfiles
2) Remove the oracle service with the help of ORADIM
3)Uninstall the oracle and format the partition

After that i install the oracle 8.1.7.0.0 with custom options and no database creation option.

Now i want to create the database manually for that i had done the following operations:

svrmgrl
ORA-12560: TNS:protocol adapter error
svrmgrl> connect internal as sysdba
but it failes with the following error
ORA-12560: TNS:protocol adapter error

so i tried the other way out but still it failes

oradim -NEW -SID abc -INTPWD milind
SVRMGRL> connect internal as sysdba
password: milind
ORA-12560: TNS:protocol adapter error

The service ora_hometnslistener was strated even this error occur

Can anybody help to connect so that i can create the database using the create database syntax.

Can anybody tell me what is the efficient way of creating the database manully

Thanks in advance
Re: Help In creating the Database [message #51006 is a reply to message #51004] Fri, 19 April 2002 04:55 Go to previous message
Milind S Deobhankar
Messages: 33
Registered: January 2002
Member
Hi

Solved using the Following

set ORACLE_SID= sid
oradim -new -sid (SID) -intpwd (internal-password) AUTO -pfile (full-init-ora-filename)

Then go to svrmgrl
And then start
Previous Topic: How to move old DB data to newly modified DB?
Next Topic: Need urgent help
Goto Forum:
  


Current Time: Mon Sep 09 18:57:04 CDT 2024