Oracle user group
I just installed Oracle on a Red Hat server per tutorial http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html#rhel4 .. From the 'oracle' unix user, I can use the database just fine, but I can't start sqlplus from my unix account: bash-3.00$ sqlplus sqlplus: error while loading shared librarie... 7 May 2007 18:30
what does dbms_stat.gather_database_stats_job_proc do?
Dear Group, I just upgraded my database from 9i to 10.2.0.3. Still trying to figure out whether I should remove my daily analyze script and rely on Oracle 10g's default GATHER_STATS_JOB. From select PROGRAM_ACTION from dba_scheduler_programs where PROGRAM_NAME = 'GATHER_STATS_PROG'; PROGRAM_ACTION ... 12 Apr 2007 15:31
Enterprise Grid Control - Agent Configuration Assistant
When adding a system to grid control, i entered all the details ect. It completed the install (and appears in grid control). However when it gets to the end of the install, it fails the Agent Configuration Assistant. Output generated from configuration assistant "Agent Configuration Assistant": Command = orac... 12 Apr 2007 11:20
Editing / Viewing a .fmx file
Hi!, Can you please tell me is there any way to edit or see the contents of a .fmx file without corrupting it. I have lost my related .fmb file so I need to alter the .fmx file. I am using Oracle 9i as backend and Developer 2000 as front end. Thanks ... 4 Apr 2007 10:44
DBConsole not working properly.
On Feb 15, 1:52 pm, Frank van Bortel <frank.van.bor...(a)gmail.com> wrote: shob...(a)gmail.com schreef:> Hi.All, I am usingWindowsXP service pack 2 andOracle10g. I am unable to useDBConsoledue to this error -- Could notstartthe OracleDBConsole service on Local Compuer. Error 1053:The service did ... 23 Mar 2007 17:16
ORA-00603: "ORACLE server session terminated by fatal error"
on this command: exec DBMS_STATS.GATHER_DATABASE_STATS(estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, block_sample => TRUE, method_opt => 'FOR ALL COLUMNS SIZE', cascade => TRUE, options => 'GATHER'); I am getting this error: ORA-00603: "ORACLE server session terminated by fatal error" I don't understan... 20 Mar 2007 22:18
I see ORA-01555. Can we find table name from this output. ORA-01555 caused by SQL statement below (Query Duration=0 sec, SCN: 0x0000.00676aeb): Wed Mar 14 14:50:31 2007 select lxOid,lxVal from lxString_1be8cbb6 where lxOid in (:va,:vb,:vc,:vd,:ve,:vf,:vg,:vh,:vi,:vj,:vk,:vl,:vm,:vn,:vo,:vp,:vq,:vr,:vs,:vt,:vu,:... 14 Mar 2007 09:35
ora-01461 when importing a 10.2 dump
Hello, I'm running into a ora-01461 error when I try to import a dump file that I have received from a customer. I have read the notes on metalink regarding possible workarounds for this issue and I have tried all that I can apply. The table in question has two VARCHAR2(4000 BYTE) columns. What I have t... 13 Mar 2007 14:50
Oracle create duplicate user account
I am looking for the SQL syntax to create an additional database user that is a copy of an existing user. So my new user will have a different username and password, but same permissions and access as another existing user. I am looking for the SQL syntax, not how to do it through a GUI tool. Thanks! ... 14 Mar 2007 10:07
10gAS Apache HTTP SSL connection on port 443
Hi everybody, I've followed metalink notes to switch SSL port to 443. The problem is that oracle support told me to change the permission of Apache listener controller in this way : chmod 6750 /oracle/product/10gAS/Apache/Apache/bin/.apachectl chown root /oracle/product/10gAS/Apache/Apache/bin/.apachectl ... 24 Feb 2007 18:51