|
|
|
Questions and answers for Troubleshooting
|
5. Troubleshooting
|
| 7.1 How can
you determine if an Oracle instance is up from the operating system level?
|
| 7.2 Users
from the PC clients are getting messages indicating :
|
| 7.3 . Users
from the PC clients are getting the following error stack:
|
| 7.4 How can
you determine if the SQLNET process is running for SQLNET V1? How about V2?
|
| 7.5 What
file will give you Oracle instance status information? Where is it located?
|
| 7.6 Users
aren?t being allowed on the system. The following message is received:
|
| 7.7 Where
would you look to find out if a redo log was corrupted assuming you are using
Oracle mirrored redo logs?
|
| 7.8 You
attempt to add a datafile and get:
|
7.9 You look
at your fragmentation report and see that smon hasn?t coalesced any of you
tablespaces, even though you know several have large chunks of contiguous free
extents. What is the problem?
|
7.1 How can you determine if an Oracle instance is up from the operating system
level?
|
|
There are several base Oracle processes that will be running on multi-user
operating systems, these will be smon, pmon, dbwr and lgwr. Any answer that has
them using their operating system process showing feature to check for these is
acceptable. For example, on UNIX a ps -ef|grep dbwr will show what instances
are up.
|
7.2 Users from the PC clients are getting messages indicating: ORA-06114: (Cnct
err, can't get err txt. See Servr Msgs & Codes Manual) What could the
problem be?
|
|
The instance name is probably incorrect in their connection string.
|
7.3 Users from the PC clients are getting the following error stack:ERROR:
ORA-01034: ORACLE not available ORA-07318: smsget: open error when opening
sgadef.dbf file. HP-UX Error: 2: No such file or directory What is the probable
cause?
|
|
The Oracle instance is shutdown that they are trying to access, restart the
instance.
|
7.4 How can you determine if the SQLNET process is running for SQLNET V1? How
about V2?
|
|
For SQLNET V1 check for the existence of the orasrv process. You can use the
command "tcpctl status" to get a full status of the V1 TCPIP server, other
protocols have similar command formats. For SQLNET V2 check for the presence of
the LISTENER process(s) or you can issue the command "lsnrctl status".
|
7.5 What file will give you Oracle instance status information? Where is it
located?
|
|
The alert.ora log. It is located in the directory specified by the
background_dump_dest parameter in the v$parameter table.
|
7.6 Users aren?t being allowed on the system. The following message is
received:ORA-00257 archiver is stuck. Connect internal only, until freed What
is the problem?
|
|
The archive destination is probably full, backup the archive logs and remove
them and the archiver will re-start.
|
7.7 Where would you look to find out if a redo log was corrupted assuming you
are using Oracle mirrored redo logs?
|
|
There is no message that comes to the SQLDBA or SRVMGR programs during startup
in this situation, you must check the alert.log file for this information.
|
7.8 You attempt to add a datafile and get:ORA-01118: cannot add anymore
datafiles: limit of 40 exceeded What is the problem and how can you fix it?
|
|
When the database was created the db_files parameter in the initialization file
was set to 40. You can shutdown and reset this to a higher value, up to the
value of MAX_DATAFILES as specified at database creation. If the MAX_DATAFILES
is set to low, you will have to rebuild the control file to increase it before
proceeding.
|
7.9 You look at your fragmentation report and see that smon hasn?t coalesced
any of you tablespaces, even though you know several have large chunks of
contiguous free extents. What is the problem?
|
|
Check the dba_tablespaces view for the value of pct_increase for the
tablespaces. If pct_increase is zero, smon will not coalesce their free space.
|
|