Oracle errors
A website that give explanation of ORA messages
Tech on the Net
Oracle upgrade from 10.2.0.1 to 10.2.0.2
Follows this and in a couple of hours you will have a working db again
Installing JDeveloper on OpenSolaris
Just installed Opensolaris 2008.12 on a spare box. As part of any computer build I end up putting JDeveloper on it. Download it and double click on the jar to start the installer. One problem with the install is it can't create the directories so when it goes to start installing you get a error. "/home/XXXXX/Oracle/Middleware has insufficient space", the fix is to create that directory before you start installing.
The oracle that generated my graph
select count(weblogentry.categoryid) as "Number of Entries", weblogcategory.name as "category",
count(weblogentry.id) as "Total"
from weblogentry JOIN weblogcategory
on weblogentry.categoryid = weblogcategory.id
group by weblogcategory.name
FRM-40740
I had a error FRM-40740 when I added a alert to a form I was working on.
The alert was called UPDATE_RECORD and was set to the update_record
button. After changing the alert and program procedure to
UPDATE_STUDENT the error went away.
Getting Oracle 10xe to run on SuSe 10 x86_64
have bought a Pentium D and installed the SuSe 10 x86_64. Since I
am studing Oracle reports, installing Oracle 10 express edition sounded
like a good idea. Since Oracle has been kind enough to post a RPM to
download I figured it couldn't be to hard. Opps there I go thinking
again. The 1st error you get is about libaio.so.1 not installed. Fine
easy to fix, use YAST and install both the libaio and libaio32 with the
development libraries for both. To install the oracle RPM don't use
YAST, you have to do it via command line because you have to swtich to
a 32bit bash for the install. From the command promot type "linux32
bash" then you can do rpm -ivh.
here is the output of my install
skipjack@linux:~> linux32 bash
skipjack@linux:~> sudo rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Password:
Preparing... ########################################### [100%]
1:oracle-xe-univ ########################################### [100%]
Executing Post-install steps...
oracle-xe 0:off 1:off 2:off 3: on 4:off 5: on 6:off
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.
skipjack@linux:~> su
Password:
linux:/home/skipjack # /etc/init.d/oracle-xe configure
Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press to accept the defaults.
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:80 80
Specify a port that will be used for the database listener [1521]:1521
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:n
Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
ORA-12514
ORA-12514:
TNS:listener does not currently know of service requested in connect descriptor
Cause: The listener received a request to establish a connection to a
database or other service. The connect descriptor received by the
listener specified a service name for a service (usually a database
service) that either has not yet dynamically registered with the
listener or has not been statically configured for the listener. This
may be a temporary condition such as after the listener has started,
but before the database instance has registered with the listener.
Action: - Wait a moment and try to connect a second time.- Check which
services are currently known by the listener by executing: lsnrctl
services - Check that the SERVICE_NAME parameter in the connect
descriptor of the net service name used specifies a service known by
the listener.- If an easy connect naming connect identifier was used,
check that the service name specified is a service known by the
listener.- Check for an event in the listener.log file.
One thing to try if using Oracle 10g XE in the database field use "HOST"/"SERVICE_NAME"
I beat myself for 2 weeks trying to sort that out after a upgrade from 9i
Oracle 10g backup batching
The format of the data to be entered in the Username fields on the
Credentials pages is "Domain\Username". This setting is only accepted
when the user has the "Log on as a batch job" right assigned.
Select the "Administrative Tools" control panel. Then "Local Security
Policy". Expand "Local Policies", select "User Rights Assignment".
Finally add the User to "Logon as a Batch Job" local security setting.
With thanks to Rachel from Oracle Support.
Useful power preferences for JDeveloper and SQL Developer
stolen from DuffBlog
[Read More]
