Anyone know how to solve this problem when I connect to the database using sqlplus (sqlplus system/manager@abc)
error displayed sh: abc: not found. Why this error happen ?
So, I use another way to connect to database using sqlplus. I press <Enter> after sqlplus, Username : system@abc
password : manager and press <Enter>. Another error message appear - ORA-01017: invalid username/password; logon denied.
Why these could happen ? If the later way I key in without the alias (@abc) I can get connect to the database successfully. Why ?
Sorry for asking a lot of questions. But I feel this is good to know especially as a DBA.
try connecting with svrmgrl with internal.
try select status from v$instance;
if you get a message saying "ORACLE is not available"
if you do not succeed you have a problem with your environment (either SGA or operating system).