 | |
becomes disconnected / Oracle9-Windows / ora-12560 / SP2-0640
comp.database.oracle comp.database.oracle
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
becomes disconnected / Oracle9-Windows / ora-12560 / SP2-0640 -
05-16-2005
, 03:17 AM
#2
| |||
| |||
|
|
Hello! conn bdj/bdj@hub92 works fine but conn bdj/bdj results in ora-12560 and i'll become disconnected. Can I change this behaviour? The real problem is, that I want to run scripts from rdbms\admin (spcreate.sql etc), but I got SP2-0640. But I think these problems are related. Greetings Bjørn |
try connecting again.
Let us know if it works.
#3
| |||
| |||
|
|
"Bjorn Jensen" <b.d.jen_removethissen (AT) gmxandthis (DOT) net> wrote in message news:4288570d$0$13714$ba624c82 (AT) nntp06 (DOT) dk.telia.net... Hello! conn bdj/bdj@hub92 works fine but conn bdj/bdj results in ora-12560 and i'll become disconnected. Can I change this behaviour? The real problem is, that I want to run scripts from rdbms\admin (spcreate.sql etc), but I got SP2-0640. But I think these problems are related. Greetings Bjørn Try setting your oracle environment first : set ORACLE_SID=hub92 and then try connecting again. Let us know if it works. |
#4
| |||
| |||
|
|
Hi! Thank you - it works! But why can't i write sqlplus "/ as sysdba" from the dos-commandprompt? I got 'insufficient privelegies'... Thaks for help! Bjørn |
a member of the ORA_DBA local group ?
#5
| |||
| |||
|
|
"Bjorn Jensen" <b.d.jen_removethissen (AT) gmxandthis (DOT) net> wrote in message news:4288f2d5$0$639$ba624c82 (AT) nntp02 (DOT) dk.telia.net... Hi! Thank you - it works! But why can't i write sqlplus "/ as sysdba" from the dos-commandprompt? I got 'insufficient privelegies'... Thaks for help! Bjørn This must have something to do with OS permissions ... is your Windows user a member of the ORA_DBA local group ? |
#6
| |||
| |||
|
|
yes... /Bjørn "Matthias Hoys" <idmwarpzone_NOSPAM_ (AT) yahoo (DOT) com> wrote in message news:4288f65c$0$26081$ba620e4c (AT) news (DOT) skynet.be... "Bjorn Jensen" <b.d.jen_removethissen (AT) gmxandthis (DOT) net> wrote in message news:4288f2d5$0$639$ba624c82 (AT) nntp02 (DOT) dk.telia.net... Hi! Thank you - it works! But why can't i write sqlplus "/ as sysdba" from the dos-commandprompt? I got 'insufficient privelegies'... Thaks for help! Bjørn This must have something to do with OS permissions ... is your Windows user a member of the ORA_DBA local group ? |
set ORACLE_SID=...
sqlplus /nolog
connect / as sysdba
?
Are you using a password file ? Is the connection local on the server or
remote from a client PC ?
#7
| |||
| |||
|
|
set ORACLE_SID=... sqlplus /nolog connect / as sysdba It doesn't work Are you using a password file ? Is the connection local on the server or remote from a client PC ? No, I'm not using passwordfile. |
Greetings
Bjørn
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.