when i try to login to apex for first time (10.10.0.170:5555) it asked about server XDB username and password,i dont know which username and password i can use
View 4 Replies
I am using oracle 9i version. My problem is oracle window opens.But i can not login by typing the user name and password. while login an error is displayed as follows.
ORA-01033: ORACLE initialization or shutdown in progress.
I created a role,and it can not login,why?
session1:
SQL> Create Role con_role Identified By hxl;
Role created.
SQL> Grant Connect To con_role;
Grant succeeded.
SQL> Grant Create Session To con_role;
Grant succeeded.
session2:
sql>connect con_role/hxl@myserver ORA-01017: Invalid username/password.
11.2.0.1.0 g database.
I am trying for testing on test server where I am getting error while trying to connect
[URL].....
I am able to connect
[URL]........
and
[URL]......
The database version is 11g.
Actually my requirement is As I know we cannot use isqlplus in 11g we can use apex instead of isqlplus so any way or navigation how to use apex for isqlplus.
I have installed oracle 10g database in my pc and it works fine. I can connect with sys or system user.
I have also installed oracle forms 10g in the same pc. But when I try to connect then it shows the message:
ORA-01017 invalid username/password; login denied
So I can not connect. I have tried to connect with sys or system user.
I have two pages
1. Login Page contains two items
P1_LOGINNAME - Textfield
P1_PASSWORD - Password
2. Data entry form created using page items. - This page is used to create new users
This page contains many items but issue with only two items.
P10_LOGINNAME - Textfield
P10_PASSWORD - Password
These items are used for creating loginname and password for new user. When i am logging with admin user ,Chrome browser prompts for save password or not save password
1. When i am logging with save password option then
LOGINNAME and PASSWORD of Login page is reflecting on the LOGINNAME and PASSWORD of Data entry page.
so how can i clear the LOGINNAME and PASSWORD item on Data entry page after login.I have tried to set blank to these fields after login
document.getElementById('P10_LOGINNAME').value = '';
document.getElementById('P10_PASSWORD').value = '';
// This is working in Firefox but not in chrome.APEX Version : 4.1
Database : 10g
While doing export/import we specify the username and password. Preferably which user do we need to specify? Sys or system or our own user?
View 9 Replies View RelatedORA-00600: internal error code, arguments: [kcbchg1_11], [], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Current SQL statement for this session:
insert into sys.aud$( sessionid,entryid,statement,timestamp#, userid,userhost,terminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, new$owner,
new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,comment$text,spare1,spare2, priv$used,clientid, sessioncpu) values(:1,:2,:3,SYSDATE,:4,:5,:6,:7,:8
,:9, :10,:11,:12,:13,:14,:15,:16,:17, :18,:19,:20,:21,:22,:23,:24, :25)
For our customer we have build a custom login page. The form we currently made has de following items:
- Username
- Password
- Select list for selecting the task type
When the customer enters his username, automatically the select list of the task type will be refreshed to get only the task type where the customer has the rights to do it. This part works...It can occur that a customer has only one task type (which is default) then we want to hide the select list. This part doesn't work
We used APEX version 4.1.1.What we did is:
- One action item to refresh the selection list (works)
- One action item to hide the selection list by starting the application (works)
- One action item to show the selection list only when the selection list has more than one result. For this part we used the conditional part of the action item (Function returning a boolean).
In the query (inside the function) we want to use the entered username, looking into the application in the session state I saw the correct username, but for some reason the function cannot use this entered username, it becomes empty. When I use a hardcoded username the code works.
Why I cannot use a username into the conditional part of the Action Item.
APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error.
After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue??
I have an application that I'd like to prevent activity in after a certain time of day, say 3pm. Is there any way I can force logout of all current users and then prevent re-login until 9am the next day (short of deleting all of their login credentials and then recreating them the next morning)?
View 7 Replies View RelatedI Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Developers Suite apps?
Also What URL should i type to access the "iSQL *PLUS" through my browser, so that i can execute my SQL statements.
I already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:
sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1
So when i run this show me the message:
File 'c: este.rdf=%' not found.
It's showing a '=' sign
When reviewing failed login attempts with this query:
SELECT username, os_username, userhost, terminal, to_char(timestamp,'dd-mon-rrrr hh:mi:ss')
FROM sys.dba_audit_session
WHERE returncode != 0
and trunc(timestamp) >= trunc(sysdate-1)
ORDER BY 5
I find some records for a username that does not exist. In any of my databases. I presume that if an attempt to a nonexistent user was made, it would be rejected before it gets to the db. But then again, a bad password would also be rejected.
I've been creating numerous sample applications. In my latest one, I've been working on custom security schema and it's been working great for the most part. The one issue I'm having is passing login values into my application items. Though I don't receive any error messages or anything, upon checking the value of the application items via the session button, they never contain anything. The code I have in place on my login page is as follows:
begin
select username, user_id
into :F56_USER_NAME, :F56_USER_ID
from GS_USERS
where username = lower( rtrim( ltrim( :P101_USERNAME ) ) );
[code].........
The idea of the program below is to create a sql "module" (just a .sql file) that will loop and ask for a user id until the user enters the correct one. Here is the code I have thusfar:
set serveroutput on;
accept username prompt 'Enter user name here: ';
accept password prompt 'Enter password here: ';
declare
usernameCONFIRM VARCHAR(30);
passwordCONFIRM VARCHAR(30);
begin
select USERID into usernameCONFIRM from GAMEUSER where USERID = '&username';
[code]...
The main problem I'm seeing is that the two variables I ask for (username and password) aren't clearing out.
I migrated the report from Developer 2000. This report has the drill down report with the following command.
procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;
After Migration into Oracle Application Server 10g release 2 , I changed the code as following:
function U_1FormatTrigger return boolean is
begin
SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem
When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.
I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".
I just finish to install Oracle XE on Fedora 18 so when I try to Start SQL, I get this error.
[root@fedora ~]# sqlplus system
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 15 02:18:14 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password: ERROR: ORA-01017: invalid username/password; logon denied.
I have this code when i run this I get credentials error. How to give credentials .The authentication is set to windows in the https page. Means pop up will appear to get the credentials
declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
value varchar2(1024);
p_url varchar2(4000);
OPT varchar2(1000);
BEGIN
dbms_output.put_line('');
[code]....
how can i create procedure to check username and password.
View 10 Replies View RelatedCase 1,
-I have a Oracle Client 11.2.0.1 (*Administrator*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.
I configured tnsnames.ora for the client machine to connect my database testdb.If I use sqlplus to connect to the testdb from client machine, it's successful.However, If I use one of the jdbc connection string from the client machine, it reports "ORA-01017: invalid username/password; logon denied"
Case 2,
-I have a Oracle Client 11.2.0.1 (*Runtime*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.
I configured tnsnames.ora for the client machine to connect my database testdb.
-If I use sqlplus to connect to the testdb from client machine, it's successful.
-If I use one of the jdbc connection string from the client machine, it 's successful too.
For case 1 and case 2, the only difference is the Oracle client (one is Runtime, the other is administrator)The database I have is set to
SQL> show parameters case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
why the administrator client report ORA-01017?
I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.
View 6 Replies View RelatedI am not able to login in the database with sys user. when i am trying with sqlplus "/as sysdba" it is showing
ERROR: ORA-01031: insufficient privileges.
& when i am trying with sqlplus sys as sysdba it is showing
ERROR:ORA-01017: invalid username/password; logon denied.
I login with system user and changed the password of sys nd then tried login with sys but same result.
remote_login_passwordfile is set to NONE nd i am login through that user only by which i was always able to login.
I have a log-in problem. I created the new database and when I try to log-in with system user, its giving ORA-01017: invalid username/password; log-in denied, and when I try to log-in with "/ as sysdba" its successfully logged in.
When I try to change SYSTEM user password, I successful change and connecting and after few seconds when I try to connect its again giving same error "ORA-01017: invalid username/password; log-in denied
And I disable the case sensitive password also:
sec_case_sensitive_logon boolean FALSE
OS: windows
Oracle Versions: 11.2.0.1.0
I have a strange behavior with a Data Guard environment on Linux and Oracle 11.2.0.2. Since a couple of days, I have the following error in the alertlog of the standby database:
Errors in file /u00/app/oracle/diag/rdbms/SID_site2/SID/trace/SID_pr0f_22728.trc:ORA-17627: ORA-01017:
invalid username/password; logon deniedORA-17629: Cannot connect to the remote database server First I restarted the Apply on the standby without any changes.
So I tried to connect to the primary database from the standby server with Oracle .Net with success. In the other way, it's also working.I also tried to copy the password file from the primary server to the standby server and I restarted both the transport and the apply.The error is still happening on the standby but the most surprising is that the Data Guard is still fully synchronized. Why I get that error and what is the function of the process pr0f?
I have installed Oracle 10 galso changed the password of Scott,System users during installation via passwordmanagement. When I am click on sql plus icon to launch sql and entering user name : Scoot pwd :Tiger
It get closed and nothing is coming up.
After SSO Login to APEX Application it directs to Homepage by default,but i need it to direct to particular tab.
View 4 Replies View RelatedI am unable to login my Application Express with my username and password, It shows the below error/
Invalid Login Credentials
Application Express Login
Oracle Application Express is a rapid Web application development tool that lets you share data and create custom applications. Using only a Web browser and limited programming experience, you can develop and deploy powerful applications that are both fast and secure. Learn how to get started.
Workspace:
Username
Password
Reset Password
Login to Application Express
FacebookLinkedInTwitterGoogle+
This service is for demonstration purposes only. Use of this system to store sensitive data is prohibited.
Can we hide the username/password@dbname from hyperlink html, so that when ever we change our user password we should not change in each report calling from another report
View 1 Replies View RelatedI have an installation Oracle 11.2 RAC on Oracle Linux 5.5 on VirtualBox 3.2.8, Enterprise Manager Startup Log In does not recognize the SYSMAN username / password.
Log's (I changed // for /):
[oracle@rac1 log]$ tail -10 emagent.trc
2012-04-12 14:31:08,327 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:09,333 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
2012-04-12 14:32:09,335 Thread-1148807488 ERROR ssl: nzos_Handshake failed, ret=28862
2012-04-12 14:32:09,336 Thread-1148807488 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt
2012-04-12 14:32:09,338 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:39,777 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
[code]...
