Re: LISTENER ON LINUX
ps -efw|grep tns -Candi On Fri, 2003-07-11 at 12:19, Seema Singh wrote: > Hi > When I try to see listener process on Linux box by ps -ef |grep tns .It > doen't show but when I tried to see the status thru lsnrctl status > listener_name .its shows service handler. > How to check whether listener is running or not and how to start that? > thx > -seema > > _ > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i or 9i ?
I have many opinions on certifications... :). First and foremost, why are you interested in studying Oracle? Is it for the money, or are you truly interested in working with it? Do you have any experience? If you aren't sure what you want to do, I suggest learning quite a bit on your own before investing a lot of money into the schooling you are talking about. You can install and play on your own. I know that kind of work impressed managment at my company more than anything else. It is the motivation and ability to learn the product on your own that impresses folks more than a certification. The 8i certification and 9i base level certifications are both just multiple choice exams. Anyone can pass them after cramming enough. It doesn't mean you know a thing at all, which is really sad. Now, all that being said, if you still want to go through with all of this, IMHO you should do the 8i and then upgrade to 9i. It isn't so much for the wealth of knowledge you will attain as much as marketability, which seems to greatly concern you. You can then at least claim to have some experience with both, thus improving your chances of meeting some HR screening software criteria. As for which track, I suggest you look over descriptions of each certification available. I'm not sure what they have right now, as far as certification offerings. -Candi Boyle Ps- yes, I actually do have oracle certifications. Why? Because my boss wants me to. Therefore I know how worthless they really are... On Fri, 2003-02-14 at 10:23, Les Ayudo wrote: > Hello, > > I'm thinking of going to school to get Oracle certified. There are 2 > schools in my area that are offering Oracle certs but one offers Oracle > 8i courses w/ an upgrade to 9i, while the other offers all 9i courses. > If i go to the schools who offers 9i courses, would I miss out on > valuable 8i knowledge? Which school should I attend? The courses will > last about 7 or 8 months. Also, is this a good "in demand" field to get > into? What chances am I looking at to getting hired as a newbie DBA > once I graduate? > > I want to get into the Ecommerce side of Oracle (connecting DBs to > websites/portals?). Which certification/path should I be following? > Thanks in advance!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
I have always found that both C and understanding makefiles were fundamental to running oracle on linux/unix. When the installer breaks, the knowledge comes in handy. And the installer seems to break quite often... -Candi On Tue, 2003-02-18 at 11:56, Les Ayudo wrote: > On top of learning Oracle, which programming languages would also > benefit some1 learning Oracle? Perl? Java? How would these languages > be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
See, that depends on how big a shop you run. I have to pull duty as the sysadmin as well. If the installer does not work, a relink fails, etc, I can't call my unix guy and ask for it to be fixed. I have found many problems with the install programs as shipped by oracle, especially on Linux (all the way back to 8.0.5, iirc, up to and including 9iR2). Not all the problems can be fixed with knowledge of C, but if you know what the program is doing, or if you can slog your way through the makefile, you have a better chance of fixing it. If you can't get oracle installed, then there isn't much need for a dba, now is there? -Candi On Tue, 2003-02-18 at 12:59, Jared Still wrote: > On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: > > C > > Not much need for most DBA's to ever use C, though > not a bad thing to know. > > Certainly doesn't belong at the top of the list for a DBA. > > Jraed > > > Shell Scripting > > Perl > > Pl/SQL - "not really a programming language" > > Java > > > > Now, if the more developer-minded DBA's amongst us could rate them as % > > important that would be cool! > > > > -Original Message- > > Sent: Tuesday, February 18, 2003 11:56 AM > > To: Multiple recipients of list ORACLE-L > > > > > > On top of learning Oracle, which programming languages would also benefit > > some1 learning Oracle? Perl? Java? How would these languages be used? > > > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: 7bit > Content-Description: > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Change data in directory "oraInventory"
Frank- We used to copy our stuff this way on AIX, and still kind of do it this way on Linux, but use vmware. What specifically is the problem? Is it that you want to change all of the references within the oraInventory directory structure to recognize the new instance name? -Candi On Thu, 2003-02-20 at 03:03, Frank Dandolo wrote: > Given IBM AIX and Oracle 81.7, i have dumped to tape the Oracle database > and all > the Oracle directories. The instance id is AAA. I have restored > everything on another > server with instance id BBB. The data in directory "oraInventory" still > points to instance AAA. > How can i change the data in instance BBB to recognize the new instance name. > In other words how can i convince Oracle to work with all the directories named > "/oracle/BBB" without having to install Oracle on server BBB ? > Has anybody tried this method or do we need to install Oracle software > first and then > restore the database ? Any suggestions will be appreciated. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Frank Dandolo > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AIX question
And, though I'm not sure if you need root to run it, I remember smitty was a wonderful little menu-driven tool for finding such information. And you hit a key combo that would show you the actual command for future reference. You'll have to forgive the vagueness, it's been quite some time since I had to use AIX. (Ah, the party we had when they took that RS6000 out of here) -Candi On Fri, 2003-02-21 at 13:39, Gene Sais wrote: > Everything in IBM land is 'ls...' something. I think lscfg should give > you more info, not sure of all the switches. > Gene > > >>> [EMAIL PROTECTED] 02/21/03 12:19PM >>> > > > AIX 4.3.3 > Can anyone tell me if there's a command to determine what volumes/disks > are on each controller? > > I'm way out of my element here but the SA for this system is scarce. > > Thanks for any suggestions, and have a great weekend everyone > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > Office: 954-935-4117 > Fax:954-935-3639 > Cell:954-683-4459 > > "The sender believes that this E-Mail and any attachments were free of > any virus, worm, Trojan horse, and/or malicious code when sent. This > message and its attachments could have been infected during > transmission. By reading the message and opening any attachments, the > recipient accepts full responsibility for taking proactive and remedial > action about viruses and other defects. The sender's business entity is > not liable for any loss or damage arising in any way from this message > or its attachments." > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- > Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network > Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- > Mailing list and web hosting services > - To > REMOVE yourself from this mailing list, send an E-Mail message to: > [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How long to hold onto old Oracle CDs?
We covered an entire wall in the operations manager's office with the Oracle cd's. We even had enough red ones to create a nice design... It all started because I asked him if we recycle cd's. He said only if I could find a new use for them. He shouldn't have said that and then taken a day off... -Candi On Mon, 2003-02-24 at 10:33, Stephen Lee wrote: > > You should keep them. You never know when you will decide to get a shotgun > and be in need of some targets. > > > -Original Message- > > > > Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX > > CDs? > -- > 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 services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS SQL hasn't given up!
The major misconception is that open source is free (As in no charge, al la "Free beer"). This this not the case. It is free, as in you can see the source code, play with it, and distribute it. However, you need support, maintenance, etc. This is where the costs are. My company uses Linux for production servers. We didn't move to it strictly because of cost. We moved to it for freedom and flexibility (as opposed to being tied to IBM support contracts). We have paid for 5 people to undergo training and certification and pay for licenses for RedHat Advanced Server. It is worth every penny to not have to schedule weekly reboots of the servers (which the networking group, running windoze, has to). It is also priceless to no longer have IBM telling us that merely considering touching the RS6000 violates our support contract. -Candi Proud user of Evolution mail client on a linux box running KDE... and vmware for windows -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: can't create database
the Enterprise
> > > > Version, so it can't be an Enterprise setting ... it has to be a problem
> > > > in the "init.ora", right?
> > > >
> > > > System specs if required:
> > > > Pentium II, 800 (2x - multi processor)
> > > > 1024MB RAM
> > > > 4GB Swap
> > > > 19GB diskspace free
> > > > Debian Linux (woody)
> > > > Kernel 2.4.20-686-smp
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > --
> > > > Christoph Schwerdtfeger <[EMAIL PROTECTED]>
> > > >
> > > > SoftConcept GmbH
> > > > Borriesstrasse 35
> > > > D-32257 B?nde
> > > >
> > > > Tel:(05223) 4970-20
> > > > E-Mail: [EMAIL PROTECTED]
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > >
> > > Ok, I just deinstalled Oracle 9i and installed 8.1.7 which ran - after
> > > applying the patch - without any problems ... dunno why.
> > > Maybe I should try to apply the 8.1.7-glibc patch to the 9i?
> >
> >
> > Try Oracle 9.2.0. I have installed it on many linux platforms
> > without any tricks. I think you said you were using 9.0.x.
> > I never had any desire to go there, so I don't know what
> > may be at issue.
> >
>
> I AM using Oracle 9.2.0 - or trying to use it.
> As I wrote, Oracle 8i (8.1.7) worked without any problems, but 9i
> (9.2.0.1.0 - EE) is a pain in the a$$.
>
> I do it the same way as with the 8.1.7.
> I don't have any problems during the installation (ok, a problem with
> the ins_ctx.mk, but this is fixed by adding "$(LDLIBFLAG)dl").
> I use the dbca to create a script for the database and login via
> "sqlplus /nolog" and do a "conn / as sysdba" and I get a
> Connected to an idle instance
>
> But, if I try to "startup nomount pfile="...";", I get an ORA-03113.
>
> I have applied the 8.1.7-glibc patch at the 9.2.0 version of Oracle,
> just for testing, but it didn't change anything.
> I've also done a "relink /all" ... didn't help.
>
> This is my init.ora:
>
> db_block_size=8192
> db_cache_size=25165824
> db_file_multiblock_read_count=16
>
> open_cursors=300
>
> control_files=("/home/oracle/oradata/sc/control01.ctl",
> "/home/oracle/oradata/sc/control02.ctl",
> "/home/oracle/oradata/sc/control03.ctl")
>
> db_domain=""
> db_name=sc
>
> background_dump_dest=/home/oracle/admin/sc/bdump
> core_dump_dest=/home/oracle/admin/sc/cdump
> user_dump_dest=/home/oracle/admin/sc/udump
>
> # I tried to comment this one out, didn't changed
> # a thing
> timed_statistics=TRUE
>
> dispatchers="(PROTOCOL=TCP) (SERVICE=scXDB)"
>
> hash_join_enabled=TRUE
> query_rewrite_enabled=FALSE
> star_transformation_enabled=FALSE
>
> java_pool_size=83886080
> large_pool_size=8388608
>
> # I raised the shared_pool_size, but with no luck.
> shared_pool_size=83886080
>
> # My /proc/sys/kernel/sem:
> # 500 32000 500 500
> # So this shouldn't be a problem
> processes=150
>
> fast_start_mttr_target=300
>
> remote_login_passwordfile=EXCLUSIVE
>
> pga_aggregate_target=25165824
> sort_area_size=524288
>
> # Tried to set the compatibility
> # to 8.1.0 ... didn't work ...
> compatible=9.2.0.0.0
>
> undo_management=AUTO
> undo_retention=10800
> undo_tablespace=UNDOTBS1
>
> Any help would be greatly apreciated.
> Thanks in advance
>
> --
> Christoph Schwerdtfeger <[EMAIL PROTECTED]>
>
> SoftConcept GmbH
> Borriesstrasse 35
> D-32257 Bünde
>
> Tel:(05223) 4970-20
> E-Mail: [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Schwerdtfeger, "Christop
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boyle Candi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
