OraFAQ Forum: Server Administration » ORA-12012+ORA-00959 + ORA-06512

Home » RDBMS Server » Server Administration » ORA-12012+ORA-00959 + ORA-06512 (Oracle 12c (12.1.0.1.0)- Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12012+ORA-00959 + ORA-06512 [message #667621]

Tue, 09 January 2018 00:55

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Hello Team,

I am getting below an error message in my alretlogfile.

ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-00959: tablespace 'DBSNMP_TEMP' does not exist
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1

Can you please help me on this issue.

Thanks

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667623 is a reply to message #667621]

Tue, 09 January 2018 01:31

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Create the missing tablespace.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667625 is a reply to message #667623]

Tue, 09 January 2018 01:32

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

tablespace is already exist.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667626 is a reply to message #667625]

Tue, 09 January 2018 01:41

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post evidence it does.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667630 is a reply to message #667626]

Tue, 09 January 2018 02:23

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Thanks. The requested tablespace was not there at primary. But the question is in my mind that this is coming after the below action. Why can you please suggest.

TT00: Standby redo logfile selected for thread 1 sequence 98385 for destination LOG_ARCHIVE_DEST_2
Sat Jan 06 22:47:09 2018
Archived Log entry 649085 added for thread 1 sequence 98384 ID 0xe752cf5e dest 1:
Sat Jan 06 23:00:02 2018
Errors in file /mnd/cnt/oracle/diag/rdbms/bcn1/bcn/trace/bcn_j000_5326.trc:
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-00959: tablespace 'DBSNMP_TEMP' does not exist
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667631 is a reply to message #667630]

Tue, 09 January 2018 02:33

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What do I suggest about what?

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667655 is a reply to message #667631]

Tue, 09 January 2018 10:56

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

We know tablespace 'DBSNMP_TEMP' does not exist, but the question is why is it asking for this tablespace, we never had this tablespace ? Who is requesting it and why.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667656 is a reply to message #667655]

Tue, 09 January 2018 12:32

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All is in the error message:
* who? job "SYS"."BSLN_MAINTAIN_STATS_JOB"
* why? because it needs it of course and more precisely it needs it at line 2073 of "DBSNMP.BSLN_INTERNAL"
Details are in the mentioned trace file.
Those are Oracle jobs and packages but YOU have defined the tablespace when you have created DBSNMP.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667657 is a reply to message #667656]

Tue, 09 January 2018 13:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://www.google.com/search?q=DBSNMP

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667659 is a reply to message #667657]

Wed, 10 January 2018 01:07

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Hi Michel,

Thanks for your update. Can you please let me know when we do the below command we get tablespace for which we are getting an issue. But the v$tablespace view doesn't show name of this tablespace.

select username,TEMPORARY_TABLESPACE from dba_users where username='DBSNMP';

USERNAME TEMPORARY_TABLESPACE
----------------------------------------------------------
DBSNMP DBSNMP_TEMP

Please give your comments to understand much more clear.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667660 is a reply to message #667659]

Wed, 10 January 2018 01:13

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What comment do you expect?
What is not clear in what you posted?
Please post a question.

[Updated on: Wed, 10 January 2018 01:14]

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667665 is a reply to message #667660]

Wed, 10 January 2018 01:37

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

We don't have created the tablespace DBSNMP_TEMP then why its assigned for DBSNMP user. How?

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667666 is a reply to message #667665]

Wed, 10 January 2018 01:43

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Because:

Quote:

YOU have defined the tablespace when you have created DBSNMP.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667676 is a reply to message #667621]

Wed, 10 January 2018 07:03

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Thank you very much for your update. But what to do to avoid this issue in future.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667682 is a reply to message #667676]

Wed, 10 January 2018 08:02

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Give a valid tablespace when you create DBSNMP and do not delete this tablespace.

Report message to a moderator

Re: ORA-12012+ORA-00959 + ORA-06512 [message #668109 is a reply to message #667682]

Wed, 07 February 2018 03:15

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Hi Michel,

Thank you very much for giving me an idea about the cause of the issue. I have resolved this issue by assigning the temp tablespace to the user. I see that the user DBSNMP is assigned the non-existent temporary tablespace DBSNMP_TEMP as its temporary tablespace

SQL> alter user DBSNMP temporary tablespace TEMP ;

Report message to a moderator

Previous Topic:	dataguard server (physical standby) is restarted automatically
Next Topic:	Is it required that the gid and uid at the destination server be the same as the source in nfs confi

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 00:15:57 CDT 2023