Hi Mladen,
please excuse me. Since I try to improve my knowledge
about the English: what do youmean with muave? Some
kind of wood?
Please enlighten me.
Greetings,
Guido
[EMAIL PROTECTED] 11.09.2003 20.49 Uhr
And the database must be muave.
--
Mladen Gogala
Oracle DBA
--
Please see
Hi List,
Sorry to post this again.Hope i will get some replies this time.
I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink.
Can someone mail me if u have a copy of the same ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Dear Chip,
Was there a bug number and was it logged in Metalink? Do you know which procedure/package was involved of the top of your head?
-Original Message-
From: Chip [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: URGENT REPORTS WONT START
It was a problem with 2 things:
1-someone had changed the display on me!
2-conf file was corrupted.
Worked it out but can anyone tell me where I can get more robust descriptions of the conf files and how to edit them and each part of them?
Thanks,
Title: Connect sys/[EMAIL PROTECTED] as sysdba E-Business suite
Hi All,
I have seen some weird behaviour and must have been searching in the wrong places.
When logging in to a 9i RAC environment using the syntax sys/[EMAIL PROTECTED] as sysdba it works fine at the primary instance but
Here is a code snippet from one of my functions that get a list of ranges,
i.e '1_10,11-100,' and separate them into a vector.
(needs comma also after last value for easier parsing).
The function operates under a package so I can retain variables between
activation of the functions.
I keep the
Try Google.
Last month I needed a script to estimate new index size and
Google gave great links.
Yechiel AdarMehish
- Original Message -
From:
Munish Bajaj
To: Multiple recipients of list ORACLE-L
Sent: Thursday, September 11, 2003 3:19
PM
Subject: DataBase
Peter,
I know that this looks odd but as the hardware is 64 bit the AIX O/S has
some sort of translation layer that allows it to run Oracle 64 bit even
though the kernel is in 32 bit mode. I discovered this when investigating
running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Found
out it is this:
Errors for PACKAGE BODY DBMS_RCVMAN:
LINE/COL ERROR
-
2256/1 PLS-00593: default value of parameter "PARTIAL_RCV" in body
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Found
the note referencing bug and says it is fixed in 9i. I am running
9.2.0.1.0 and the upgrade catalog on 8.1.7 catalog worked - we will see if
backup actually does. Trying on 8.0.6
-Original Message-From:
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Was
able to upgrade the catalogs as getting "catalog too old error" and found great
note and compatiblity matrix:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=73431.1
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Hi,
I'm
trying to grant SELECT privileges on some tables in schema X to userid Y. I'm
currently connected as SYS. But when I try typing
GRANT
SELECT ON X.MYTABLE TO Y;
...I
get an ORA-01031 error - Insufficient
you should send them over to Australia. At least they'd be
better than the standard of dba we get here...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
In Estonian language, the word administrator also means receptionist.
Guess how many former hotel receptionists or
At 02:49 12/09/2003 -0800, you wrote:
Hi,
I'm trying to grant SELECT
privileges on some tables in schema X to userid Y. I'm currently
connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO
Y;
...I get an ORA-01031 error -
Insufficient Privileges.
Now I thought SYS had all the
LOL, Mauve is a shade of the colour Purple.
And of course, everybody knows that purple databases run faster! ;)
Personally, I've always preferred Electric Blue databases, funky, fast, and
FAR easier to manage!
-Original Message-
Guido Konsolke
Sent: 12 September 2003 08:54
To:
Dear Friends,
I am looking for a good reference of all ( some which are very much useful
required for DBA ) the SQL scripts ,packages and all required views.
UTL*.sql ,
DBMS_*
DBA_*
V$*
I just want to memorize the important of above. Any document, PPT or white
paper or any URL will be helpful.
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
Reference:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm
Supplied PL/SQL Packages and Types Reference:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/toc.htm
Have Fun! That's some
not until the 9i world, you must login as the schema owner or build a
procedure to be able to do it.
joe
Paul Vincent wrote:
Hi,
I'm trying to grant SELECT privileges on some tables in schema X to
userid Y. I'm currently connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO
Hmm, applied Feng Shui for Oracle Performance.
For optimum throughput storage should be coloured red and white in
alternating bands of colour.
It's called disk-striping.
Badummp-k !!
I'll get me coat ... and back on topic.
Mike
-Original Message-
Sent: 12 September 2003 11:14
Thanks
Bill - not good news, then!
Trouble is, I'm setting up a bunch of "read-only" userids which can see
(but not touch) tables in several other schemas. So instead of doing all the
grants with a single connect (as SYS), evidently I'll have to connect as each
schema-owner in turn, and
Raju,
SQL select * from dictionary;
this will give u list of dictionary views/tables.
...no idea about the scripts though.
Jp.
12-09-2003 20:19:25, Veeraraju_Mareddi [EMAIL PROTECTED] wrote:
Dear Friends,
I am looking for a good reference of all ( some which are very much useful
required
Thanks a lot Tanel and GovindanK for answering to my query.
With Warm Regards
Siddharth
Haldankar
Cisco Systems Inc. ODC
Zensar Technologies
Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Title: Connect sys/[EMAIL PROTECTED] as sysdba & E-Business suite
Hi!
Are you sure that you have correct password file in
second instance?
Maybe you're using wrong password (or do not have
pwdfile) buf on first instance you just belong to os DBA group, thus you can log
on using whatever
Raju,
Have you tried the 'Oracle 8i Reference Guide' for DBA_*, V$*
views, and 'Supplied packages Reference' for DBMS_*, UTL_*? (If
you have, you would do well to mention so, to send right signals
to some of the list members.)
If you are looking for the source code for the supplied packages,
you
Hallo everyone,
I have a unix question, hope you can help me. Maybe this is too simple but would
appreciate any help.
I would like to rename the files
konkurrenter.txt.1,konkurrenter.txt.,,konkurrenter.txt.3 to be renamed to
konkurrenter.txt at the same time.
So the result would be 3 files,
$ORACLE_HOME/rdbms/admin
and documentation
happy reading.
joe
Veeraraju_Mareddi wrote:
Dear Friends,
I am looking for a good reference of all ( some which are very much useful
required for DBA ) the SQL scripts ,packages and all required views.
UTL*.sql ,
DBMS_*
DBA_*
V$*
I just want to
Hi Tanel
I did not mention that w/o the connect string it works
Will look at the password file.
I have not tried to run a query in SQL*Plus, will ask the cst to do so.
I use a new user for the repository (not apps)
Jack
-Original Message-
Sent: Friday, September 12, 2003 1:49 PM
At 03:34 12/09/2003 -0800, you wrote:
Thanks
Bill - not good news, then!
Trouble is, I'm setting up a
bunch of read-only userids which can see (but not touch)
tables in several other schemas. So instead of doing all the grants with
a single connect (as SYS), evidently I'll have to connect as
Title: RE: Good small reference !
If you want to memorize all of things you mentioned, get at-least an yearlong sabbatical and stay away from this material world.
Jokes aside, don't try that, there is no need. Oracle provides manuals just for the very reason.
Raj
Hi Tanel
I did not mention that w/o the connect string it works
Try to log on as sysdba with bogus password (without connect string), you
should be able to log on anyway, because you're in os dba group.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel
If konkurrenter means competitor, they have nothing to fear.
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Fri, 12 Sep 2003 03:59:25
Hallo everyone,
I have a unix question, hope you can help me. Maybe
this
Hi All,
Has anyone heard of any known gotchas with installing the latest MS patch
on Oracle server?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
If MS means Micros**t, our Techs have been applying patches like crazy to
all our Win2k servers. Our production Student Info. database lives on one
of those - it's EE 8.1.7.4 - and I've seen no ill effects. We just had to
find a time to reboot the server so the patches would take effect.
Jack
Hallo,
anyone whom could help me with a unix command how to
give permission to delete files from a special directory?
I am trying to use chmod command but it doesnt work with chmod 755
It says permission denied then.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ:
Send me a check to $100 and I'll create you username on
http://technet.oracle.com that will
make it possible for you to reach the requested information at any given
moment.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Title: Message
You
should set remote_os_authent and remote_os_rolesto true, otherwise
RMAN will not be able to connect to the remote isntance as
sysdba. On the other hand, you might want to reconsider it, because that
would open your instance wide to the various forms of
network
attacks.
3 different files, having the same name in the same directory? Only
Microsoft
can do that, but only if you buy enterprise wide license for Windows,
Exchange and SQL*Server.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Hi.
Just wanted to thank all who replied to my original
question. I was only looking for one way and I got
several from different people (which is great) within
just a few hours. Thanks you all very much!!!
Gene
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free,
Well no, I have bought the Expert one on one book.
I check on his web site and I found one reference where he addresses the use
of changing the stats.
Usually you can find what is its opinion just by the tone, but this time I
was not able to see if he's against or not on this.
Can you share more
Thanks for the response. I have Metalink note 231901.1 which explains
the options for installing 8.1.7 on AIX 5L, so I understand what I have
to do (after reading it three times).
Additional questions:
- If we run the 64 bit kernel and put on the required patch for 8.1.7
will I be running
Dear All,
Please share / url for a good document / presentation explaining different
locking mechanism in Oracle , and Oracle DBA reacts to each kind of lock ,
with some scenarios.
Please post any relative material.
TIA,
Rajuveera
If you can't do a chmod 755 XXX, then you can´t do this ... you don't have
enough privileges...
Do a su root (if you can), or ask the owner of the files to do the chmod ...
BTW, Chmod 755 isn't enough, I think you need a 777 ... (my chmod numbers
are a little hazy)
(is this an oracle related
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Friday,
September 12, 2003 6:59 AM
Hallo everyone,
I have a unix question, hope you can help me. Maybe this is too simple but
would appreciate any help.
I would like to rename the files
konkurrenter.txt.1,konkurrenter.txt.,,konkurrenter.txt.3 to
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Veeraraju_Mareddi
Sent: Friday, September 12, 2003 10:44 AM
To: Multiple recipients of list
How can I not see the init parameter, _kghdsidx_count in 9.2.0.3.0?
From: Tanel Poder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: 9.2.0.4 anyone
Date: Thu, 11 Sep 2003 17:54:30 -0800
Hi!
Oh yeah, I forgot to say that in
Is this for all platforms? I haven't heard about it for AIX5.2 but that
doesn't mean I shouldn't apply it.
Thanks in advance,
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Stephen Lee
Sent: Thursday, September 11, 2003 5:29 PM
To: Multiple
It's a hidden parameter, use this query instead:
select n.ksppinm name, v.ksppstvl value
from x$ksppi n, x$ksppsv v
where n.indx = v.indx
and n.ksppinm = '_kghdsidx_count';
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 12,
Yes, I saw it.
NT Server 4, IIS4, connecting to Oracle 8.0.4..
Patrice.
-Original Message-
Sent: Thursday, September 11, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
Have you tried the kb?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowtosd=MSDNln=E
N-USFR=0
Mladen Gogala [mailto:[EMAIL PROTECTED] on Friday, September 12, 2003
9:19 AM said;
3 different files, having the same name in the same directory? Only
Microsoft
can do that, but only if you buy enterprise wide license for Windows,
Exchange and SQL*Server.
(blink) is that an example of
Title: RE: Copying statistics : used a lot
Our production and test systems are same ... test lags 24 hours behind production that's all. But I have successfully used dbms_stats to copy over stats from production to test on a table by table basis to verify explain plans.
My opinion WAD -
Mladen is losing patience with all questions simple.
-Original Message-
Sent: Friday, September 12, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
Mladen Gogala [mailto:[EMAIL PROTECTED] on Friday, September 12, 2003
9:19 AM said;
3 different files, having the same name in
Thanks, Tanel. You always provide good solution.
From: Tanel Poder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: 9.2.0.4 anyone
Date: Fri, 12 Sep 2003 07:14:24 -0800
It's a hidden parameter, use this query instead:
select
I don't recommend setting any hidden _* parameter just because someone
thinks it's neat or it has once worked form someone.
If you got a problem, which isn't solvable by any other mean, then turn to
underscore parameters or other unsupported actions...
Tanel.
- Original Message -
To:
There is a known bug in Oracle's handling of the shared pool in 9.2.0.X (at
least) where the shared pool becomes increasingly fragmented and eventually
gets to where no more space can be allocated. Attempts to flush the shared
pool to clear it fail (Yes, I know this means everything has to be
Hey!!!
don't do that!
send me $50!... I can create your account too! of
course, at the same place!
:-)
JL
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Send me a check to $100 and I'll create you username
on
http://technet.oracle.com that will
make it possible for you to reach the requested
You are not right. SYSDBA is authenticated through the operating system. You
must have a DBA role
to be a SYSDBA, be it local or remote. To allow authentication of a remote
user as a sysdba, you
must explicitely tell oracle to do so. Dictionary accessibility has nothing
to do with that.
--
Stephen,
Surely, you must be mistaken. I just finished reading the Oracle 10G
article in the latest Oracle magazine about how they regression test every
little change made to the Oracle Rdbms code to ensure that bugs do not make
it out into production.
It *can't be* their fault. It *has to be*
Coffe is always good. Have one for me as well.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Brian Dunbar
Sent: Friday, September 12, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Question
That's only if the file ends in .DLL :)
Mladen Gogala
Hi!
No, o7_dictionary_accessibility controls whether SYS user can log on to
database without SYSDBA privilege (starting from 9.2). If it's false, sys
always has to connect as sysdba.
Mladen, don't you think that if you have created passwordfiles for each
instance in RAC and set
You can combine the files into one file, but Unix is like any other
operating system: file names must be unique. In VMS, the OS would use
versioning on the file name. In UNIX and other OSes, it doesn't happen like
that. Your syntax will combine all the files into one file.
RWB
It's supposed to be mauve, the color. The reference is from a Dilbert
cartoon. Google found a copy here:
http://www-dbs.cs.uni-sb.de/~dbs02/images/dilbert.gif
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI
Peter,
I'll answer the 2nd question first as it's easier.
- You will need to change the word size of your database from 64 bit to 32
bit. This involves running a few scripts and bouncing the database were
required. The exact process is described in a Metalink note, sorry but I
don't have the
It's Friday evening here already. One beer for me!
:)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 12, 2003 6:59 PM
Coffe is always good. Have one for me as well.
--
Mladen Gogala
Oracle DBA
-Original
Hi!
I just noticed that there's two parameters in 9.2, cpu_count (which defaults
to number of CPUs OS says), but what is _cpu_count? It seems to be
independent from cpu_count defaults to zero on my machine...
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
We have some tables that have data for many years. We are going to archive
the data that are older than 3 years. I would like to find out how you guys
usually do this or a best way to do this. Thanks for any inputs in advance.
Nancy
Hello,
We are starting to investigate different methods of searching
large medical documents for key words or phrases. The documents may
be text, html, xml, or MS word documents. The main idea is to search
and retrieve a list of documents quickly that match a given medical
key word(s) or
Nancy:
It's the standard answer: It Depends.
We are running SAP, and SAP has it's own flavor of archiving, and
each transaction type has it's own archiving rules. Archived
data is stored in special files that SAP can read, so that even
though the data is no longer in the Oracle database, it is
Mladen, doesn't your spell checker dictionary include
RUMPELSTILTSKIN?
;-)
--- Mladen Gogala [EMAIL PROTECTED] wrote:
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
You are not right. SYSDBA is authenticated through the operating system.
You
must have a DBA role
to be a SYSDBA, be it local or remote. To allow authentication of a remote
You probably meant SYSDBA privilege to be a SYSDBA? DBA role is irrelevant
here.
Tanel.
--
Please see the official
Nancy,
As with so many things, it depends.
If you *might* need some of the data back, then you need to be able to
recover it. That means if you do an export, you need to know what
version it is and track whether that table ever has any changes. If it
does change, you will need to jump through
Title: RE: archive old data
Hi Nancy,
Unless you are having serious performance / storage problems or another valid option would be just to delete the data, don't do it.
I inherited a database where we archive data yearly. I started working on the checklist and scripts last month and we
From ls -l command.
-rwxrwxrwx
First character, the dash in this case, identifies the kind of file (in Unix
everything is a file).
The next three are the owner's permissions.
The next three are the group's permissions.
The next three are the world's permissions.
r=read
w=write
x=execute
These
In an ideal world, tables are partitioned and you just have to archive partitions -
either to other tables in an ARCHIVE schema, or by exporting them - and then you can
truncate them (=partitions). In the real world, you always have some rows at a very
old date which are *not* in the CLOSED
Govindan,
Everything was successfully compiled. Even then the problem was happening. Your asktom note was helpful. It clarified a lot of related subjects.
We have a package and we declare a lot of application wide variables in the package (not the body). However since this problem can happen in
You're right. I made a mess of this. I'm busy, and I'll stay away from the
list
today.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tanel Poder
Sent: Friday, September 12, 2003 1:05 PM
To: Multiple recipients of
fastest and easiest way to do it is the following. create another tablespace with
another user. Set it to nologging.
alter session enable parallel dml;
create table /*+ parallel(max#,s) */ as
select *
from old_tablespace.table
where -- your filter.
export this new tablespace so you have a
Selling
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Friday, September 12, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT Re: RE: What is a large database?
It's
And for you cobol users out there:
we have been told that the bug related to setting
cursor_sharing=force
when using cobol has been fixed in 9.2.0.4.
So maybe that will help keep the 4031 bug in its box.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
Forgot to mention yesterday. I ran into a similar situation two weeks ago. Whenever
this happens in a SQL*Plus session, just do a DESCRIBE PACKAGE. You should be able
to describe successfully , and verify the signature (including datatype) tallies.
Also,keep track of the session session_roles and
Roland,
There are 2 techniques you can use. The first is what I call a 'dynamic
control file' - other posters have given you examples of that one, using
sed.
The next is create a 'loop loader'; essentially a script file that fires off
sqlldr for each loadable file. Here's an overly simple
All (in the US at least ;-) - maybe this explains it all...
http://www.nytimes.com/2003/09/12/business/12NORR.html?ex=1064030400amp;en=
5e8977089c9764eeamp;ei=5062amp
John
Sorry Jared for posting this - I think we do need to understand what may be
affecting our professional lives..
Title: RE: _cpu_count vs cpu_count
Tanel,
33 cpu_count initial number of cpu's for this instance system modifiable
34 _cpu_count current number of cpu's for this instance non-modifiable
For most of hidden parameters x$ksppsv.ksppstvl set to 0 by default.
Alex.
-Original
Prem,
You may want to check out Note# 1058332.6 for this. It appears that the
reference to Note# 52576.1 is bogus.
Good Luck!
Faan
-Original Message-
Sent: Wednesday, September 10, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I don't find Doc 52576.1 (Reg.
I really appreciate all replies. Those solutions are very good. I think
partition works for our case.
Nancy
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: archive old data
Date: Fri, 12 Sep 2003
We haven't had any problems with those here.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO
Partitioning in itself is not a complete solution, because it doesn't keep
track
of changes. You may also want to try Princeton Softech, which has a great
product
that archives things directly to CD juke box and keeps track of what is
where and changes
needed in order to get it back online, if
Hi All
I am able to connect to my database from a set of different
clients from different machines.
From one particular machine i am not able to connect to the DB
server machine.
ping db_machine_ip works fine
but tnsping service_name gives
Bus Error (core dumped)
Please help
Thanks and
Which platform version, how did you define your ORACLE_HOME and
ORACLE_SID,
did you export them, what do your tnsnames.ora and sqlnet.ora look like?
This way, I can only tell you to wait for another bus.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
both client and server on Sun OS 5.8
ORACLE_HOME and ORACLE_SID in .profile
tnsnames.ora
TRADEDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TRADEDB1)
)
)
From the listener.log I am getting:
12-SEP-2003 11:24:20 *
(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trade-host2)(USER=rubix)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) *
establish * TRADEDB1 * 12500
TNS-12500: TNS:listener failed to start a dedicated server
Maybe find something at http://sunsolve.sun.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
Oddly enough, I received the same error today on one of our Solaris
servers while trying to start a listener. I ran 'top' and noticed that all
of the available swap space on the machine was being used. After the
guilty process was killed, I was able to start the listener. FYI, the
process was
You cannot start process. You need to increase PROCESSES in
init$ORACLE_SID.ora.
You may have to increase SHMMAX and SEMMNS in /etc/system.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of bhabani s pradhan
Sent:
On the 9.2.0.3 databases I checked, it is 3.
-Original Message-
Can't get my hands oon 9.2.0.2 or 0.3, but in 0.4 (on Windows), the
_kghsidx_count defaults to 1 anyway, check it out on your systems.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
While running tnsping and sqlplus i am getting this:
WW_WS tnsping TRADEDB1
Bus Error (core dumped)
WW_WS sqlplus rubix/[EMAIL PROTECTED]
Bus Error (core dumped)
WW_WS /usr/sbin/ping 10.10.8.44
10.10.8.44 is alive
WW_WS echo $ORACLE_HOME
/export/home/oracle/product/8.1.7
WW_WS echo $ORACLE_SID
listener is running okay
it has refused some connections:
WW_DB lsnrctl stat
LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003
14:49:01
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of
Then, you have a problem with the number of processes on the OS level. The
investigation should continue on the server.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 5:46 PM
To: Mladen Gogala
yes that problem is resolved
actually there are two problems:
1] Solaris Error: 12: Not enough space
sys admin killed some processes and now other client machines can
connect and work on the db
2]tnsping and sqlplus on one particular client machine give
Bus Error (core dumped)
seems its a disk
Upgrading RAC 9203 to 9204 on Solaris.
First step is to upgrade ORCLudlm to 3.3.4.6. We ran
into issues when running package if Install group is
other than dba (it hardcodes the group as dba in one
of the files it uses). We had to manually edit the
file to get it to work.
Had to upgrade to fix a
1 - 100 of 104 matches
Mail list logo