Your instance is already started. You use -starttype srvc,inst in a oradim
command before you run that sql file, which starts the instance, so the sql
file fails.
Hth,
--
Sybrand Bakker, Oracle DBA
<grogersssbn_at_my-deja.com> wrote in message
news:85lqvv$rta$1_at_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 Fri Jan 14 2000 - 00:49:37 CST
