Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Miscellaneous > Middleware > Oracle Fusion Middleware > Oracle SOA Suite     

Cannot connect to database when running irca.sh


If you get the following error message:

ERROR: Failed to establish database connection due to the following error:
ORA-01017: invalid username/password; logon denied

when trying to run irca.sh to create schemas in SOA backend database it may be because
remote_login_passwordfile parameter is not set. Run the following command from sqlplus:

SQL> alter system set remote_login_passwordfile=EXCLUSIVE scope=spfile;

Restart the database. The script should be able to connect to database now.


  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

     (Average: 5 / Votes: 1)   Rate this tip:    

  Details
Tip reference : #187
views : 184
Added on : 04/04/08
Submited by : h8dk97
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (149)
 
 
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Databases > Oracle : Kill user session  
  Databases > Oracle : Scripts to backup Oracle database on Windows NT  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | TipLib FAQ
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com