Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

The CTXSYS account is locked in 9i. How do I unlock the account?

account CTXSYS InterMedia locked text unlock

1 Answer

0

From the command line (as DBA): sql>alter user ctxsys account unlock identified by ; You can also unlock the account from OEM (Oracle Enterprise Manager): unix>oemapp dbastudio [Back to Top] Commom Errors Create index: “Error loading external” library problems ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: ConText error: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open failed: No such file or directory ORA-06512: at “CTXSYS.DRUE”, line 122 ORA-06512: at “CTXSYS.TEXTINDEXMETHODS”, line 34 ORA-06512: at line 1 A. Stop your SQL*Net listener. Make sure that your LD_LIBRARY_PATH environment variable contains the following library directories: $ORACLE_HOME/lib $ORACLE_HOME/ctx/lib Then restart your SQL*Net listener. B. Check your tnsnames.ora file (usually in $ORACLE_HOME/network/admin), and look for something like: sid_list_listener=… (ENVS=LD_LIBRARY_PATH=/oracle/product/8.1.5/ct

0 CommentsAdd a Comment

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.