-
Hi Friends,
I have a problem in DB Creation thru script.
We have installed oracle in NT environment with the default database. We want to create one more database. so first we created init.ora file. After that we have changed relevant parameters in init file. After setting ORACLE_SID to new sid and ORACLE_HOME as environment varibles. When we are trying to execute svrmgrl then it is saying tns : protocol adaptor error. Can any one suggest what may be the problem. And we also we modified the tnsnames and listner files.
Thanks in advance.
-
How are you creating database .. Have you used ORADIM utility?
Amol
-
db creation
Dear friend,
I running this script
create database VEN
controlfile reuse
datafile 'd:\ora81\oradata\ven\systemven.ora' size 10m
logfile 'd:\\ora81\oradata\ven\log1ven.ora' size 50k,
'd:\\ora81\oradata\ven\log2ven.ora' size 50k
maxlogmembers 2
This is to create a sample database. I am doing this thru svrmgrl prompt.
Thanks
-
Have you defined your ORACLE_SID in the command prompt?
set ORACLE_SID=VEN
svrmgrl and then execute again your database creation command.
Hope that helps
Angel
-
even you fix that error your script is not 100% correct
logfile 'd:\\ora81\oradata\ven\log1ven.ora' size 50k,
'd:\\ora81\oradata\ven\log2ven.ora' size 50k
these two has extra backslah \
how have you defined your enviroment variables? from ms-dos or from control panel?
-
-
Thank u friends,
It was solved like this.
I have registered the SID via
ORADIM -NEW -SID VEN
after this it has gone thru success full.
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
|