|
-
hi,
check to see that sqlnet.ora has entries like :
///////////////////////////////////////////
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)
/////////////////////////////////////////////
then you should delete any instance created by giving this command
oradim -DELETE -SID
also delete any files created by the previous instnace
then make sure all the folders are there which the scripts have as they r not made when the scripts r generated.
-------------------
create now as follows..
open command window
set ORACLE_SID=%YourSID%
oradim -new -sid -startmode m -pfile
oradim -edit -sid -startmode a
A typical setup will have these scripts
sqlplus /nolog @c:\TESTDIR\CreateDB.sql
sqlplus /nolog @c:\TESTDIR\CreateDBFiles.sql
sqlplus /nolog @c:\TESTDIR\CreateDBCatalog.sql
sqlplus /nolog @c:\TESTDIR\JServer.sql
sqlplus /nolog @c:\TESTDIR\ordinst.sql
sqlplus /nolog @c:\TESTDIR\interMedia.sql
sqlplus /nolog @c:\TESTDIR\context.sql
sqlplus /nolog @c:\TESTDIR\ordinst.sql
sqlplus /nolog @c:\TESTDIR\spatial.sql
sqlplus /nolog @c:\TESTDIR\ultraSearch.sql
sqlplus /nolog @c:\TESTDIR\cwmlite.sql
sqlplus /nolog @c:\TESTDIR\demoSchemas.sql
sqlplus /nolog @c:\TESTDIR\postDBCreation.sql
let me know any problem comes...
while running the first file if it gives error the stop the service which you just created and restart the service and again set the oracle_sid in the window.
if error comes you have to create it manually...
i think you have not created password file so see the alert file and make a password file through orapwd in oracle_home/database/ directory..
saurabh
[Edited by saurabhg29 on 02-23-2002 at 08:11 PM]
Saurabh Garg
OCP 9i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|