Unable to create database using Oracle 10g
Posted on 2005-03-09
Hi Oracle experts
I have been searching googles and many places for an answer. Hope you guys can help
I just installed Oracle 10 g standard Edition on my machine
Win 2003 Enterprise Edition
512 MB Ram
40 GB hard disk (30 GB free)
AMD Sempron 2600+ (1.83 Ghz)
I was using Database configuration assistance (DBCA)
The problem is, when i try to create a database. Oracle just keeps complaining
ORA-12560 - TNS: Protocol adapter error
I ignored the message anyway and it SEEMS an instance created (with SID testdb)
But when i try to go in command line
SQL> connect sys/<password> as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'J:\ORACLE\TESTDB\DATABASE\INITTESTDB.ORA'
There is no INITESTDB.ORA anywhere created by DBCA anyhow??
For more information: here is the lsnrctl result
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=siuboserv.db.siuboserv.com)(PORT=1521)))
STATUS of the LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Pro
Start Date 09-MAR-2005 22:38:00
Uptime 0 days 0 hr. 49 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File J:\oracle\testdb\network\admin\listener.ora
Listener Log File J:\oracle\testdb\network\log\listener.log
Listening Endpoints Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "testdb" has 1 instance(s).
Instance "testdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Anyone, please advise me possible solution on this matter
REALLY appreciate this, as i have been trying solve this for the last three
after many installation attempts