HowTo: Remove parameters from the spfile |

October 2009
M	T	W	T	F	S	S
« Sep		Nov »
	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

Oracle DBA, Database Developer & Software Programmer

*If you like warm weather and surfing.* *PMRF Barking Sands Project (Kauai Hawaii) * Position Description Harris Corp. REQ #ES20171506-19295 POSITION TITLE: Oracle DBA, Database Developer & Software Programmer (EXEMPT) POSITION SUMMARY: Support IBM Maximo and Maximo Integration Framework in an Oracle database environment. Plan, design, develop and mainta […]

Bad public user name or password. Database Server Error: ORA-12541: TNS:no listener ;

Hi, Guys, I have this problem on my database. Please assist. Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MohdJun)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Primavera\Project Management\pm.exe)(HOST=MOHDJUN)(USER=user)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1 […]

Setting up Data Guard over very slow connection

While trying to Setup Data Guard involving a remote host, it happens that after Initial instantiation a failure occurs on the standby DB during the recovery Phase because archivelogs are missing, since they can't be kept that Long (they were deleted due to space constraints). But since there is enough space on the standby side (at the remote host), I th […]

Need help with query

I am trying to do self join on table to find desired result. The issue here is there are 7 level of hierarchy and i have to do 7 self joins to get result. But it is taking tie. Is there any way we can use other method to resolve it. QUERY:- Code: --------- SELECT DISTINCT LOWER(G.parent) AS PARENT_NAME, A.ID FROM EMP a LEFT JOIN EMP B ON a.PARENT_ID = B.EMP_ […]

HowTo: Remove parameters from the spfile

Posted on October 27, 2009 by maxwellmiranda

* How do you remove an SPFILE parameter (not change the value of, but actually purge it outright)?

* Use “ALTER SYSTEM RESET …” (For database versions 9i and up)

Syntax:

* ALTER SYSTEM RESET PARAMETER SID=’SID|*’
* ALTER SYSTEM RESET “_TRACE_FILES_PUBLIC” SCOPE=SPFILE SID=’*’;

NOTE: The “SID=’SID|*'” argument is REQUIRED!

About Me

Category

Archives

My Blog Calendar

Oracle Feeds