Oracle12c学习(二)---Linux下SQL Developer 安装

本文详细介绍了在Linux环境下安装Oracle SQLDeveloper的过程,包括从官网下载最新版本、配置JDK环境、解决找不到java的问题及运行SQLDeveloper的方法。

        最近已经稍微了解了Oracle的体系结构,不过还是没怎么实际的操作过体系结构中介绍的一些功能,还是需要些时间进行深入地学习和实际操作。为了提高学习效率,安装了SQL Developer工具进行SQL的操作。下面介绍下我在Linux下安装的过程。

        首先,去官网下载,目前版本是4.1.2,下载地址是:http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html,也可以从我提供的网盘地址进行下载http://yunpan.cn/c3FmD5DwtxCSF 访问密码 1f64。下载之后就是进行安装,我的系统是Red Hat Enterprise 7 ,在查找依赖项的时候包都是存在的,其它Linux系统就不知道是不是有问题。安装完成之后左上角会出现

        

这个图标,在点机时如果没有反应,就需要配置JDK环境,用命令进入到SQL Developer的安装目录

cd /opt/sqldeveloper
然后执行

./sqldeveloper.sh
它会提示让你输入JDK的完整路径(JDK下载地址是 http://www.java.com/en/download/manual.jsp)

这样基本上就是可以运行SQL Developer了,但是我在输入JDK的完整路径之后,它说找不到java,而且后面有提示说可能我的JDK是符合要求的,只需要修改

/opt/sqldeveloper/sqldeveloper/bin下的sqldeveloper.conf,增加以下内容即可:

SetSkipJ2SDKCheck true
可能是我的JDK版本太高。

最后就可以运行SQL Developer了








Oracle SQL Developer, v1.5.0.54.40 Release Notes 完整版下载:http://www.oracle.com/technology/global/cn/software/products/sql/index.html 1. Known Issues 1.1 General - Print prints only one page that is a truncation of the current tab. - Can't invoke SQL*Plus on Windows 2003. - The menu item, and right-click off a Connection node, for invoking SQL*Plus does not work with connections whose passwords are not persisted. 1.2 Connections - Cannot connect to remote database as OPS$ account. 1.3 Browse - If connected as sys with sysdba role, Types node displays built in data-types (e.g. BLOB, DATE, DECIMAL, etc.) If clicked on, will only see "create or replace". 1.4 Creating and Modifying Objects - Editing Triggers - If you have comments before the 'BEGIN' they will be lost if you edit. You will see when you click edit that they will not be there. To preserve them, they need to be below the BEGIN or you will need to edit via the SQL Worksheet. 1.5 Table > Data - Tables > Your_Table > Data - PageUp and PageDown buttons not working correctly if cursor is in the rownum column. 1.6 Export - Cannot export if result set contains duplicate column names. 2. Workarounds 2.1 To disable Code Insight Run SQL Developer from a command line using the following statement: Windows : sqldeveloper -J-Dsdev.insight=false Linux or Mac: Run sh sqldeveloper -J-Dsdev.insight=false or edit sqldeveloper.conf and add "AddVMOption -J-Dsdev.insight=false" 2.2 If DDL tab is null for all objects in a Connection Your dbms_metadata might be loaded incorrectly. If this statement fails when executed in a SQL Worksheet against the Connection select dbms_metadata.get_ddl('TABLE',table_name , user ) from user_tables; You need to reload $ORACLE_HOME/rdbms/admin/catmeta.sql 2.3 If Snippets are not accessible You may have not done a clean install. SQL Developer needs to be installed into a clean directory, not over a previous release. 3. Accessibility Issues The following is a li
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值