Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Running script utlpwdmg.sql in Oracle 10g, Running script utlpwdmg.sql in Oracle 10g
donsls
post May 7 2012, 01:52 PM
Post #1


Advanced Member
***

Group: Members
Posts: 34
Joined: 16-November 06
Member No.: 5,651



I am trying to enable password complexity in Oracle 10g by using the utlpwdmg.sql file. When I manually run this using SQL plus, I get the following result

Function created

Alter Profile Default Limit

Error at line 1
ORA-07442: function VERIFY_FUNCTION notnfound

Could anyone let me know how to correct this please? I had no trouble setting this up in Oracle 9i.

Any help is greatly appreciated.
Go to the top of the page
 
+Quote Post
donsls
post May 7 2012, 02:05 PM
Post #2


Advanced Member
***

Group: Members
Posts: 34
Joined: 16-November 06
Member No.: 5,651



Found the solution. I was running the script under a non admin user. Ran it under sys and everythig worked.
Go to the top of the page
 
+Quote Post
burleson
post May 7 2012, 03:07 PM
Post #3


Advanced Member
***

Group: Members
Posts: 11,314
Joined: 26-January 04
Member No.: 13



Glad you found a solution!

Thanks for sharing, this may help others . . . .


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd July 2014 - 02:22 AM