| no alert log after DB creation [message #250366] |
Mon, 09 July 2007 15:18  |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Hi,
I just finished creating a database in Oracle10 on RHEL 4 and when I checked the bdump directory I found no alert log file there. I check my init.ora file to see if I had put the path in there and it was. What could cause this?
Thanks.
|
|
|
|
|
|
| Re: no alert log after DB creation [message #250368 is a reply to message #250367] |
Mon, 09 July 2007 15:54  |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
I restarted it but no change.
[oracle@vtl-oracle11 conf]$ sqlplus "/as sysdba"
SQL*Plus: on Mon Jul 9 15:54:52 2007
Copyright (c) 1982, 2006, Oracle. All rights reserved.
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 783040512 bytes
Fixed Size 2135720 bytes
Variable Size 456382808 bytes
Database Buffers 318767104 bytes
Redo Buffers 5754880 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database ....
[oracle@vtl-oracle11 conf]$ cd /opt/app/oracle/admin/FPRCEDGE/bdump/
[oracle@vtl-oracle11 bdump]$ ls -al
total 16
drwxr-xr-x 2 oracle dba 4096 Jun 25 16:55 .
drwxr-xr-x 13 oracle dba 4096 Jun 28 14:10 ..
[Updated on: Mon, 09 July 2007 16:08] Report message to a moderator |
|
|
|
| Re: no alert log after DB creation [message #250369 is a reply to message #250368] |
Mon, 09 July 2007 16:17 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
SQL> show parameter background_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /u101/oracle/ds/oradump
SQL>
SQL>
post the result and checkt alert file there.
|
|
|
|
|
|
|
|
| Re: no alert log after DB creation [message #250926 is a reply to message #250852] |
Wed, 11 July 2007 19:55 |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Yes. Actually the version is 11g. So one new thing is the location of the alert log file.
SQL> show parameter background_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /opt/app/oracle/diag/rdbms/fpr
cedge/FPRCEDGE/trace
[Updated on: Wed, 11 July 2007 20:20] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: no alert log after DB creation [message #251172 is a reply to message #251158] |
Thu, 12 July 2007 10:23 |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Of course it is the Beta. The official release is suppose to be today as I'm sure you all know. And I just got a packet of the latest drop (Beta 5).
Enjoy!!!
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.3.1 - 64bit Beta
With the Partitioning, OLAP and Data Mining options
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.3.1 - 64bit Beta
PL/SQL Release 11.1.0.3.1 - Beta
CORE 11.1.0.3.0 Beta
TNS for Linux: Version 11.1.0.3.0 - Beta
NLSRTL Version 11.1.0.3.0 - Beta
|
|
|
|
|
|
| Re: no alert log after DB creation [message #251180 is a reply to message #251172] |
Thu, 12 July 2007 10:30 |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Another new thing in 11g, maybe you guys already know, is that Apex 3.0 now comes with the software. So you don't have to download it separately. And you can either run the apxins.sql script manually after database creation or you can have it included in the database creation script, which is what DBCA does by default.
And officially, I didn't break any rules because it was released yesterday and it was already public information. If I had given you some info on it prior to that, then yes I would be in a teeny bit of trouble  Just want my fellow DBA's to learn and enjoy the new version as I am
[Updated on: Thu, 12 July 2007 10:41] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
