| probs loggin in [message #50977] |
Wed, 17 April 2002 06:55  |
Wolf
Messages: 7
Registered: February 2002
|
Junior Member |
|
|
Hi,
seems to be in the wrong board first... ;)
My configuration: Win2ksp2 & oracle 8.1.6.0.0, local admin rights, member of ORA_DBA, Ora-Server new installed with sample DB (running)
Iīm trying to create a new Database (instance), ok so far.
By hand everything is ok, connect, create, grant etc...
When I try to make it with a script, it fails when I try to connect as internal/passwd (again, by hand itīs ok!) with "ORA-01031 - insufficient privilegs".
Calls in a batchjob is:
/path/oradim -new -sid testdb -startmode manual -pfile /path/init.ora
/path/svrmgrl @dbrun.sql
the first lines in the script are:
spool D:Programmeoracle81admintest1dbcreatecreatedb
set echo on
connect internal/oracle
Result is:
The service testdb is there and running.
but:
Echo ON
SVRMGR> connect internal/oracle as SYSDBA
ORA-01031: insufficient privileges
Still again, by hand itīs ok...
Does anyone have any ideas?
I try to more specify the effects (ore drescribe it more easy (?)):
Dos-Box (cmd), then
sqlplus
username: internal
pwd: mypwd
it fails with ORA 01031
Other test:
Dos-Box (cmd)
sqlplus
username: internal/mypwd
that works! Iīm connected. But I dont know why... :-(
In my script I use the "connect internal/mypwd" with or without the "as Sysdba"-Statement... nothing changes.
Ideas, why my script isnīt working and why I can connenct, when I use name/pwd, but not, when I use Name, then pdw?
Wolf
|
|
|
|
| Re: probs loggin in [message #50982 is a reply to message #50977] |
Wed, 17 April 2002 16:59  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
You should set ORACLE_SID when using difference instance/database as below
set ORACLE_SID=sidname
Hope this is helping ..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
