Location of alert.log file
The name of the alert.log file is:
alert<ORACLE_SID>.logon Windows, or
alert_<ORACLE_SID>.logOn Unix/Linux
The alert.log file normally is in the $ORACLE_BASE/<ORACLE_SID>/bdump location, or since Oracle 11g in the database specific location in the diagnostic_dest.
If the database is running, you can issue following select to be able to identify the location of the background_dump_dest:
SQL> select value from v$parameter where name='background_dump_dest'; VALUE -------------------------------------------------------------------------------- /oracle/diag/diag/rdbms/ora11g/ORA11G/traceTo find the location of the diagnostic_dest, one can use the following select:
SQL> select value from v$parameter where name='diagnostic_dest'; VALUE -------------------------------------------------------------------------------- /oracle/diag/In order to know the current ORACLE_SID, you can use following select:
SQL> select name from v$database; NAME --------------------------- ORA11GIn our example, because we are on Linux, the name of the alert.log file will be:
/oracle/diag/diag/rdbms/ora11g/ORA11G/trace/alert_ORA11G.log
Welcome to our forum for this Oracle tip Add your own message
I have installed oracle 8i along with database.After entering username and password(scott,tiger) correctly,it started but when i restart my system after shutting down then i observed that after entering username and password, the system prompt that "oracle not found".How can I resolve this problem?
please help
You need to make sure that the Oracle Services are automatically started after a system reboot.
Open the Control Panel, goto the Services menu and check that the OracleServiceSID is started correctly
it is not started correctly.
Is there any procedure to start up this OracleServiceSid?
You need to just startup the service and make sure the service is set to start automatically.
If the service fails to startup, you need to investigate what's wrong. Have a look at the %ORACLE_HOME/dbs/oradim.log file ora in you alert.log file
hi guys!!
I am getting the below error and i am not able to connect to oracle database:
it says:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
so please could you help me out in connecting to the database
thanks and regards,
glbsng@gmail.com
you need to connect as SYSDBA and startup the database:
sqlplus "/ as sysdba"
startup
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
You will need to startup your Oracle database.
you might first need to set the correct environment
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.