Home » Infrastructure » Linux » no alert log after DB creation
no alert log after DB creation [message #250366] Mon, 09 July 2007 15:18 Go to next message
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 #250367 is a reply to message #250366] Mon, 09 July 2007 15:36 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
restart your database.
Re: no alert log after DB creation [message #250368 is a reply to message #250367] Mon, 09 July 2007 15:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #250706 is a reply to message #250369] Wed, 11 July 2007 00:37 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
Yes, thank you. I can't beleive it. It was in another location.

Thanks.
Re: no alert log after DB creation [message #250852 is a reply to message #250706] Wed, 11 July 2007 10:31 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yea some times we made big mistakes but we dont want to accept them.
Yw Wink
Re: no alert log after DB creation [message #250926 is a reply to message #250852] Wed, 11 July 2007 19:55 Go to previous messageGo to next message
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 #250927 is a reply to message #250926] Wed, 11 July 2007 20:31 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
WOWW KEWL man you being lucky as a works on 11g Wink
Re: no alert log after DB creation [message #250997 is a reply to message #250926] Thu, 12 July 2007 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post "select * from v$version", we will enjoy it... Cool

Regards
Michel
Re: no alert log after DB creation [message #251158 is a reply to message #250997] Thu, 12 July 2007 09:49 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Razz
Michel Do you have 11g?
Re: no alert log after DB creation [message #251172 is a reply to message #251158] Thu, 12 July 2007 10:23 Go to previous messageGo to next message
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 #251174 is a reply to message #251158] Thu, 12 July 2007 10:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DreamzZ,

I don't have it, this why I can talk about it without breaking any rules. Wink

Regards
Michel

[Updated on: Thu, 12 July 2007 10:26]

Report message to a moderator

Re: no alert log after DB creation [message #251180 is a reply to message #251172] Thu, 12 July 2007 10:30 Go to previous messageGo to next message
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 Razz Just want my fellow DBA's to learn and enjoy the new version as I am Razz

[Updated on: Thu, 12 July 2007 10:41]

Report message to a moderator

Re: no alert log after DB creation [message #251184 is a reply to message #251180] Thu, 12 July 2007 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you can this to the Wiki page:
http://www.orafaq.com/wiki/Oracle_11g

Regards
Michel
Re: no alert log after DB creation [message #251497 is a reply to message #251174] Fri, 13 July 2007 17:42 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Michel Cadot wrote on Thu, 12 July 2007 09:26
DreamzZ,

I don't have it, this why I can talk about it without breaking any rules. Wink

Regards
Michel


Razz Laughing
Previous Topic: script not working in RedHat Linux.
Next Topic: RunInstaller
Goto Forum:
  


Current Time: Thu Mar 28 06:32:20 CDT 2024