Hi.
I want to start Xe using sql comand lines and I can´t do it. I followed the manual and when i tried
sqlplus / as sysdba I got
Uso: SQLPLUS [ [<opþÒo>] [<logon>] [<start>] ]
onde <opþÒo> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<URI>|<nome do arquivo>[.<ext>] [<parÔmetro> ...]
"-H" exibe o banner da versÒo do SQL*Plus e a sintaxe de uso
"-V" exibe o banner da versÒo do SQL*Plus
"-L" tenta efetuar logon apenas uma vez
"-M <o>" utiliza opþ§es de marcaþÒo HTML <o>
"-R <n>" utiliza modo restrito <n>
"-S" utiliza modo silencioso
Then I tried sqlplus /nolog
C:\>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Ter Abr 10 11:31:37 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> startup
ORA-12560: TTNS:protocol adapter error
I have both 9i and XE in the same computer, then I tried start sqlplus (10.2 version)
SQL*Plus: Release 10.2.0.1.0 - Production on Ter Abr 10 11:34:34 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> startup
ORA-12560: TNS:protocol adapter error
SQL>
SQL> conn user/pass@xe
ERROR:
ORA-12541: TNS:nÒo hß listener
I started the listenr manually, then tried again
SQL> conn user/pass@xe
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I think that Oracle was "mismatching" with 9i and XE, then how can I fix it ?.
Thanks
Richard