How do I configure TNS automatically and silently

[Thargy]

I am scripting a db creation, and have used the dbca to produce a script which works.

I am now modifying the script (in windows) to soft code all the file locations and db names etc. so that it will become a general purpose creation script.

I have run through the creation of folders, created a password file and am now attempting to connect via sqlplus to issue the create database command.

however, tnsnames is denying all knowledge of the database. I can't see anywhere in the dbca script where the net configuration assistant is invoked to make the needed entries in tnsnames and listener.ora.

Can anyone advise where and how this happens 'automagically'?

Regards

Tharg

Grinding away at things Oracular

 

[SantaMufasa]

John,

Since tnsnames.ora and listener issues really have nothing to do with a database creation [DBCA] (since those activities are network related), Oracle chooses to handle such configurations with their other (network configuration) utilities/assistants.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Thargy]

David,

I know, that's why I was trying to figure out how to invoke the netca and a suitable rsp file. I can create the basic bits, but when I come to connect as sysdba via sqlplus, I get a TNSnames error. I've manually added an entry, and then I get a listener error.

I suspect that behind the scenes, the dbca silently invokes the net configuration assistant (also in silent mode) to get the job done. Can you shed any further light on this, my frustration coefficient is going off the scale.

Regards

T

Grinding away at things Oracular

 

[LKBrwnDBA]

No need to create the network related files, just invoke sqlplus in your database creation script without using the network (@{dbsid}) option.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

John,

Sorry for the delay in responding back. In the meantime, LK is correct...no need to use the network to connect "as sysdba". Have you tried that on the machine that is local to the Oracle server?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Thargy]

Santa,

yes, but haven't yet found out if that makes the necessary TNS entry. In desperation to meet a deadline, I've cheated and invoked the DBCA in silent mode, but this doesn't give the fine grained control that I need.

I'm still hacking away, but slowly.

Thanks for the help, I'll post again when I get a result from all of this.

Regards

Tharg

Grinding away at things Oracular

 

[SantaMufasa]

haven't yet found out if that makes the necessary TNS entry

Maybe I'm missing something, John, but can you not just look at the contents of your tnsnames.ora file to find "out if that makes the necessary TNS entry?" As a quick test to see if the tns entry works as you hoped, you can (from the o/s command prompt) do a:

tnsping <alias>

...and it will respond with an "OK" at the end of the output, telling you that "all is well" for that tns alias.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[LKBrwnDBA]

Backtracking a bit:

I have run through the creation of folders, created a password file and am now attempting to connect via sqlplus to issue the create database command.

There could be a catch 22 situation: Even if you did have a tnsnames.ora entry for the database you wish to create, you would still get the ORA-12154 error trying to connect using the '@{sid}' option -- It may be the "What was first: the chicken or the egg?" issue where you need the listener to attach to an existing database.









----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Thargy]

Gents,

thanks for your help. Below, I've posted my db_creation routine - its windoze based, so please bear with me.

@echo off 
cls 
echo WinPath7 Database Creator
echo -------------------------

if [%1]==[] (goto instructions) else (SET db=%1)
if [%2]==[] (SET pathone=%ORACLE_BASE%ORADATA\%DB%\) ELSE (set pathone=%2)
if [%3]==[] (SET pathtwo=%ORACLE_BASE%ORADATA\%DB%\) else (SET pathtwo=%3)
if [%4]==[] (SET paththree=%ORACLE_BASE%ORADATA\%DB%\) else (SET paththree=%4)

echo pathone = %pathone%
echo pathtwo = %pathtwo%
echo paththree = %paththree%

REM ===========================================================================
REM == Never alter the oracle home, unless it is to align with a system change.
REM == If it isn't, the entire db creation scripting system will fail.
REM == Because the oracle home is operating system dependent, any references to
REM == oracle utilities will fail, if the home is incorrectly set.  JSH 02 Dec 2006
REM ===========================================================================

SET INSTALL_LOCATION=%ORACLE_BASE%
SET ADMIN_LOCATION=%INSTALL_LOCATION%ADMIN\%DB%\
SET ARCHIVE_LOCATION=%INSTALL_LOCATION%ARCHIVE_LOGS\%DB%\
SET ASSISTANTS=%ORACLE_HOME%ASSISTANTS\
SET DATA_LOCATION=%INSTALL_LOCATION%ORADATA\%DB%\
SET BINARY_LOCATION=%ORACLE_HOME%bin\
SET CREATE_LOCATION=%INSTALL_LOCATION%MAKE_DB\
SET SERVER_NAME=sysmed.local
SET BAT_FILE=%CREATE_LOCATION%%DB%.BAT

echo install_location = %INSTALL_LOCATION%
ECHO admin_location   = %ADMIN_LOCATION%
ECHO archive_location = %ARCHIVE_LOCATION%
ECHO assistants       = %ASSISTANTS%
ECHO data_location    = %DATA_LOCATION%
ECHO binary_location  = %BINARY_LOCATION%
ECHO create_location  = %CREATE_LOCATION%
ECHO bat file name    = %BAT_FILE%

REM ==========================
REM ==  MAKE CREATE_DB.SQL  ==
REM ==========================
IF NOT EXIST %CREATE_LOCATION% MD %CREATE_LOCATION%
SET CREATE_FILE=%CREATE_LOCATION%CREATE_DB.SQL
SET CREATE_FILE_LOG=%CREATE_LOCATION%LOGS\CREATE_DB.LOG
DEL %CREATE_FILE%

ECHO CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA>>%CREATE_FILE%
ECHO SET ECHO ON>>%CREATE_FILE%
ECHO SPOOL %CREATE_FILE_LOG%>>%CREATE_FILE%
ECHO STARTUP NOMOUNT PFILE="%CREATE_LOCATION%INIT.ORA";>>%CREATE_FILE%
ECHO CREATE DATABASE %DB%>>%CREATE_FILE%
ECHO MAXINSTANCES 1 >>%CREATE_FILE%
ECHO MAXLOGHISTORY 1 >>%CREATE_FILE%
ECHO MAXLOGFILES 5 >>%CREATE_FILE%
ECHO MAXLOGMEMBERS 3 >>%CREATE_FILE%
ECHO MAXDATAFILES 100>>%CREATE_FILE%
ECHO DATAFILE '%DATA_LOCATION%system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED>>%CREATE_FILE%
ECHO EXTENT MANAGEMENT LOCAL>>%CREATE_FILE%
ECHO DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '%DATA_LOCATION%temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED>>%CREATE_FILE%
ECHO UNDO TABLESPACE "UNDOTBS1" DATAFILE '%DATA_LOCATION%undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED>>%CREATE_FILE%
ECHO CHARACTER SET WE8MSWIN1252>>%CREATE_FILE%
ECHO NATIONAL CHARACTER SET AL16UTF16>>%CREATE_FILE%
ECHO LOGFILE GROUP 1 ('%DATA_LOCATION%redo01.log') SIZE 102400K,>>%CREATE_FILE%
ECHO GROUP 2 ('%DATA_LOCATION%redo02.log') SIZE 102400K,>>%CREATE_FILE%
ECHO GROUP 3 ('%DATA_LOCATION%redo03.log') SIZE 102400K;>>%CREATE_FILE%
ECHO SPOOL OFF>>%CREATE_FILE%
ECHO EXIT;>>%CREATE_FILE%
REM =================================
REM ==  END OF MAKE CREATE_DB.SQL  ==
REM =================================

REM ==============================
REM ==  MAKE CREATEDBFILES.SQL  ==
REM ==============================
SET MAKE_DATA_FILES=%CREATE_LOCATION%CreateDBFiles.SQL
SET MAKE_DATA_FILES_LOG=%CREATE_LOCATION%LOGS\CreateDBFiles.LOG
DEL %MAKE_DATA_FILES%

ECHO connect SYS/change_on_install as SYSDBA>>%MAKE_DATA_FILES%
ECHO set echo on>>%MAKE_DATA_FILES%
ECHO spool %MAKE_DATA_FILES_LOG%>>%MAKE_DATA_FILES%
ECHO CREATE TABLESPACE "CWMLITE" LOGGING DATAFILE '%DATA_LOCATION%cwmlite01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;>>%MAKE_DATA_FILES%
ECHO CREATE TABLESPACE "DRSYS" LOGGING DATAFILE '%DATA_LOCATION%drsys01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;>>%MAKE_DATA_FILES%
ECHO CREATE TABLESPACE "INDX" LOGGING DATAFILE '%DATA_LOCATION%indx01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;>>%MAKE_DATA_FILES%
ECHO CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '%DATA_LOCATION%tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT  320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;>>%MAKE_DATA_FILES%
ECHO CREATE TABLESPACE "USERS" LOGGING DATAFILE '%DATA_LOCATION%users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;>>%MAKE_DATA_FILES%
ECHO CREATE TABLESPACE "XDB" LOGGING DATAFILE '%DATA_LOCATION%xdb01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;>>%MAKE_DATA_FILES%
ECHO spool off>>%MAKE_DATA_FILES%
ECHO exit;>>%MAKE_DATA_FILES%

REM =====================================
REM ==  END OF MAKE CREATEDBFILES.SQL  ==
REM =====================================

REM ==============================
REM ==  MAKE INIT.ORA           ==
REM ==============================
SET file_dest=%CREATE_LOCATION%init.ora
del %file_dest%

rem echo ############################################################################## >> %file_dest%
rem echo # Oracle original modified by JSH 22 Nov 2006  >> %file_dest%
rem echo ############################################################################## >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Archive >> %file_dest%
rem echo ########################################### >> %file_dest%
echo log_archive_dest_1='LOCATION=%ARCHIVE_LOCATION%' >> %file_dest%
echo log_archive_format=%%d_%%t_%%s.ARC >> %file_dest%
echo log_archive_start=true >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Cache and I/O >> %file_dest%
rem echo ########################################### >> %file_dest%
echo db_block_size=8192 >> %file_dest%
echo db_cache_size=25165824 >> %file_dest%
echo db_file_multiblock_read_count=16 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Cursors and Library Cache >> %file_dest%
rem echo ########################################### >> %file_dest%
echo open_cursors=300 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Database Identification >> %file_dest%
rem echo ########################################### >> %file_dest%
echo db_domain="" >> %file_dest%
echo db_name=%db% >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Diagnostics and Statistics >> %file_dest%
rem echo ########################################### >> %file_dest%
echo background_dump_dest=%ADMIN_LOCATION%bdump >> %file_dest%
echo core_dump_dest=%ADMIN_LOCATION%cdump >> %file_dest%
echo max_dump_file_size=10M >> %file_dest%
echo timed_statistics=TRUE >> %file_dest%
echo user_dump_dest=%ADMIN_LOCATION%udump >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # File Configuration >> %file_dest%
rem echo ########################################### >> %file_dest%
echo control_files=("%pathone%control01.ctl", "%pathtwo%control02.ctl", "%paththree%control03.ctl") >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Instance Identification >> %file_dest%
rem echo ########################################### >> %file_dest%
echo instance_name=%db% >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # MTS >> %file_dest%
rem echo ########################################### >> %file_dest%
echo dispatchers="(PROTOCOL=TCP) (SERVICE=%DB%XDB)" >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Miscellaneous >> %file_dest%
rem echo ########################################### >> %file_dest%
echo compatible=9.2.0.0.0 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Optimizer >> %file_dest%
rem echo ########################################### >> %file_dest%
echo hash_join_enabled=TRUE >> %file_dest%
echo query_rewrite_enabled=FALSE >> %file_dest%
echo star_transformation_enabled=FALSE >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Pools >> %file_dest%
rem echo ########################################### >> %file_dest%
echo java_pool_size=33554432 >> %file_dest%
echo large_pool_size=8388608 >> %file_dest%
echo shared_pool_size=50331648 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Processes and Sessions >> %file_dest%
rem echo ########################################### >> %file_dest%
echo processes=150 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Redo Log and Recovery >> %file_dest%
rem echo ########################################### >> %file_dest%
echo fast_start_mttr_target=300 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Security and Auditing >> %file_dest%
rem echo ########################################### >> %file_dest%
echo remote_login_passwordfile=EXCLUSIVE >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # Sort, Hash Joins, Bitmap Indexes >> %file_dest%
rem echo ########################################### >> %file_dest%
echo pga_aggregate_target=25165824 >> %file_dest%
echo sort_area_size=524288 >> %file_dest%

rem echo ########################################### >> %file_dest%
rem echo # System Managed Undo and Rollback Segments >> %file_dest%
rem echo ########################################### >> %file_dest%
echo undo_management=AUTO >> %file_dest%
echo undo_retention=10800 >> %file_dest%
echo undo_tablespace=UNDOTBS1 >> %file_dest%

REM =====================================
REM ==  END OF MAKE INIT.ORA           ==
REM =====================================

REM ================================
REM ==  MAKE CreateDBCatalog.SQL  ==
REM ================================
SET file_dest=%CREATE_LOCATION%CreateDBCatalog.sql
SET log_dest=%CREATE_LOCATION%LOGS\CreateDBCatalog.log
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %log_dest%>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catalog.sql;>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catexp7.sql;>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catblock.sql;>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catproc.sql;>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catoctk.sql;>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\owminst.plb;>>%file_dest%
echo connect SYSTEM/manager>>%file_dest%
echo @%ORACLE_HOME%sqlplus\admin\pupbld.sql;>>%file_dest%
echo connect SYSTEM/manager>>%file_dest%
echo set echo on>>%file_dest%
echo spool %ASSISTANTS%dbca\logs\sqlPlusHelp.log>>%file_dest%
echo @%ORACLE_HOME%sqlplus\admin\help\hlpbld.sql helpus.sql;>>%file_dest%
echo spool off>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM =======================================
REM ==  END OF MAKE CreateDBCatalog.SQL  ==
REM =======================================

REM ================================
REM ==  MAKE JServer.SQL          ==
REM ================================
SET file_dest=%CREATE_LOCATION%JServer.sql
SET log_dest=%CREATE_LOCATION%LOGS\JServer.log
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo @%ORACLE_HOME%javavm\install\initjvm.sql;>>%file_dest%
echo @%ORACLE_HOME%xdk\admin\initxml.sql;>>%file_dest%
echo @%ORACLE_HOME%xdk\admin\xmlja.sql;>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catjava.sql;>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM =======================================
REM ==  END OF MAKE JServer.SQL          ==
REM =======================================

REM ================================
REM ==  MAKE Ordinst.SQL          ==
REM ================================
SET file_dest=%CREATE_LOCATION%Ordinst.sql
SET log_dest=%CREATE_LOCATION%LOGS\Ordinst.log
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %log_dest%>>%file_dest%
echo @%ORACLE_HOME%ord\admin\ordinst.sql;>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM =======================================
REM ==  END OF MAKE Ordinst.SQL          ==
REM =======================================


REM ================================
REM ==  MAKE Intermedia.SQL       ==
REM ================================
SET file_dest=%CREATE_LOCATION%Intermedia.sql
SET log_dest=%CREATE_LOCATION%LOGS\Intermedia.log
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo @%ORACLE_HOME%ord\im\admin\iminst.sql;>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%


REM ======================================
REM ==  END OF MAKE Intermedia.SQL      ==
REM ======================================

REM ================================
REM ==  MAKE context.SQL          ==
REM ================================
SET file_dest=%CREATE_LOCATION%context.sql
SET log_dest=%CREATE_LOCATION%LOGS\Context.log
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo @%ORACLE_HOME%ctx\admin\dr0csys change_on_install DRSYS TEMP;>>%file_dest%
echo connect CTXSYS/change_on_install>>%file_dest%
echo @%ORACLE_HOME%ctx\admin\dr0inst @%ORACLE_HOME%bin\oractxx9.dll;>>%file_dest%
echo @%ORACLE_HOME%ctx\admin\defaults\dr0defin.sql ENGLISH;>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM ======================================
REM ==  END OF MAKE context.SQL         ==
REM ======================================

REM ================================
REM ==  MAKE XDBPROTOCOL.SQL      ==
REM ================================
SET file_dest=%CREATE_LOCATION%XDB_PROTOCOL.SQL
SET log_dest=%CREATE_LOCATION%LOGS\XDB_PROTOCOL.LOG
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catqm.sql change_on_install XDB TEMP;>>%file_dest%
echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\catxdbj.sql;>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM =======================================
REM ==  END OF MAKE MAKE XDBPROTOCOL.SQL ==
REM =======================================


REM ================================
REM ==  MAKE CWMLITE.SQL      ==
REM ================================
SET file_dest=%CREATE_LOCATION%CWMLITE.SQL
SET log_dest=%CREATE_LOCATION%LOGS\CWMLITE.LOG
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo @%ORACLE_HOME%olap\admin\olap.sql %DB%.%SERVER_NAME%;>>%file_dest%
echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo @%ORACLE_HOME%cwmlite\admin\oneinstl.sql CWMLITE TEMP;>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM ==============================
REM ==  END OF MAKE CWMLITE.SQL ==
REM ==============================

REM ================================
REM ==  MAKE POSTDBCREATE.SQL      ==
REM ================================
SET file_dest=%CREATE_LOCATION%postDBCreation.sql
SET log_dest=%CREATE_LOCATION%LOGS\postDBCreation.LOG
del %file_dest%

echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo @%ORACLE_HOME%rdbms\admin\utlrp.sql;>>%file_dest%
echo shutdown ;>>%file_dest%
echo startup mount pfile="%CREATE_LOCATION%init.ora";>>%file_dest%
echo alter database archivelog;>>%file_dest%
echo alter database open;>>%file_dest%
echo alter system archive log start;>>%file_dest%
echo shutdown ;>>%file_dest%
echo connect SYS/change_on_install as SYSDBA>>%file_dest%
echo set echo on>>%file_dest%
echo spool %LOG_DEST%>>%file_dest%
echo create spfile='%ADMIN_LOCATION%spfile\spfile%DB%.ora' FROM pfile='%CREATE_LOCATION%init.ora';>>%file_dest%
echo spool off>>%file_dest%
echo exit;>>%file_dest%

REM ===================================
REM ==  END OF MAKE POSTDBCREATE.SQL ==
REM ===================================

DEL %BAT_FILE%

ECHO IF NOT EXIST %CREATE_LOCATION%LOGS MD %CREATE_LOCATION%LOGS>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%bdump>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%cdump>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%create>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%pfile>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%spfile>>%BAT_FILE%
ECHO mkdir %ADMIN_LOCATION%udump>>%BAT_FILE%
ECHO mkdir %ARCHIVE_LOCATION%>>%BAT_FILE%
ECHO mkdir %DATA_LOCATION%>>%BAT_FILE%
ECHO set ORACLE_SID=%DB%>>%BAT_FILE%
ECHO %BINARY_LOCATION%oradim.exe -new  -sid %DB% -startmode m >>%BAT_FILE%
ECHO %BINARY_LOCATION%oradim.exe -edit  -sid %DB% -startmode a >>%BAT_FILE%
ECHO REM>>%BAT_FILE%
ECHO REM If the spfile location is changed, big trouble ensues.  JSH 1 Dec 2006>>%BAT_FILE%
ECHO REM>>%BAT_FILE%
ECHO %BINARY_LOCATION%orapwd.exe file=%ORACLE_HOME%database\PWD%DB%.ora PASSWORD=CHANGE_ON_INSTALL>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%Create_DB.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%CreateDBFiles.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%CreateDBCatalog.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%JServer.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%ordinst.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%interMedia.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%context.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%xdb_protocol.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%cwmlite.sql>>%BAT_FILE%
ECHO %BINARY_LOCATION%sqlplus /nolog @%CREATE_LOCATION%postDBCreation.sql>>%BAT_FILE%

This runs and creates a db successfully. You invoke the script with a parameter which is the SID of the db under construction. (I know the instructions are missing, but they're not essential for testing.) This makes a batch file, which one has to start manually, and that creates the db.

Once this has run (server side) I then need to tweak TNSNAMES.ORA to include the new connection. I am still trying to use the Net Configuration Assistant with a response file, but without success. Does anyone have a sample rsp file which can add an entry to TNS and the listener.ora files?

Regards

Tharg

Grinding away at things Oracular

 

[Thargy]

Gents,

in my previous post I didn't make it clear that server side I can connect by setting the SID and then connecting as sysdba.

However, I want the script to be as generic as possible, hence the requirement to auto insert entries into TNSNAMES and listener.ora, so that clients can see the newly minted db.

Regards

Tharg

Grinding away at things Oracular