linux登录 oracle,Oracle本地和远程登录（linux）

在远程连接Oracle:

sh-3.1$ telnet 172.16.0.188

Trying 172.16.0.188...

Connected to 172.16.0.188.

Escape character is '^]'.

BOSSCarnival 1.0 \n \l

boss login: woss

Password:

Last login: Tue May 10 14:43:17 2011 from 172.16.9.240 on

pts/21

Linux boss 2.6.18-5-686 #1 SMP Mon Dec 24 16:41:07 UTC 2007

i686

====================================================

= =

= Brighten your way and raise you up

! =

= =

= Briup Technology Inc

. =

====================================================

....................................................

woss@boss:~$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 10 14:43:48

2011

Copyright (c) 1982, 2005, Oracle. All rights

reserved.

Enter user-name: briup

Enter password:

Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 -

Production

SQL>

在本地连接Oracle:

sh-3.1$ su

Password:

briup:/home/training# su - oracle

oracle@briup:~$ sqlplus "/as

sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 10 14:22:10

2011

Copyright (c) 1982, 2005, Oracle. All rights

reserved.

Connected to an idle instance.

SQL> start up

SP2-0310: unable to open file "up.sql"

SQL> startup

ORACLE instance started.

Total System Global Area 247463936 bytes

Fixed

Size 1258244 bytes

Variable

Size 79695100 bytes

Database

Buffers 163577856 bytes

Redo

Buffers 2932736 bytes

Database mounted.

Database opened.

SQL> conn briup/briup

Connected.

varchar 与 varchar2 的区别：

Oracle自己愿意这么规定，谁也没办法。