8.1.7 on Dell W2000 server.
When I try to login via sqlplus I get this:
ORA-01034 Oracle not available
ORA-27101 shared memory realm doesn't exist
Then I get:
Login:
Password:
And this error:
ORA-12560 TNS: protocol adapter error.
Any ideas as to what the problem is?
Your
Title: RE: Parallel Server
We are using OPS quite intensively here. Not necessarily for the correct reasons.
OPS certainly assists in maintaining uptime under a lot of circumstances. It is excellent for spreading workload between nodes/instances but you still have to design access to point to
Its just as bad on HPUX 11 for Oracle 8.1.7.2
--S
--- ARUN K C [EMAIL PROTECTED] wrote:
I was mentioning this on Sun 2.6 os
From: Larry Elkins [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: RE: buffer busy wait latch
We are using OEM currently on our Oracle environments. However, we have
about 100 Sybase servers and about 10 Microsoft SQL Server servers in
addition to the 20 or so Oracle instances we have. There are only 6 of us
supporting all these environments, and not everybody is knowledgeable in all
John,
Here is the update from Jonathan Gennick ...
http://oracle.oreilly.com/news/openworld_day3_1201.html
Best Regards,
K Gopalakrishnan
-Original Message-
Sent: Wednesday, December 05, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Dear all,
I had promised a few people on
I hear you. Some one came up with the idea that 30+
HPUX 10.20, Oracle 7.3.3 systems could be updated to
HPUX 11.x, Oracle 8.1.7 in less than 36 hours, with
only 2 dba's and 2 sysadms, remotely.
I shudder to think of the psychoactive compound
dosages that led to this conclusion. Oh well, I've
Hi All,
client 8.1.6 (NT)
Server 9.0.1 (W2K)
I'm trying to start/stop the instance remotely and am not succeding.
First it complains about obsolete parameters
JOB_QUEUE_INTERVAL MTS_DISPATCHERS, but they should not be there since
they are not in the pfile, nor the spfile (both on server)
Embarcadero products?
-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L
We are using OEM currently on our Oracle environments. However, we have
about 100 Sybase servers and about 10 Microsoft SQL Server servers in
addition to the 20
Title: RE: Parallel Server
Anyone
using NCR/Teradata for Data Warehousing out there?
Hello all,
I know this has come across many times now, and I thought I had it saved
somewhere - you know how that goes...
I need to query a table to find all duplicate rows based on a given column.
Don't feel like re-inventing the wheel...
Thanks in advance,
Jim
select column1, count(*)
from my_table
group by column1
having count(*) 1
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Ken
The database is not up. The NT services are not running.
To start them, from GUI go to Start|Control Panel|Administrative
Tools|Services, find the Oracle service and start it. Check the service to
be sure it is Auto Start enabled.
If you cannot get to the machine, telnet to the box and,
List,
Received this the the SearchDatabase org today. I thought some of you might find it
usefull.
ROR mª¿ªm
ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja
Here's a quick tip: The installation of Oracle8i on a Pentium 4
computer will exit without any notice. The reason for this is that
the
Jim,
Oops! Right after I sent this, I saw that you asked to find, not delete,
duplicates.
Sorry, I've spent the last two days de-duping a bunch of tables, so I've got
deletion on the brain.
How about:
Select SomeColumn
From MyTable
Where MyColumn In
(
Select MyColumn
From My Table
Is anyone using the LOG_ARCHIVE_DUPLEX_DEST parameter? Any problems with it?
We are on Oracle 8.1.6 on Compaq Tru64. On our ERP 150-gig. database, we are
currently doing a cold backup weekly. This means that we are very dependent
on archive logs.
- Recovery time isn't a big concern. In the
It's not an Oracle vs Access problem, it's a UNIX vs Windows problem. UNIX
is case sensitive. Oracle is also when you are talking about literal
strings (as well it should be if you're talking about literals). Vendor
doesn't know how to check for different cases and does shoddy work.
Actually, Oracle uses OPS internally on their e-mail system. For that
reason (Larry likes his mail fresh every morning) the OPS gets patches and
bug fixes with a very high priority. I used to have to install them.
Oracle runs it on HP-UX HA (High Availability). It's expensive but it
performs
Jim,
An option that handles multiple duplicates is:
Delete
From MyTable
Where (MyColumn,RowID) In
(
Select MyColumn,RowID
From MyTable
Minus
Select MyColumn,Min(RowID)
From MyTable
Group By MyColumn
);
You could use Max(RowID) as well, depending on your needs.
Jack
I'm not sure if I'm bragging or complaining, but I've never setup
or supported online backups for Oracle. I'm being directed to
implement online backups for a V7.3.4.5 instance. A search of
OTN reveals that Oracle no longer seems to have any V7 documents
available anymore. :-(
Since this DB is
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Informal survey: Datawarehousing.
Limiting Assumption: A necessary and sufficient condition for defining
something
to be a datawarehouse is the amount of data
to be stored.
Question/Poll: Given the above ridiculous constraint, at/above what size
can
Srinivas -
- I assume that you have the Oracle Magazine articles. If not, they
are available on-line.
- I'm confused (easily done). You say that you are tuning SQL
statements that statspack has identified and you want more information on
statspack report interpretation. To me
Ross - I think if you ask a data warehousing list such as
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] you'll find some contacts.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 06, 2001 2:15 PM
To: Multiple recipients of list
if you duplex mandatory and one server destination fails..is fixed...the
time lag for the db to become aware of the now-available second mandatory
location can be lengthy.
I have witnessed a test where it took 11 Minutes.
that's a lng time, when you are waiting for the db to figure out
Dennis,
We use
log_archive_dest_1
log_archive_dest_2
sending a copy of each archived redo log to our Standby database
(log_archive_dest_2).
log_archive_dest_2 is used with the OPTIONAL parameter, since we don't want
to stop archiving if the Standby is down or there's some problem with the
On Wed, Dec 05, 2001 at 03:00:19PM -0800, MacGregor, Ian A. wrote:
How well does MySQL scale.
This well: |---|
:)
How does it handle parallel direct inserts?
It doesn't. But then it's faster than Oracle to start with.
Oracle will _always_ be able to beat MySQL at the top end.
But
Ron, does this affect 9i?
Dave
Ron Rogers [EMAIL PROTECTED] 12/07/01 04:28am
List,
Received this the the SearchDatabase org today. I thought some of you might find it
usefull.
ROR mª¿ªm
ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja
Here's a quick tip: The installation of Oracle8i on a
Title: Password Changes
When you alter a user's password, what table does it update?
I need to 'restore' a password for a user back to what it was before I changed it, but do not know what it was.
Any ideas?? Can this be done?
Thanks,
Laura
Charlie, check out
alter tablespace begin backup.
thats has not changed since version 7, so even the 9i docs will cover it
and with 9i docs, there is a whole section on user managed backups.
joe
Charlie Mengler wrote:
I'm not sure if I'm bragging or complaining, but I've never setup
or
thanks all who answered.
greetings
DC
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 06, 2001 3:10
AM
Subject: Re: Off Topic: Australian
Visa
Another site for employment
opportunities is
Ken,
You probably could use a DBA for support in your current project. Hasn't
the company you're working with provided one? In any case, the error
you're getting could be result of one of several things - it's W2K. First
- generally the message shared memory realm not available means the SID
Hi,
We are creating database using DBCA , but it only allows us to change the
location of datafile.
We need to chane the size . Is this option available using DBCA or we need
to alter the size
after database is created with default size.
Environment is 9i on sun 2.8
Thanks
--Harvinder
--
Hi Folks ,
Somebody tell me I am not insane...please..!!
The problem is this...
As usual Everybody else except DBA ( me..) decided and
designed a program to create user in other database
using a procedure thru db_link.
Example.
The programme exists in database A. When they want
they have to
pong
Larry Elkins wrote:
--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
There are two solutions:
a) Function based index on UPPER(required column)
b) Upgrading MS Access to support unlimited users on SUN Solaris.
Do not forget to buy the row-locking option.
-Original Message-
Sent: Wednesday, December 05, 2001 5:10 PM
To: Multiple recipients of list
We are currently using US7ASCII for our 240 Gig data warehouse.
We are considering switching over to UTF8 for a new generation
of this product. We would start small in the development database
but by the time that we get to production, we will have just as much
data as we do now.
My question
Charlie,
You must first put your database in ArchiveLog mode, of course. The basic
init.ora parameters to set and the command Alter Database ArchiveLog
(while mounted, but not open, after a clean shutdown) haven't really changed
from 7 to 8 to 8i, except now you can specify archive log
Hey folks,
I don't want to reinvent the wheel if I don't have to.
Does anyone have a LUHN function they'd be willing to share?
Thanks,
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe LaCascio
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
LISTS
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Koniszewski, Mike
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
It's vewy vewy quiyet.
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
user$ is updated and why not just reset it to the known value, only if
you happen to have the encrypted password, then you could set it back
using alter user userid identified by values 'ENCRYPTED PASSWORD HERE';
otherwise you're outta luck.
joe
Burton, Laura L. wrote:
When you alter a
Ross
Size doesn't matter.
No, really.
Who's imposing the amount of data constraint??
Push Dodge and Gorman's Oracle8 Data Warehousing book toward your
damagement, and somehow trick them into reading the first chapter. They
quote Inmon (of course) -- a data warehouse is a subject oriented,
And I might add, it works very well.
I did the same thing at Enron to prevent the
duhvelopers from changing account passwords.
Jared
Joe Testa
Thanks for the assist, bro'. They got me
jumping-through-my-own-hindquarters busy here.
Lisa K., you wanted meaningful work? Move west and
I'll hook you up. Meaningful? Debatable. Work? Oh
yeah!
--S
--- Kevin Lange [EMAIL PROTECTED] wrote:
Couple clarifications:
1. -a : file exists
Not here, no, too darn much, and yes.
--S
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
Is anyone using Oracle Parallel Server? It that the
best solution for a
standby server?
Any idea what it would cost? Are there any classes
covering implementation?
Ron Smith
Title: RE: Column Title
Binay,
It is a bug related to cursor_sharing=force.
Try alter session set cursor_sharing=exact.
Alex.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 9:25 AM
To: Multiple recipients of list
I haven't received anything since this morning.
-Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Raube
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Try using Custom it will allow you to do that and more
Cheers
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.Mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Barbara... have you been talking to men again...?
As I was instructed by the Oracle Data Warhouse class instructor last
year... it isn't the amount of data, but what it's purpose is... what you
do with it.
He was a neat teacher... Harley and all.
April
-Original Message-
To:
...and look what's happened to Enron! :-0
And I might add, it works very well.
I did the same thing at Enron to prevent the
duhvelopers from changing account passwords.
Jared
Joe Testa
teci@the-test To: Multiple recipients of list
I am brain dead and can't figure this one out probably something really basic.
8.1.6 database
I have a delete trigger when I delete a row from user #1 address table and I want to
insert a corresponding row into an archive address table that belongs to user #2.
If there is any error inserting
Title: Password Changes
sys.dba_users-password is the field.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Burton, Laura
L.Sent: Thursday, December 06, 2001 12:29 PMTo:
Multiple recipients of list ORACLE-LSubject: Password
True, but I really didn't get much personal gain from that trigger. :)
Jared
Vergara,
It can be seen in dba_users. The table is sys.user$.
Once you've changed it, the old value is gone for good.
Jared
Burton, Laura
Pong.
Larry Elkins
elkinsl@flash To:
Ross,
A DW is defined by purpose and design, not by size.
A collection of Data Marts, ( tables for star joins ) is not
a DW either. DW's are used to create data marts.
If you don't already have the database books from
Kimball, I suggest you acquire them.
Data Warehouse Toolkit
yes it does (resounding yes)
-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L
Ron, does this affect 9i?
Dave
Ron Rogers [EMAIL PROTECTED] 12/07/01 04:28am
List,
Received this the the SearchDatabase org today. I thought some of
Except for the most current version of 9i
-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L
Ron, does this affect 9i?
Dave
Ron Rogers [EMAIL PROTECTED] 12/07/01 04:28am
List,
Received this the the SearchDatabase org today. I
Oh, that was a low blow:-)
-Original Message-
Michael (TEM)
Sent: Thursday, December 06, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L
...and look what's happened to Enron! :-0
And I might add, it works very well.
I did the same thing at Enron to prevent the
duhvelopers
Hi all,
I've got 2 questions here : (Platform : Sun Solaris) :
1. What is the command in PL/SQL to get unix userID who logged in when I
execute PL/SQL
script ?
2. I have created a new user : ABC123, and the primary group is oinstall.
When I start oracle instance using ABC123, how come
Jared,
Thanks. I have the main RK book. Like it. Understand what
little i have read of it. I am just interested in what
folks thought about size vs. DW definition was.
I *do* think, tho, that size does matter.
I don't consider my shared E: drive a datawarehouse
because it can support a
Hi Gurus,
I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City
change the date of the system on which the database resides
-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please
SYSDATE is determined by the operating system's date. You can't change the current
date and time in Oracle; you have to change it at the OS level.
If, however, your aim is to determine things like what's the date one week from
today, then you can use Oracle's date arithmetic functionality
Hi Unix Gurus,
Does anyone know how to change the date of the Unix system ? I am running my
database server in Unix 2.6. Thanks.
Regds,
New Bee
PS. Thank you, Kranti, for your reply.
-Original Message-
From: kranti pushkarna
[mailto:[EMAIL
Hi Williams,
Thnq for responding.
1) I need to tune the sql statemnet that have the queries using high
load %.
2) and need to look into the other issues too. like instance details
etc.
One of the list member Raj sent the documents. I am looking into them. I
think they will
How about Linux or Solaris versions on the Pentium 4 hardware?
Khoa Do [EMAIL PROTECTED] 12/07/01 11:30am
Except for the most current version of 9i
-Original Message-
Sent: Thursday, December 06, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L
Ron, does this affect 9i?
Dave
Quick answers:
Yes, Maybe, $$$, Yes.
Detailed answer to second part:
It depends on what you need and what you mean by standby server.
OPS/RAC is multiple instances and a shared database. If you really
need ultimate HA, OPS/RAC is second to none for system or instance
failure events. If one
I, like many others, have a problem with the size is everything
definition. I worked with a 2 TB DSS system six years ago that wasn't
a real data warehouse. And I've seen a true datawarehouse fledgling
that was under 200 GB (with lots of free space).
However, even making the nonsense
If somebody could lend assistance, here or offline, I would appreciate it.
The prob: Oracle SSP5 iprocurement installed on 8.0.5 DB with Oracle Apps
11.0.3. has problems dealing with the 6th session that trys to do a search
in iP. The 6th session will cause ALL connected browser sessions to
How about EBU? It is actually fairly good in 7.3.4+ and is very
straightforward to set up. Like RMAN, It uses a database catalog, but
the command syntax is radically different - in my opinion, much more
straightforward. It also include a shell command line utility named
ebutool that is quite
Hi all,
Can anyone share how to do proper redo log file sizing ?
Would 1G redo log file be enough for 5 TB datafile ?
and how to define howmany redo log file we need to have in one database ?
Thanks Regards
Herman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Is Las Vegas laying odds on this? I've got a few bucks I would wager
against...
This is not just unreasonable, but insane - even assuming that
everything goes perfectly (it won't). It is more reasonable to assume
that a horse is a perfect sphere or that the Israeli-Palestinian
problem could be
Dear All,
I've found the answer. I manage to use the date command in root account to
change the date. Thanks.
Regds,
New Bee
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Friday, December 07, 2001 1:10 PM
74 matches
Mail list logo
