Manage database on unix and NT

[lgaorcl]

We have a development database on unix and a production database on unix. There have been a lot of problems with production database, but very few problems with database on unix. Is it because it's on unix or because it's just a development database. Or, is it because it's a production database or because it's on NT?

My question actually is that is there a big differece in managing database on unix and NT?

[marist89]

Huh?

[raghud]

Please give clear information . I am little confused about first sentence and next ..


Raghu

[sambavan]

The architecture of NT and Unix is totally different. In NT every thing is thread based and in unix things are process based.

So
1. It could be because NT is an MS product, known for its problems and MS promisses

2. It could be that your development folks are not doing the correct job

3. Internal functionality of Oracle on unix would greatly differ from that of NT. Look for the caveats

4. Simple Call MS and Oracle, and shout "He...l..p!!!!"

If you don't mind could you tell us more on the kind of problems?


Sam

[lgaorcl]

I am sorry about typo. The first sentence is: we have a development database on unix and a production database on NT. And I want to know the differece between managing database on unix and NT. I am getting confident in managing database on NT. Can I have the same confidence in managing database on UNIX if I am going to work in a unix environment? What typical issues you have in a unix production environment?


Thank you!

Lisa

[raghud]

I didn't see any difference as a DBA ,except we need to learn little bit shell programming and cron just like we have at in NT . ...


Raghu

[sambavan]

Primary thing is the file system naming convention, "No spaces between file names". Learn the shell scripting. then learn the effective use of awk and sed. Once after you familiarize these learn perl.

Be aware, every invokation in unix is a process, which you can prempt and kill without interfering with the other. Unix is a very powerfull OS. If you learn it well.

Sam

[lgaorcl]

I have been using unix for about three years, not very good, but a kind of familiar with shell programming, awk and sed. I write cron job, create script for backup, check alert, trace files. That's about it. So when do you guys use shell programming, awk, sed knowledge? As I mentioned above, my database on unix is a development database, so I don't get many opportunities to solve the problem, neither get chance to pratice my unix knowledge.

How does perl have anything to do here?

Thank you!

Lisa

[sambavan]

Some shops use perl DBI modules to load the data and query the database and etc.

Administration of oralce under unix does not have a huge difference. In unix, not like nt, you would have to start things manually or have to have scripts that would be placed at the appropriate directories that would get executed automatically. Concept of file structure is different. When you say that you delete a tablespace in NT, it would clean up the files underneath that automatically, but in unix you would have to manually remove them. You can enforce a fine grain security on to the files. And more and more...

I would suggest that you get hold of a Unix System Administration book and learn.

Sam

[svk]

just a bit : Unix allows white space in file names.