Search results for query: *

I have been asked by my bss to find an Oracle (or other source) application that rotates Oracle log files (esp listener). He wants the log files rotated, run through a statistical pkg to he can display the data in "pretty pie charts and graphs" via web interface so he (and everyone...

Hi! I am a student (aka slave wage) worker. I work part time (10-20 hours/week) at a university center trying to learn all aspects of Oracle DBA and get experience so I can take the tests for certification and get hired as a DBA upon graduation. I am completeing a BS in CS and am planning to...

Okay, I knew enough to rename the initial passwords for SYS and SYSTEM (written down in a separate file/computer also in case it's fogotten, BTW). However, I have found out about other "users" set up by Oracle and Oracle utilities that also have well known passwords. There have...

I'm trying to find out what is the difference between Oracle 8.1.6 Standard and Enterprise editions. Evidently we have the standard version installed. thanks.

I am trying to find out how I can get Oracle Enterprise Manager to be fully functional on our system. Oracle Management Server does not work at all - just DBA Studio. DBA Studio has limited functionality - monitoring and user/password functions only. Right now, I have OEM/ DBA Studio on a W98...

Yes, I figure that the answer to this is in one of the myriad of books I have on the shelf but I thought I'd get some help here too. I'm a relative "newbie" (but still considered as the "expert" here - scary) and our system which is accessed via web interface went...

I'm working on my long-term plans here. I'm currently back at a university getting a BS and then MS in computer science (4.0 so far!). I am also working P/T on campus as an Oracle DBA - but everything I learn is strictly OJT. I am looking at what I should plan to concentrate on during the next...

I'm working with a Db in development that is going to be accessed via a web interface. The problem is that after the people exit the system, the connection is not severed. The BIG problem with this is that I cannot shut down the Db using normal or immediate because it is waiting for these...

I'm a "newbie" and I don't do hardware stuff at all. We are getting a new Sun server. One is going to be devoted to Oracle as the new Web server. There will be two databases, at least, on the server but they are either in development or will be imported from somewhere elase and the...

I created a database on Friday using DBASSIST. It currently has no data. The owner now wants it by another name. I have the procedures from Metalink how to do this but it seems like it is more work than just deleting the database and recreating it under the new name even though it takes about 6...

I am trying to create usernames and let the users pick their passwords the first time they log on for security purposes. So far, I have not been able to get this to work. I was using the syntax that was given in the Oracle books. My steps are below.... SQL> create user tester identified by...

I wish I knew what happenned.... 1) There are 3 Oracle Dbs on the server. Yesterday, I was trying to create a new database using DBASSIST. I could not do it because evidently my username for the system did not have permission to create files and directories. I exited DBASSIST without doing...

I am working on Oracle 8.1.6 with a SUN/Unix OS. I am a P/T student with no backup, or anyone to ask, about Oracle DBA. I found a script on another site that monitors the system for TNSLNSR, running processes, etc and sends an e-mail if any of it goes down. One of the things it checks is to see...

I am on a Sun workstation w/ Unix and Oracle 8.1.6. I was shown once how to start DBASSIST to create a new database but can't remember how. I just don't know enough about UNiX to be able to start this. Can anyone help? I am usually in BASH but can switch to another shell if necessary. Besides...

I am working in Oracle via Unix. There are several DBs on the server with unique names and separate instances. However, I cannot seem to acess them. In Unix, I would have ORACLE_SID=<database name> and export this (script in .profile). Then I would enter $ SQLPLUS to gain access to the DB...

I have a file with the following warning message Fri Sep 1 04:07:53 2000 1024: Can't get platform hostid; error: Could not find primary hostid from eeprom file 967799245 80e7569b ffffffff 28112 OuoWk3wMYTvA1R+00KqM7g (NOTE: the eeprom file number changes along with the last two sets of...

I am getting a Sun adm message file with the following entries over and over. I have included one whole &quot;cycle&quot; of messages below. What causes this? How can I fix the problem? (this message posted on THE SUN OS board also) Thanks. **************** Feb 14 12:06:02 oracle SSP Startup...

I am getting a Sun adm message file with the following entries over and over. I have included one whole &quot;cycle&quot; of messages below. What causes this? How can I fix the problem? (this message posted on an Oracle board also) Thanks. **************** Feb 14 12:06:02 oracle SSP Startup: ...

I am the (student) DBA and I need to change the owner of tables/DB from the (departed) DBA username to my own before I delete her from the system. How do I do that?

*** DUMP FILE SIZE IS LIMITED TO 0 BYTES *** I was cruising through my directory and found .log files that contain this message. As best as I can figure out, someone is trying to export from the database but there is no dump file set aside to allow this. No one claims any knowledge of these...