學習灌Oracle的第一天

連sqlplus也不會用...

<引用>
Before you attempt to use SQL*Plus to connect locally to an Oracle instance, you must ensure that environment variables are set properly. When multiple database instances exist on one server, or when an Automatic Storage Management (ASM) instance exists on the same server as one or more database instances, the environment variables determine which instance SQL*Plus connects to. (This is also true when there is only one Oracle instance on a server.)

根據以上這段話的意思是，就算只有一個instance還是要設參數，所以之前傻傻的一直用sqlplus連db都連不上就是這個原因。

set oracle_sid=agile9
sqlplus sys/oracle as sysdba

這樣才能成功的連進db，要不然都只會一直出現error