 | | | Oracle List | | Ryan
You might try logging in with sqlplus '/ as sysdba '.
I agree with the advice to use kill -9.
If you do get in with sqlplus you 're probably going to do a shutdown abort.
Dennis Williams
<div >RDo you really want to rename the listener.ora file or just rename the
actual listener or the listener.log file? I think you can rename
listener.ora w/o bouncing the listener because I believe it 's I have a strange problem 10.x clients intermittently break the
connection with Oracle 9i (9.2.0.8). The error
I get is 3113 but there is no accompanying error on the 9.2 server side.
I am unable to
Folks
Qs What is the Cause of "gc buffer busy " wait? Is it always due to a DML
i.e. "INSERT / UPDATE " or can it be due to a "SELECT " too?
NOTE - IDX_LOGIN_TABLE (on session_id) IDX_LOGIN_VALI have a few thoughts
First I don 't believe that wanting to know better how the Oracle software
behaves (distinct from works) is at all a bad thing for either a DBA or a
Developer to wish for themseHi Vincent
have a look at http //download-uk.oracle.com/docs/cd/B16240_01/doc/em.102/b40002/configs.htm#CHDJGDHE
and
http //download-uk.oracle.com/docs/cd/B16240_01/doc/em.102/b40002/security2.htm#1-800-633-0930 might work - wait for an operator to dig up a body. If you
have 5 digit extension in your TAR try and enter that.
On 3/13/07 ryan_gaffuri@(protected) <ryan_gaffuri@(protected) > wrote Hello -
Just ask the System Administrator to add the oracle user to the
cron.allow file and then make sure to set up the oracle environment in
the scripts as cron does not execute the profile for tThis is Oracle 10.2.0.2 on HPUX Itanium 11.23.
When I try to run the create database script created by dbca I get the
above error message.
Any ideas?
Thanks
Peter Schauss
--
http //www.freelists.oAn inexpensive way to start would be to buy the book _MySQL_ by Paul DuBois.
We recently sent a guy to the "MySQL for DBA 's " class and he pronounced it
pretty much a waste of time.
In my experienceSQL > select user from dual
USER
Run the command "Show parameter log_archive " in a SQLPLUS session in your
primary database.
See whether any log_archive_Dest set to Standby.
If set to standby run
Alter system set log_archive_dest_ <nSorry not enough coffee this morning and I 'm still not adjusted to the new DST!
The 3rd section (table full scans) should read
Tables are often read with multi block reads but not always.
------vnr1995 wrote
> Hi
>
> I ran into problems while cloning a db using rman. Auxiliary(AUXI)
> and target(MERLIN) and rman executables are of version 10.2.0.2.0
> and on solaris 10 sparc 64.
>
> IHave you checked out extproc_perl?
http //www.smashing.org/extproc_perl/
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates Inc.
--
http //www.freelists.org/webpage/oracle-l
The term "sequential read " means blocking single-block reads. Since they
are blocking they occur sequentially--thus the word sequential.
-----Original Message-----
From oracle-l-bounce@(protected)A. Coskan Gundogar wrote
We are migrating a database to oracle. We have a big problem that developers used the tables with DBA.XXXX aliases in the code. As you know DBA is a special word and cant bI believe it doesn 't accept hotmail yahoo accounts and others like that.
That 's why I stopped subscribing couldn 't understand the reasoning though.
--
http //www.freelists.org/webpage/oracle-l
have you run the @?/rdbms/admin/catpatch.sql script ?
_____
??? oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)] ?
? dba1 mcc
???? 2007?3?12? 23 43
??? oracle-l@(protected)Greetings
I have installed asmlib on some of our Linux RHEL3 RAC clusters running
10gR1. I see a /dev/oracleasm in which there is one or more empty plain
files
$ cd /dev/oracleasm
$ ls -lR
.
totalGovindan
I don 't do well with timezone functions myself .. but here is a stab at your
question
ORA92 > select sessiontimezone from dual
SESSIONTIMEZONE
There is a Note on MetaLink about that.
The file name must conform to the standard or the password
file is not used.
Strange that no errors are thrown until you try to login.
On 3/12/07 vnr1995 Hi List
I need to update large table sub_svc_parm ( over billion rows). This
is PL/SQL block that does it
I want to rewrite so it is executed as single SQL update statement.
Any suggestions ?
DECHi List
I 'm trying to figure out a way to alter the optimizer_mode parameter to
first_rows for another user 's session - is there any way to do this
other than a logon trigger? I know about
dbms_syYou can also run
select comp_name version status from dba_registry
COMP_NAME VERSION STATUS
What are the results of running these queries?
select * from dual
select * from x$dual
On 3/12/07 Bala <oratips@(protected) > wrote
>
> 1) I am getting ORA-06553 PLS-213 package STANDARD not Hi
When we try to start Listeners from OEM OS command
We have a simple command that seems to fail when Running an OS script from
OEM 10gR2.
$ORACLE_HOME/bin/lsnrctl start ${DB}
This works fr
We have 9.2.0.6 running on AIX 5.2 and the alert log date/time is
correct. No patch applied to Oracle however we did patch the OS for
DST.
-- Mark D Powell --
Phone (313) 592-5148
-----OriginaGuy
When I read this I thought of you.
The New Pope
A high school history teacher was discussing the funeral of
the Pope with his class. One student asked how they chose
the new Pope.
The teaOn 03/12/2007 07 52 43 AM John Dunn wrote
> We currently load large amounts of data into a table using sqlldr which
> is run from a unix script initiated from a java stored procedure.
> The applicat |
|
|
