For auditing, I need to insert the user, among other data, into different tables. The thing is, I have an application with DB account authentication, so a real database user is connected, when auditing, the user field inserted is "ANONYMOUS".
Apex 4.2
EPG
Oracle Enterprise Linux 5.5
Database 11.2 EE
I have registered an APEX (Oracle) online database and I can connect to database online.But my problem is how to define a connection string that can connect from the program written in C# to connect to APEX account(apex.oracle.com).I even don't know how to use the tool Oracle SQL Developer to connect to APEX account.
View 3 Replies View RelatedI have altered an user account and set the account status as expired.When I tried to connect with that user, oracle prompted for changing password.
But, after I changed the password, I got an error message as ora-01017 invalid username/password logon denied password unchangedWhat is the cause and solution for it? I am using 11g database and 10g client.
how can I connect a second database from another one?
Ex.My APEX application in a database instance DEVELOPER and I want to connect with tables in DEVELOPER_B instance.
how to find length of the user account password in a database?
View 1 Replies View RelatedHow to find out list of DB_LINKS that uses user account in database ?
View 9 Replies View RelatedI am trying to login to the web version of application express [URL]... and get a message that my login is incorrect. I have verified that the ID and workspace are correct, but I do not remember what i set my password to the first time i logged in (account was created by my instructor). There is no "forgot password" or "reset password" link that shows on the page.
View 0 Replies View RelatedI'm using Application Express 4.2.1.00.08
In the application, the authentication method used is the DB one, so the user (schema) must exist on the DB. This works fine.
For instance, I'm login as SCOTT
Creating the following query select upper(user) from dualshows that the real logged user is APEX_PUBLIC_USER and npot SCOTT.
How to create a connection with another "real" username ?
how to use APEX_ITEM.text for where the source for this comes from user input values and not for an underlying table.I have a report where three columns are coming from an actual table (one being a checkbox for selection) but then also have two additional fields on the screen that are not from a table but placeholder fields for user's to enter data.
For example, my query looks like this:
select apex_item.checkbox2(10,id),
name,
telephone,
apex_item.text(20,NULL) as "Date Contacted",
apex_item.textarea(30,NULL,5,80) as "Comment"
from my_table
I am not seeing any values for the two user fields when entering values and doing a view source?
I have a problem with a PCI DSS - requirement in Oracle 11.2. (PCI DSS = Payment Card Industry Data Security Standard)
Problem:
we connect via ' ssh -2 -X -l oracle hostname ' to the databaseserver and become os-user 'oracle'. we have also two offshore locations with dba's and each dba comes with his personalized user to the jumphost and then with the above ssh command to the database server.
the problem is that each dba becomes the oracle-os-account and can now connect with '/ as sysdba' to the database.in pci-dss this is not allowed !
now my question:how can I audit these '/ as sysdba'-connections and prove which user connected at which time with the '/ as sysdba' command ?
database is in audit mode. we log to syslog on linus redhat 5. I know one solution could be setting "SQLNET.AUTHENTICATION_SERVICES" parameter to "NONE" in sqlnet.ora file will make it not possible to connect to the database without a password as sysdba. (sqlplus / as sysdba). but we have to many applications and jobs and this is not really the solution in this case.
I think I can only solve this problem with personalized OS-user DBA-accounts in the dba-goup on os-site and os-user oracle should not be used for the future ?? I also need personalized dba-user-accounts in the database. using sys and system is not allowed. this users has to be locked and only for special administration work could it be unlocked.
I am experimenting with the 4.2 version of Apex at URL.....
I have created a tabular form (based on a view with an instead of trigger) and have restricted this form to "Update only" mode. Whenever I modify a field value and submit the change I get the error "Current version of data in database has changed since user initiated update process".
I am new in RAC scenario though i have some system to look after. I want to know, like single instance there is alert log,trace log where we should investigate to check if there is any problem. For RAC system which are the logs that i can find the monitor the incident or regular health checkup under grid and oracle user?
View 3 Replies View RelatedCan we change the condition of an item from always to none on the real time ? How ?
View 3 Replies View Relatedlast two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .
View 3 Replies View RelatedHow to migrate Oracle Standalone Database to Oracle Real Application Cluster?
View 1 Replies View RelatedI recently installed 2 node Oracle 11g RAC on RHEL5. While creating Clustered Database, database creation on second node (racnode2) failed. So, I connected */ as sysdba* on the node and executed startup only to get this error message:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RACDB_DATA/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RACDB_DATA/RACDB/spfileRACDB.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 13: Permission denied
Additional information: 196612
Additional information: 10
SQL>But, *'+RACDB_DATA/RACDB/spfileRACDB.ora'* is present.
I strongly believe it is a permission issue that ORACLE owned processes are not able to access disks owned by GRID user. I checked the permission of disks:
[oracle@racnode2 ~]$ cd /dev/oracleasm/disks
[oracle@racnode2 disks]$ ls -l
total 0
brw-rw---- 1 grid asmadmin 8, 65 Nov 19 19:15 CRSVOL1
brw-rw---- 1 grid asmadmin 8, 49 Nov 19 19:15 DATAVOL1
brw-rw---- 1 grid asmadmin 8, 81 Nov 19 19:15 FRAVOL1
[oracle@racnode2 disks]$And also, ORACLE user has asmdba among other privileges.
[oracle@racnode2 disks]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper) context=user_u:system_r:unconfined_t
I am willing to furnish further data.
Created user xyz on July 20,2013 with defualt profile (oracle version 11.2.0) and PASSWORD_LIFE_TIME is 180 for default profile. Immediate my friend have assigned new profile APSC to user xyz where profile APSC has PASSWORD_LIFE_TIME = UNLIMITED.
we surprised, user account has expired within a month. How user xyz account can expired within a month????
Note: User account status was open when account created and assigned to profile APSC.
"ALTER PROFILE profile_name LIMITPASSWORD_LOCK_TIME 1"means the user account will be locked in a period of one day after FAILED_LOGIN_ATTEMPTS has gone over limit.How to set PASSWORD_LOCK_TIME less or more than one day (like not full days)?
View 2 Replies View Relatedi am using 11.2.0.3.0 version db on Linux x86 64-bit...how to export the database statistics from Production to staging .
View 9 Replies View RelatedHow we know a user account locked time in HH:MM:SS format ?
View 1 Replies View Relatedwe have a prod application which use oracle database 11g as backend and .NET technology as front end . There is a user TESTUSER in database.
Issue is that we can login in to the application, but when we try to login in database through toad or Db visualizer then it gives an error of 'user account locked'.
I have 11gR2 GI installed on two nodes. I am trying to convert a 10g single instance (uses ASM) database to RAC and getting this error. I am trying using 12c as well as manually by using rconfig.
[main] [21:19:15:145] [ASMInstance.initialize:135] First record =[Ljava.lang.String;@958bb8
java.lang.NullPointerException
at oracle.sysman.assistants.rconfig.engine.ASMInstance.initialize(ASMInstance.java:153)
at oracle.sysman.assistants.rconfig.engine.Step.execute(Step.java:283)
[code]...
I've just instaledl APEX on Oracle 11g, with APEX listener 1.1, working fine at localhost. But I can't reach it from others computers on LAN. I searched several threads about this and thought I should run
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
But when I execute that, I got the message 'ORA-30952: illegal configuration of HTTP/HTTPS in xdbconfig.xml'.
When i try to change the user account password, i get following error.
alter user bala
identified by Ju4hlsd2;
ERROR at line 1:
ORA-20178: ORA-20176: ORA-28003: password verification for the specified password failed
ORA-20007: Password cannot consist of sequences of 3+ characters from the userid
how to set the password based on the error.
I created list of values like Bar chart,Column Chart,Pie Chart.these list of values added to the text field named as Chat type. In same region i created 3 chart sub regions. My requirement is if i select chart type-pie chart.the page will show only pie chart region only.Same to Bar chart and Column charts also.
View 3 Replies View RelatedI am trying to maintain data audit in the database using triggers where i want to write the row level trigger in an generic way using the following concept .Using USER_TAB_COLUMNS table inside the trigger i want to bind all column values of the row into a single string in the following format
COLUMN_NAME = Value(:new/:old.COLUMN_NAME)=> this value would be bound dynamically is it possible to create a string for each row instance in the trigger at run time using the above mentioned format and user_tab_column table
While browsing through the APEX, just wondering if there is any way to connect external database.
Like i have database connection string/user/password and service.
Is there any way to define these information in APEX to connect with external database?
I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express.
As I would like to
I use Oracle Net8 Easy Config to create a connection.
According to "tnsnames.ora", the parameter of connection is as follows;
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)
Unfortunately, when I use Oracle Net8 Easy Config to test the connection, an error message is prompted as follows:
Connecting....
The test did not succeed.
ORA-03106: fatal two-task communication protocol error
There may be an error in the fields entered or the server may not be ready for a connection. You can check the server and retry, or continue.
I would like to be aware of all select statements that are run against the schema I am responsible for (for performance analysis reasons) My privileges are restricted and I think I won't get access to any dba views.
So is there a recomondation how I can solve this requirement?
Can application connect with windows authentication to oracle 11.2.0.3 database? if so then how can i set it up!
View 3 Replies View Related