Get RMAN Login?
Oct 5, 2013
[ramanji@dbadmin dbs]$ rman catalog sys/oracle@orcl
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Oct 5 11:33:24 2013
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12545: Connect failed because target host or object does not exist
View 1 Replies
ADVERTISEMENT
May 15, 2013
I am trying to understand how to enable some audit so we can capture OEM logins as well.
Here is my setup. Lets say my DB that i am auditing is called audit_db (audit trail set to DB) sitting on host called host_db. and we have grid control agent on this box.now my grid control is as this. Lets say my OMS and repository is on host called OMS_host.
we run query aginst dba_audit_session to get info as to who tried failed login attemps and stuff.
Now to the part that is not working.
-- this is the good part When i intentionaly login to the audit_db with sqlplus client from my laptop with wrong username/password that is captured. we get the username,os_username,userhost,terminal.
here is the sample output
username is the wrong user that i tried to login as
os_username is the my local username(ad account)
userhost is my_laptop_name
terminal is laptop_name
from above we can figure who was trying to login(failed).
-- this is the bad part But lets say i try to login to audit_db through grid control and use wrong username/password.that gets captured too(but not all of it). we get the username,os_username,userhost,terminal.
here is the sample output
username is the wrong user that i tried to login as
os_username is the user of OMS repository db(oracle)
userhost is oms_host
terminal is unknown
Now with the above info, we cannot figure out who tried to login with bad login credential.
View 8 Replies
View Related
May 29, 2013
My oracle backup via Netbackup failing with error 6 (Netbackup) and i have checked the logs please find the RMAN log file as well.
Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:27:46 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0
[code]....
View 2 Replies
View Related
May 8, 2013
Given facts:
rman is used to backup database A to disk
rman is used to put those disk backups to tape
rman is used to duplicate database A to database B on another host
the duplicate process worked fine before we started testing encryption
the duplicate process worked fine with database A having an encrypted column in one table in a non-encrypted tablespace
Now, database A has an encrypted tablespace with nothing currently in it. The duplicate process now ultimately fails with ORA-19913, unable to decrypt backup.
I am not using encrypted backups, not specifying encrypt or decrypt anywhere in the duplication process. The only thing that is encrypted is the one tablespace in database A. I have the same wallet files on Host A (database A) and Host B (database B). Wallets are open. So why does the duplication process fail because the backup cannot be decrypted?
View 8 Replies
View Related
Mar 2, 2011
I am trying to login through front end application. I am getting the error login failed.
I tried to login from back end using same USERID and password. In the login page it's asking for EDUSERID and password. I tried to connect from backend to the database using same EDUSERID and password and it's working fine. But why from front end application I am unable to login.
View 2 Replies
View Related
May 28, 2012
How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".
Is it possible? If no, then what can be done to achieve below.
I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.
I am not sure whether this can be achieved or not.
View 2 Replies
View Related
Jun 9, 2011
I need to design my login form to be able to connect to different database environment (Env1 and Env2).When the login form is loaded it is already connected to Env1, after the user enters his login details he has option to continue with Env1 or connect to Env2.I used the "Logout;" to disconnect from already connected Env1 and used "Logon(<username>,<pwd>@<Db instance>);" but i see that the form will connect to Env1 irrespective of what environment credentials i provide in Logon. how i can disconnect from Env1 and connect to Env2. Is this possible?
View 2 Replies
View Related
Aug 23, 2011
I have laptop by this specification:
1) Operating System: Windows 7 64-bit
2) Virtual Machine: Windows XP Service Pack 3
3) DB: Oracle 11.2
4) Oracle Form Designer 4.5
i try to connect to SQL*PLUS 3.3 i got this error after defining in TNSNAMES.ORA in this folder c:orant networkadmin nsnames.ora
SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 18 19:49:12 2011
Copyright © 1982, 2010, Oracle. All rights reserved.
SQL> SHO USER
USER is ""
SQL> CONN SYSTEM@LOC
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
View 24 Replies
View Related
Mar 17, 2013
I am new to Oracle and I have just installed 11g on my 64-bit laptop and after downloading and installing SQL Developer I can nolonger log in using DBSNMP and my specified password both from SQL PLUS or Developer retaining this error message : ERROR: ORA-01033: ORACLE initialization or shutdown in progress.
View 1 Replies
View Related
Sep 16, 2011
How can i use OS authentication to login db?
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
sqlnet.ora text:
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1
View 18 Replies
View Related
May 5, 2013
I have a problem to login on my database 11.1.0.7 on linux 64. It were migrated from 9.2.0.4 and everything was fine but now I am not able to connect to database.
Only one way when I can connect is when the database is started in RESTRICTED mode and I cold login under sys (sysdba).
But when i leave this mode, nobody can connect . sqlplus is freeze and I have to kill that session. What could be a reason? Any parameters? It's strange for me because It was working..
View 12 Replies
View Related
Aug 1, 2012
I am not able to Login database , what should i do?
View 2 Replies
View Related
Sep 7, 2013
"C:UsersKarthikeyan>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sat Sep 7 17:42:37 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR:ORA-12560: TNS:protocol adapter error Enter user-name:"
this is the first time i tried to open sql*plus and i didn't create any database connection before....so i don't have any username and password.......
View 20 Replies
View Related
May 15, 2011
I tried to login and start my db this evening and I receive the following message
[oracle@dbs]$ export ORACLE_SID=ORCL
[oracle@ukedxdtmtdbs01a dbs]$ sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sat May 14 19:59:48 2011
Copyright © 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
How can I resolve - none of the passwords I enter seem to work? I have these init files
ls -ltr init*.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 18:53 init.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 19:12 initORCL.ora
my init.ora file looks like this:
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/adump'
audit_trail ='db'
[code]...
db had been up and running for about 2 weeks with no issues since installation..I am just trying to get the db up and running - nothing more
View 14 Replies
View Related
Jun 17, 2011
how to create a login form in forms 10g how upload login.fmb
View 2 Replies
View Related
Dec 1, 2010
I have a mainform through which one can access 3 different application(say a ,b,c)i have made three push buttons by clicking it the main menu of the respeective application is called.The three applcication have different users(user a,user b,userc)and have different database on the same version(db1,db2,db3 on 111g).I am using formservlet and i am calling the main form. configuration.I dont want the user to enter the username and password so i have hardcored it in formsweg.cfg file. my problem is that i login to the main form as 'user a' so i can access the application'a'.but now if i want to access applicatin 'b' how can i can i login as 'user b'?
View 6 Replies
View Related
Jun 12, 2011
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.
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=XE
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
View 12 Replies
View Related
Mar 15, 2011
How can we create a user such that he can login only at a particular time of the day . if he try's to login other than the Time assigned ,shouldn't allow.
Can we use oracle Security policy ?
View 5 Replies
View Related
Mar 11, 2013
I see we are unable to login to database using global database.
[oracle@sl73usircd01 ~]$ sqlplus DEMO@DB1.COM
SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 11 14:47:31 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: why we are unable to login to database using global database name ?
View 2 Replies
View Related
Oct 23, 2013
I have made few forms , but i want only those users to access these forms who have valid login and password to access these forms.
For example i have created one form employee details (shows the details of emp table in tabular form) which is based on emp table.
The users are scott having password tiger ,and User Test having password Test. i want to make a login form to give access to only these users to access employee tables. if someone else tries to access it then it should show Unauthorized login error.
My requirement is i want to create a basic login form which includes
Login i.e Text_item
Password i.e text_item
Login i.e push button
what should be the queries behind these items. and how to connect this form to database. I am attaching file , just add working codes in that or you can write codes here also .
View 25 Replies
View Related
Aug 23, 2010
I Am unable to login in SIM 12.0.
I did nothing in server.
Should i do anything in LDAP..?
SIM user name and password is stored in LDAP. Its also running...
View 5 Replies
View Related
May 18, 2010
We have oracle server 10g in my office, in which i need to login through isqlplus(through iexplorer) in my system. how to set it.
View 5 Replies
View Related
May 11, 2010
I'm trying to bypass the login screen for my apps by creating a .cfg file (ani.cfg) from the formsweb.cfg with two inclusions:
1.userid=<login_name>/<password>@database_connect
2. form=<my_form>.fmx (instead of default test.fmx)
Now while running the through /forms/frmservlet?config=ani
'm getting two things:
1.error message sometimes with a java file details list (attached)
2. it's openning the Java Security Warning window where on clicking 'Run' nothing happens.
View 3 Replies
View Related
Jun 10, 2013
I'm working on a client-server application that uses ODBC to connect Windows XP or Windows 7 PCs to an Oracle 11 database. I use a dedicated account to connect to Oracle, and I get the users Windows login name using the call shown in the title. I use the Windows login name to verify that they can access my application. I've been asked by security conscious folks in our IT department how this information is obtained
My question is: where does Oracle get the value of the users Windows login name? Is it coming from a windows registry key? Environment variable? I heard that it's possible that the ODBC driver is calling a Microsoft Win32 function like GetUserName or GetUserNameEx to retrieve the user ID.
View 1 Replies
View Related
Nov 15, 2011
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
[Code].....
View 3 Replies
View Related
Apr 3, 2013
I have a Oracle 91 database running on Windows 2003 with a DBLINK setup to connect to an external client. I'm looking at how i can setup a quick job that, say every 5 mins, runs a query over the DBLINK and if it returns data, then success. If it returns an error, then the DBLINK is down, moreso the external server, and then fire off an email to someone.
However, this DBLINK i think was created to be used by a specific username/password. When i try to run a query against it using SYS, i get invalid username/password error.
So is there a way i can use a DBLINK and specify the username/pwd to be used at runtime? I'm new to Oracle database..Something like 'select * from global_name@DBLINK1 as username/pwd'.
View 10 Replies
View Related
Jan 15, 2010
I just got a new widescreen monitor and i want my sql*plus output to fill the whole page. I added the 'linesize 999' to my login.sql file but the line length only goes 100 characters across. It doesnt matter what kind of query or function i run. Still only 100 characters across. what else can i be missing?
View 16 Replies
View Related
Feb 25, 2010
Creating Login Form In Oracle.
View 2 Replies
View Related
Mar 2, 2013
I installed oracle database 10g on my laptop, it installed successfully. I see sql plus in my program, how will i get login details for my database?
View 6 Replies
View Related
Oct 12, 2011
iSQL*Plus login for SYSDBA
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
View 1 Replies
View Related
