Here are some information that I found on the net about JavaOne 2010. Feel free to comment with additional resources. To start, Oracle posted some video highlights. If you have JavaOne login, you can view the full versions at On Demand site. If not, you can still see some of the contents here. Beyond that, […]
Read more "JavaOne 2010 Related Links"You think Hibernate is cool? Checkout what NetBeans 5.5 rc1 can do out-of-the-box. It can do O/R mapping, using bundled Hibernate, Top Link, KODO, or a persistence library of your choice. I am going to briefly describe high level steps on generating a web app from an existing Oracle database and generate simple JSF JSPs […]
Read more "Comments on generating a web app from database tables"I just discovered that NetBeans can allows a user to access databases to view, edit, and execute commands. It looks pretty cool for an IDE. If you prefer to use command line, use sqlplus or command line tool for the database. If you use Windows operating system and Oracle database, TOAD could be another option. […]
Read more "Access an Oracle database with NetBeans 5.5 beta2"groupadd -g 100 dba groupadd -g 101 oinstall useradd -u 101 -d /export/home/oracle -g oinstall -G dba -m -s /usr/bin/bash oracle passwd oracle cp /etc/system /etc/system.orig Add the following parameters in /etc/system set noexec_user_stack=1 set semsys:seminfo_semmni=100 set semsys:seminfo_semmns=1024 set semsys:seminfo_semmsl=256 set semsys:seminfo_semvmx=32767 set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 /usr/sbin/reboot su – oracle mkdir […]
Read more "Oracle 10g on Solaris 10 SPARC installation notes"Pre-condition: You must have Oracle database software installed and this note is for 10g. You will only need to create an instance if you don’t already have one or if you wish to create a new instance. Check what you already have using ps -ef |grep ora 1. Make a copy of the response file […]
Read more "How to create an instance of Oracle database using DBCA command line tool?"Oracle/PLSQL: ORA-00937 Error: “SELECT department, MIN (salary) as ‘Lowest salary’ FROM employees;”
Read more "Oracle error"CREATE PFILE [=’pfile_name’] FROM SPFILE [=’spfile_name’]; CREATE SPFILE [=’spfile_name’] FROM PFILE [=’pfile_name’];
Read more "Oracle tricks"Oracle 10g is Buggy! Out of box, 10g (10.1.0.2.0) ‘s /rdbms/admin/spcreate.sql is broken. It would throw the following error when I tried to install statspack: SQL> — Build the tables and synonyms SQL> connect perfstat/&&perfstat_password ERROR: ORA-12162: TNS:net service name is incorrectly specified I had to change the password and add in @ in the […]
Read more "Oracle notes"
Dave's Blogs
You must be logged in to post a comment.