Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.0.5 on NT - ORA-01081: cannot start already-running ORACLE

Oracle 8.0.5 on NT - ORA-01081: cannot start already-running ORACLE

From: <grogers_at_ladwp.com>
Date: Fri, 14 Jan 2000 00:36:56 GMT
Message-ID: <85lr37$ru6$1@nnrp1.deja.com> 





Howdy,



I get the following error message when preparing
to create a new database:

Echo                            ON




SVRMGR> connect INTERNAL/internal


Connected.


SVRMGR> startup nomount


pfile=C:\orant\database\initODS.ora


ORA-01081: cannot start already-running ORACLE -
shut it down first


SVRMGR> CREATE DATABASE ODS



     2> LOGFILE



'C:\orant\database\ODS\redoODS1.ora' SIZE 1024K,




     3>


'C:\orant\database\ODS\redoODS2.ora' SIZE 1024K



     4> MAXLOGFILES 32
     5> MAXLOGMEMBERS 2
     6> MAXLOGHISTORY 1
     7> DATAFILE




'C:\orant\database\ODS\sys1ODS.ora' SIZE 100M


REUSE


     8> MAXDATAFILES 254
     9> MAXINSTANCES 1
    10> CHARACTER SET WE8ISO8859P1
    11> NATIONAL CHARACTER SET WE8ISO8859P1;


CREATE DATABASE ODS



*


ORA-01012: not logged on


SVRMGR> spool off


########end of error file #########



I tried the shutdown command for the ODS sid,
but when I try the startup command (see above)
I get an "insufficient privledges" error.
thanks in advance if you can help me.


Things I tried include:

1) Re-installed Winnt , SP3
2) Re-installed Oracle 8.0.5
3) c:\orant\database\ODS folder is empty.





Sorry this is so long , but the files below
should be easy to follow.


Please reply to:


grogers_at_ladwp.com


thanks,


Greg Rogers


Los Angeles Dept. of Water and Power





Here is the bat file i use to install the
new instance and database:



echo MAKE SURE YOU RUN THIS PROGRAM FROM
echo DIRECROTY: C:\orant\database\


pause


pause


rem

##################################################


###


c:\orant\bin\oradim80 -shutdown -sid ODS -shuttype
srvc,inst -usrpwd internal


rem

##################################################


#####


C:


CD C:\orant\database\


MKDIR C:\orant\database\ODS


echo make sure that the following directory was
created


echo DIRECROTY: C:\orant\database\ODS


pause


pause



echo please open C:\orant\database\tnsnames.ora
file with notepad


echo and follow instructions at the top of that
file


pause


pause



echo please open C:\orant\database\Listener.ora
with notepad


echo and follow instructions at the top of that
file


pause


pause


rem

##################################################


###############


set ORACLE_SID=ODS


C:\orant\bin\oradim80.exe -delete -srvc
OracleServiceODS


C:\orant\bin\oradim80.exe -delete -srvc
OracleStartODS


pause


C:\orant\bin\oradim80.exe -delete -sid ODS
pause


C:\orant\bin\oradim80.exe -new -sid ODS -intpwd
internal -startmode auto -pfile


C:\orant\database\initODS.ora


pause


C:\orant\bin\oradim80 -startup -sid ODS -starttype
srvc,inst -usrpwd internal -pfile


C:\orant\database\initODS.ora


PAUSE


rem C:\orant\bin\oradim80 -delete 	-sid ODS
rem C:\orant\bin\oradim80 -new 	-sid ODS -intpwd
internal -startmode auto 	-pfile
C:\orant\database\initODS.ora
rem C:\orant\bin\oradim80 -startup 	-sid ODS
-starttype srvc,inst -usrpwd internal 	-pfile


C:\orant\database\initODS.ora



echo check That's it's OK, no error messages
echo go to control panel and make sure that the
following


echo services do exists


echo OracleServiceODS


echo OracleStartODS


echo OracleTNSListener80


echo


echo Stop all services


echo Start all services


pause


pause



set ORACLE_SID=ODS


C:\orant\bin\svrmgr30 @runODS0.sql


echo check C:\orant\database\ODS\spoolODS0.$$$
pause


####### end of install bat file####



Here is runODS0.sql file:


spool C:\orant\database\ods\spoolODS0.$$$
set echo on


connect INTERNAL/internal


startup nomount


pfile=C:\orant\database\initODS.ora


CREATE DATABASE ODS



LOGFILE 'C:\orant\database\ODS\redoODS1.ora' SIZE
1024K,


        'C:\orant\database\ODS\redoODS2.ora' SIZE
1024K


MAXLOGFILES 32



MAXLOGMEMBERS 2



MAXLOGHISTORY 1



DATAFILE 'C:\orant\database\ODS\sys1ODS.ora' SIZE
100M REUSE



MAXDATAFILES 254



MAXINSTANCES 1



CHARACTER SET WE8ISO8859P1



NATIONAL CHARACTER SET WE8ISO8859P1;



spool off


######## end of sql file for svrmgr30 ####



Here is my pfile:


db_name = ODS



db_files = 30



control_files =


(C:\ORANT\DATABASE\ODS\ctl1ods.ora,


C:\ORANT\DATABASE\ODS\ctl2ods.ora)



#rollback_segments = (RBS_01,RBS_02,RBS_03,RBS_04)



compatible = 8.0.5.0.0



# db_file_multiblock_read_count =  32


db_file_multiblock_read_count =  8



#db_block_buffers =  36000


db_block_buffers =  1000



shared_pool_size =  12000000



log_checkpoint_interval = 10000



sort_area_size = 4096000



sort_area_retained_size = 1024000



#processes =  200


processes =  59



dml_locks =  200



log_buffer =  512000



sequence_cache_entries =  45



sequence_cache_hash_buckets =  35



max_dump_file_size = 10240



nls_date_format = 'DD-MON-RR'


parallel_max_servers = 8


# log_archive_start = true      # if you want
automatic archiving


# log_archive_format = ods%S.arc


log_archive_dest = C:\orant\database\ODS\archive



background_dump_dest = C:\orant\rdbms80\trace



user_dump_dest = C:\orant\rdbms80\trace



db_block_size = 8192



snapshot_refresh_processes = 1



remote_login_passwordfile = shared



text_enable = true

#global_names = TRUE
#job_queue_processes = 2
#job_queue_interval = 10
#job_queue_keep_connections = false
#distributed_lock_timeout = 300
#distributed_transactions = 5
#open_links = 4
#snapshot_refresh_interval = 60
#snapshot_refresh_keep_connections=false






#audit_trail = true


#timed_statistics = true


log_checkpoint_timeout = 0


########## end of initODS.ora file ########






Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Thu Jan 13 2000 - 18:36:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US