oracle3总结

1.安装virtualbox

设置网卡为"桥接模式"
启动方式:"光驱启动"　排在第一位



ORACLE_BASE
ORACLE_HOME

OLTP

OLAP

2.安装win7_86_64


https://10.10.51.72:1158/em




#配置监听
lsnrctl status ---查看监听状态
lsnrctl stop/start   ---关闭监听/启动监听

#测试网络连接

tnsping orcl72   ---orcl72为网络连接符

#通过sqlplus连接oracle数据库


sqlplus username/passwd@connect_identifier [as sysdba]

#scott用户解锁

sqlplus sys/oracle@orcl72 as sysdba
alter user scott account unlock;
alter user scott identified by tiger;
grant connect,resource,unlimited tablespace to scott;

//安装ssh服务
tech@tech:~$ sudo apt-get install ssh

//安装vim编辑器
tianxiaoyan@tianxiaoyan:~$ sudo apt-get install vim


//安装sqldeveloper
unzip sqldeveloper-4.0.1.14.48-no-jre.zip


//查看普通文件
ls -lh

//查看隐藏文件
ls -lha


tianxiaoyan@tianxiaoyan:~/Desktop$ cd sqldeveloper/
tianxiaoyan@tianxiaoyan:~/Desktop/sqldeveloper$ ls
configuration  equinox   javavm  jviews    readme.html  sqldeveloper      svnkit
dataminer      external  jdbc    modules   sleepycat    sqldeveloper.exe  view-source-paths.lis
dropins        icon.png  jdev    netbeans  sqlcli       sqldeveloper.sh
dvt            ide       jlib    rdbms     sqlcli.bat   sqlj
tianxiaoyan@tianxiaoyan:~/Desktop/sqldeveloper$ chmod +x sqldeveloper.sh


vim /home/tianxiaoyan/.sqldeveloper/4.0.0/product.conf
SetJavaHome /usr/lib/jvm/java-7-openjdk-amd64