Server Administration :: Login Failed In Oracle 11g
Jul 24, 2011
I have installed executable only (database option only) when i have installed oracle11 that time it is not asking any option for password. So is there any option to login in this type of condition?
database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?
When I run sqlplus and try to loging as system/<admin passwd> I get information:
ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Process ID: 0 Session ID: 0 Serial number: 0
I understand, that this is a common question and the common answer is don't have trailing slash in ORACLE_HOME and set ORACLE_SID. But I did this.
Step-1) Export the java path. [harsh@esparkinfo]$ export JAVA_HOME=$ORACLE_HOME/jdk
Step-2) Change the directory. [harsh@esparkinfo]$ cd $ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
Step-3) Run the JAZN prompt. [harsh@esparkinfo]$ $JAVA_HOME/bin/java -Djava.security.properties=$ORACLE_HOME/oc4j/j2ee/home/config/jazn.security.props -jar $ORACLE_HOME/oc4j/j2ee/home/jazn.jar -user "iSQL*Plus DBA/admin" -password welcome -shell
Step-4) Create user and grant the webDba role to the user. JAZN>adduser "iSQL*Plus DBA" username password JAZN>grantrole webDba "iSQL*Plus DBA" username JAZN>exit
Step-5) List the user. JAZN> listusers "iSQL*Plus DBA" Remove user. JAZN> remuser "iSQL*Plus DBA" username
[code]...
Step-6) Login through web browser. harsh.esparkinfo:5560/isqlplus/dba
I am using the below code to capture all important logs when user failed to login on database , but i cant capture the username which are failing to connect on database.
CREATE OR REPLACE TRIGGER failed_logon_notifications AFTER SERVERERROR ON DATABASE
I have installed Oracle in workgroup, while i workgroup it is working fine. But latter I have change the server from workgroup to domain. At that time Oracle was not working , not able to connect. After that I change the Domain to workgroup again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc
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 have a situation where when I login as a user to my DBvia sqlplus no service name it takes about 20 secs to connect.Yet when I login as a user with DBA privs it logs in immediately.
Is there something I can do to trace what is happneing behind scences to determine what the login delay may be..
I issued a SHUTDOWN IMMEDIATE command on my database and for over 2 hours and got no response. I did this because I wanted to restart the database due to many hanging sessions which had led to high CPU usage on the server by oracle process.
Oracle Service<dbname> instance using the Windows Services screen which failed with an error 1053 message. At the same time I got an ORA-01013 message saying user requested cancel of operation. See below:
SQL> SHUTDOWN IMMEDIATE ORA-01013: user requested cancel of current operation SQL> SHUTDOWN IMMEDIATE ORA-01089: immediate shutdown in progress - no operations are permitted SQL> SHUTDOWN ABORT ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist
What I want to know is how do I proceed? Also how do I check to see the status of the Shutdown operation?
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.
Enter user-name: sys as sysdba Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
i have successfully installed Oracle 10g in Windows 7 ultimate but there is one problem after installation of Oracle 10g an Oracle Enterprise Manager 10g have opened immediately after installation.
when i have sign in with username: sys passwd: oracle connect as: SYSDBA
iam getting this error message "Error java.lang.Exception: Exception in sending Request :: null"
& then when i click on "Administration" again the login page is opening.i have tried installing Oracle 10g 4 times this is 5th time .
When I am issuing below command from auxiliary database, getting ORA-00554.My tnsping is okay from both the side, remote login is exclusion. Password file is also okay.I ran UTLRP.sql twice to compile invalid packages.
From Auxiliary Database [ashish@localhost dbs]$ rman target sys/oracle@suman auxiliary / Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 11 19:04:03 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved.
From alert log, <msg time='2010-09-03T11:37:46.548+06:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='DC-DB-01' host_addr='192.168.100.101' module='' pid='24310'> <txt>Error 12160 received logging on to the standby
[code]...
From trace file,
[oracle@DC-DB-01 ~]$ less /u01/app/oracle/diag/rdbms/bddipdc/bddipdc1/trace/bddipdc1_arcq_24310.trc Redo shipping client performing standby login OCIServerAttach failed -1 .. Detailed OCI error val is 12160 and errmsg is 'ORA-12160: TNS:internal error: \ [code]...
i have install 0racle 9i its working fine .I can access data from launch standalone but when i tried with login to oracle management server i can't login .