oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleExcep

oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleExcep

   

 

Cause : 

Each Weblogic Domain requires a separate OPSS schema and it can not be re-used or shared with other different Domains. As there is other domain on the same server which is using the OPSS Schema, the domain configuration failed.

Solution : 

In this case I was use same sys password for RCU and Domain creation . But When I change domain password and OPSS schema that time

oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleExcep

Not come and successfully I have installed oracle 12c web application.

 




 

oracle forms 10g configuration

Installation oracle dev suitehome_1 (oracle developer suite 10)

After successfully installed then configure some file

11      Open default.env file from location

22       G:/devsuitehome_1 /forms/server/default.env

33      Formsweb.cfg

44     Install java jre-6u45-windows-i586.exe

55     Run jinit file

66     Open forms builder and go edit and preference put browse address

77     baseHTMLjinitiator=basejini.htm

88     #baseHTMLjinitiator=basejpi.htm <<<<<<<<<<<<

99 basejini.htm  replace  basejpi.htm

ORA-00054: resource busy and acquire with NOWAIT specified

Resource busy and acquire with NOWAIT specified :ORA-00054

You can also look up the sql,username,machine,port information and get to the actual process which holds the connection

first select the busy session and then kill the busy session with below query

SELECT
    O.OBJECT_NAME,
    S.SID,
    S.SERIAL#,
    P.SPID,
    S.PROGRAM,
    SQ.SQL_FULLTEXT,
    S.LOGON_TIME
FROM
    V$LOCKED_OBJECT L,
    DBA_OBJECTS O,
    V$SESSION S,
    V$PROCESS P,
    V$SQL SQ
WHERE
    L.OBJECT_ID = O.OBJECT_ID
    AND L.SESSION_ID = S.SID
    AND S.PADDR = P.ADDR
    AND S.SQL_ADDRESS = SQ.ADDRESS
   
    alter system kill session 'SID,SERIAL#';
   
    alter system kill session '378,11329'
    alter system kill session '19,13583'

ORA-01031: insufficient privileges when Toad 11.6 connect to an Oracle 12c database

ORA-01031 When Connecting To 12c Database With Toad

When attempting to connect via Toad 11.6 to an Oracle 12c database, create any table, create any script, show any view, any scritp that time  toad application  through very annoying message “ORA-01031: insufficient privileges”

For any kind of change in database give

 ORA-01031: insufficient privileges

clicking  “OK ” in Toad, it looks  to connect to the database but not working anything  . just come a screen and still nothing show  

The ora-error code ORA-01031   only happens when using Toad 11.6 version . It does not occur in SQL*Plus, oracle SQL Developer or any other versions of Toad.

Solution

Access to SYS.USER$ has been restricted in Oracle 12c (for oracle 12c  security , role, privilege, references doc  https://docs.oracle.com/database/121/DBSEG/E48135-19.pdf)

The issue can be resolved by granting access to the SYS.USER$ table to the related user /schemas:

GRANT SELECT ON SYS.USER$ TO <user>;

For grant the privilege login as sys dba

Sqlplus sys/sys_password@orcl  as sysdba

SQL> GRANT SELECT ON SYS.USER$ TO <user_name>;

Grant succeeded.

Reference Oracle Doc ID 1958777.1)

ORA-22858: invalid alteration of datatype

 SQL> set define offSQL> ALTER TABLE PMIS.RM_WRITTEN_EXAM_SCHEDULE
MODIFY(ADMIT_CARD_CONDITION NCLOB)ALTER TABLE PMIS.RM_WRITTEN_EXAM_SCHEDULE
MODIFY(ADMIT_CARD_CONDITION NCLOB)
Error at line 3
ORA-22858: invalid alteration of datatype
Script Terminated on line 3.


Solution:  Just create a new field with desire data type and then alter the table to copy old field value and then drop the old field and then rename new field with old field .


ORA-22858: invalid alteration of datatype Solution.


ALTER TABLE RM_WRITTEN_EXAM_SCHEDULE ADD (NEW_1 NCLOB);
UPDATE RM_WRITTEN_EXAM_SCHEDULE SET NEW_1 = OLD_1;
ALTER TABLE RM_WRITTEN_EXAM_SCHEDULE DROP COLUMN OLD_1;
ALTER TABLE RM_WRITTEN_EXAM_SCHEDULE RENAME COLUMN NEW_1 TO OLD_1;




ALTER TABLE RM_WRITTEN_EXAM_SCHEDULE ADD (ADMIT_CARD_CONDITION_1 NCLOB);
UPDATE RM_WRITTEN_EXAM_SCHEDULE SET ADMIT_CARD_CONDITION_1 = ADMIT_CARD_CONDITION;
ALTER TABLE RM_WRITTEN_EXAM_SCHEDULE DROP COLUMN ADMIT_CARD_CONDITION;
ALTER TABLE RM_WRITTEN_EXAM_SCHEDULE RENAME COLUMN ADMIT_CARD_CONDITION_1 TO ADMIT_CARD_CONDITION;

how to write bangla in oracle 12c weblogic database on windows10

ORACLE BANGLA FONT SET UP FOR WINDOWS 10

1.DOWNLOAD SolaimanLipi.ttf
download url:https://www.omicronlab.com/bangla-fonts.html
2.Install SolaimanLipi.ttf
3. go to windows c and [search fonts]
    C> write Fonts [pest solaimanlipi.ttf]
   
4.C:\Program Files (x86)\Java\jre1.8.0_144\lib\fonts
SolaimanLipi.ttf

If JDK same as jre
C:\Program Files (x86)\Java\jdk1.8.0_144\jre\lib\fonts
SolaimanLipi.ttf

5.  E> Oracle > [search registry.dat]
E:\app\oracle\config\domains\frm\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\oracle\forms\registry
default.fontMap.defaultFontname=[SolaimanLipi]
default.fontMap.defaultSize=900
default.fontMap.defaultStyle=PLAIN
default.fontMap.defaultWeight=PLAIN


default.fontMap.appFontnames=Courier New,Courier,courier,System,Terminal,Fixed,Fixedsys,Times,Times New Roman,MS Sans Serif,Arial,Vrinda,SolaimanLipi
default.fontMap.javaFontnames=MonoSpaced,MonoSpaced,MonoSpaced,Dialog,MonoSpaced,Dialog,Dialog,Serif,Serif,Dialog,SansSerif,SolaimanLipi

write end of line , solaimanlipi


For Report Configuration

E:\app\oracle\config\domains\frm\config\fmwconfig\components\ReportsToolsComponent\reptools1\tools\COMMON

uifont.ali



Go to Oracle folder and search [fonts]
pset solaimanlipi all fonts folder.
E:\app\oracle\product\12.1.0\dbhome_1\javavm\lib\fonts
Pest SolaimanLipi font

E:\app\oracle\product\12.1.0\dbhome_1\jdk\jre\lib\fonts
E:\app\oracle\product\Mid_home\oracle_common\rda\da\public_html\ui\fonts
E:\app\oracle\product\Mid_home\oracle_common\jdk\jre\lib\fonts

E:\app\oracle\config\domains\frm\reports\fonts
E:\app\oracle\JDK\jre\lib\fonts


Run >regedit

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
search NLS_LANG
ALL PLACE CHANGE UTF8 [ASIAN LNS_LANG MODEL ULT32UTG IS USED FOR EUPOR, AMERICA UNICODE FONT , FOR ASIAN FONT UTF8]

jUST replace[AMERICAN_AMERICA.UTF8] all oracle LNS_LANG

UDE-12560: operation generated ORACLE error 12560 ORA-12560: TNS:protocol adapter error

When I export from my oracle 12c database i got
 UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error


I set everything  on my windows machine.

from command promp(CMD)
C:> set ORACLE_SID=ORCL
C:> loging sqlplus /nolog

sql> conn sys / as sysdba
UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error

But found getting this error.

Solution for this error:
UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error


Solution: LSNRCTL FROM COMMAND PROMPT


C:>set oracle_sid=ORCL
C:> LSNRCTL
 
LSNRCTL> status
LSNRCTL> stop
LSNRCTL> start


Go windows machine services:

restart oracle services
restart tns services.

Then I ran again expdp command and chill
Now  below error vanish!!!!
UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error