Very Odd, Sqlplus Is Not Working
I have two Oracle home (8.1.7, 9.2.0) running on the windows 2000 server. when I set the environment and try to create the database for the 9i version. When I issue:
SQL> connect sys/blah as sysdba
I got the ORA-03113, end of file communication
but when I used
SVRMGRL> connect sys/blah as sysdba
I did set the environment:
what's going on??? this is odd, I never have this problem before.
Last edited by learning_bee; 01-05-2004 at 12:12 PM.
Looks like your ORACLE_HOME is pointing to 8.1.7
Set the ORACLE_HOME to 9.2.0 and try again.
Try set TNS_ADMIN to Ora92 network\admin (for example set TNS_ADMIN=C:\Ora92\network\admin) and start SQL Plus from Ora92\bin
tns_admin has got nothing to do with starting this database
he did set ORACLE_SID, therefore not going over the network using net8
read the concepts guide.
As the other guy said it looks like your environemtn is a bit funny as svrmgrl doesnt exist in 9i, so give us the output of "set"
Last edited by davey23uk; 01-05-2004 at 04:05 PM.
You will have to either use the Oracle Home Selector or write a batch file that changes your PATH environment variable to the correct home...
as I said, I have done this about over 10 times and I never experience this problem. Any way, I did change the Oracle home to 9i and I did set ORACLE_SID= test and when I type set ORACLE, it had the right environment there. the problem still existed and it's only work on SVRMGRL and if I changed the primary back to 8i, it worked with SQLPLUS and SVRMGRL.
how can it work on svrmgrl, svrmgrl doesnt work on 9i - it doesnt exist it isnt there
true, SVRMGRL doesn't exist on 9i; however, SVRMGRL will work b/c 8i still exist on the box. anyway, I found the problem comment out SQL.AUTHENTICATION_services=NTS and every thing is ok.
You're missing a fundamental point. You shouldn't be using svrmgrl to startup and shutdown your 9i database.
Can you post your environment variables? Use the following...
c:\> set > c:\temp\env.txt
and then paste the contents into a post.
Click Here to Expand Forum to Full Width