Home » RDBMS Server » Server Administration » ORA-12012+ORA-00959 + ORA-06512 (Oracle 12c (12.1.0.1.0)- Unix)
ORA-12012+ORA-00959 + ORA-06512 [message #667621] Tue, 09 January 2018 00:55 Go to next message
daulat01
Messages: 55
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

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667623 is a reply to message #667621] Tue, 09 January 2018 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Create the missing tablespace.

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667625 is a reply to message #667623] Tue, 09 January 2018 01:32 Go to previous messageGo to next message
daulat01
Messages: 55
Registered: May 2011
Location: Delhi
Member
tablespace is already exist.
Re: ORA-12012+ORA-00959 + ORA-06512 [message #667626 is a reply to message #667625] Tue, 09 January 2018 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post evidence it does.

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667630 is a reply to message #667626] Tue, 09 January 2018 02:23 Go to previous messageGo to next message
daulat01
Messages: 55
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
Re: ORA-12012+ORA-00959 + ORA-06512 [message #667631 is a reply to message #667630] Tue, 09 January 2018 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do I suggest about what?

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667655 is a reply to message #667631] Tue, 09 January 2018 10:56 Go to previous messageGo to next message
daulat01
Messages: 55
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.

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667656 is a reply to message #667655] Tue, 09 January 2018 12:32 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
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.

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667657 is a reply to message #667656] Tue, 09 January 2018 13:09 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
https://www.google.com/search?q=DBSNMP
Re: ORA-12012+ORA-00959 + ORA-06512 [message #667659 is a reply to message #667657] Wed, 10 January 2018 01:07 Go to previous messageGo to next message
daulat01
Messages: 55
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.
Re: ORA-12012+ORA-00959 + ORA-06512 [message #667660 is a reply to message #667659] Wed, 10 January 2018 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
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 Go to previous messageGo to next message
daulat01
Messages: 55
Registered: May 2011
Location: Delhi
Member
We don't have created the tablespace DBSNMP_TEMP then why its assigned for DBSNMP user. How?

Re: ORA-12012+ORA-00959 + ORA-06512 [message #667666 is a reply to message #667665] Wed, 10 January 2018 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because:

Quote:
YOU have defined the tablespace when you have created DBSNMP.
Re: ORA-12012+ORA-00959 + ORA-06512 [message #667676 is a reply to message #667621] Wed, 10 January 2018 07:03 Go to previous messageGo to next message
daulat01
Messages: 55
Registered: May 2011
Location: Delhi
Member
Thank you very much for your update. But what to do to avoid this issue in future.
Re: ORA-12012+ORA-00959 + ORA-06512 [message #667682 is a reply to message #667676] Wed, 10 January 2018 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
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.

Re: ORA-12012+ORA-00959 + ORA-06512 [message #668109 is a reply to message #667682] Wed, 07 February 2018 03:15 Go to previous message
daulat01
Messages: 55
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 ;
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:
  


Current Time: Thu Nov 15 11:19:14 CST 2018