Installation:
After download package, we can start install package:
- $ sudo dpkg -i oracle-xe-universal_10.2.0.1-1.1_i386.deb
Next we execute "after installation" configuration. We can keep parameters that are as default in configuration process, except "user password" and maybe number of port for web manager (8080 replace by for example 8180):
- $ sudo /etc/init.d/oracle-xe configure
Default username is:
- system
Oracle web manager:
Oracle web manager is running on "localhost" address:Oracle SQL Developer:
Quote: "Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database." This tool is available on Oracle home page, but if you want to download, you must register (horror). Another solution is to find this package on "One-click hosting" (for example: sqldeveloper-3.2.20.09.87-no-jre.zip).
After download and unpack, we must change file mode:
- $ chmod 755 /sqldeveloper/sqldeveloper.sh
And then we can run tool. For first start we must setting path to JVM (in my case: JAVA_HOME=/usr/lib/jvm/java-6-sun):
- $ /sqldeveloper/sqldeveloper.sh
SQLplus:
Oracle command-line interface "sqlplus" is good hiding. The file path is following in my installation:
- /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/runsqlplus.sh
SQL commands:
And finally, several examples of SQL commands (sqlplus):
login:
- SQL> connect system/oracle
- SQL> select * from all_users;
- SQL> select * from dict;
- SQL > @/oracle/scripts/script.sql
No comments:
Post a Comment