Server Administration :: ISQLPlus Login For DBA?
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
ADVERTISEMENT
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
Apr 30, 2012
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 ?
View 9 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 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
Aug 31, 2010
When I am trying to login to the oracle server I am getting an error message:
Enter user-name: / as sysdba
ERROR:
ORA-12638: Credential retrieval failed
View 4 Replies
View Related
Oct 15, 2011
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
View 7 Replies
View Related
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?
I am using this on windows server 2003.
View 15 Replies
View Related
Sep 27, 2011
I just create a user and tried to log in but it gives the following error, why?
SQL*Plus: Release 10.1.0.4.2 - Production on Tue Sep 27 10:57:55 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> create user user1 identified by user1;
User created.
SQL> conn user1
Enter password: *****
ERROR:
ORA-12560: TNS:protocol adapter error
Warning: You are no longer connected to ORACLE.
View 26 Replies
View Related
Aug 25, 2011
I can login to my database using SQL>sqlplus sys/sys as sysdba
but it doesnot work when i do
SQL>sqlplus sys/sys@nocdb as sysdba
ERROR:
ORA-12518: TNS:listener could not hand off client connection
my tnsnames.ora looks like this
NOCDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Abhishek-PC)(PORT = 1522))
[code]....
is this (PORT=54460) causing the problems...i think it should read 1522 as in my listener.ora.
View 1 Replies
View Related
Jul 15, 2010
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.
View 8 Replies
View Related
Mar 2, 2012
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..
View 9 Replies
View Related
May 15, 2012
I have installed oracle 10g server (10.2.0) standard. My OS is win xp sp-2.
when I run sqlplus or toad, Error Message comes ORA-01033: ORACLE initialization or shutdown in progress.
I have done below steps
in command prompt: C:sqlplus/nolog
sql:> connect system/admin (this is my database username/pass)
Error
ORA-01033: ORACLE initialization or shutdown in progress
sql:> shutdown immediate
not connected
database closed
notconnected
database dismounted
ORA-01012 not logged on
sql:> Startup
01031: insufficient privilegs
not success. till error message comes
View 5 Replies
View Related
Apr 11, 2007
I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?
View 12 Replies
View Related
Jan 3, 2012
From metalink: Note 215187.1...Im trying to install SQLT. The installation process ask for:
Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key
I have tried with SID (@TESTDB) and SERVICE NAME (@TESTDB.mydomain.local) and leaving it blank, nothing works. I cant connect as SQLTXPLAIN.
View 5 Replies
View Related
Aug 24, 2010
how can I find out the number of login attempts made by a user in the database and the timings of the attempt
View 1 Replies
View Related
Sep 5, 2011
How we can resolve :
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
View 15 Replies
View Related
Oct 9, 2011
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.
View 12 Replies
View Related
Aug 20, 2010
My database was working fine and now I am not able to login and getting the error:-
"ORA-01033: ORACLE initialization or shutdown in progress"
I have done the below steps:
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORA-32004: obsolete and/or deprecated parameter(s) specified
[code]....
View 10 Replies
View Related
Nov 15, 2010
I created an externally authenticated user in database. And can login without password with below syntax.
SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"
This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.
connect scott[proxy_user]/password_for_scott@TESTDB
So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?
View 10 Replies
View Related
Mar 20, 2011
I'm having some trouble with iSQL*Plus.I instaled oracle database and at first it worked fine, but then I installed client on the same maschine and all products that come with client, and somewhere in the meantime iSQL*Plus stopped working.
Then I uninstalled client and products that go with him (Policy Manager, Oracle Wallet...) because I thought that they have "broken" iSQL*Plus, but it still doesn't work. Finally, I re-installed iSQL*Plus, but that didn't work either. Interesting thing is that when I type in command line
" c:/miljana/bin/isqlplusctl start "
it says that iSQLPlus is started, but when I go to browser there is an error:
" Firefox can't establish a connection to the server at miljana.localhost.com:5560. "
Also from Administrative tools/Services if a try to start iSQL*Plus there is an error:
" Could not start the OracleOraDb10g_home1iSQL*Plus service on Local Computer.
Error 1067: The process terminated unexpectedly. "
I know that there is a lot of topics for this, but most of solutions where for Linux, and didn't work for me.I'm using Oracle 10g Enterprise Edition on WindowsXP
View 1 Replies
View Related
Feb 22, 2013
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 .
View 3 Replies
View Related
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
Aug 1, 2008
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 .
how can login with oracle management server .
View 1 Replies
View Related
Sep 23, 2010
I have an Oracle server on CentOS 5.4, I can visit isqlplus on server, but I can't visit isqlplus on a windows client. ping works between server and client. I remember client doesn't need to install software via isqlplus, but I am not pretty sure.
View 2 Replies
View Related
Aug 27, 2012
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
View Related
Nov 29, 2010
i'm a student currently learning database administration security.
I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.
I have attached the schema that was given to me for this assignment.
View 12 Replies
View Related
Apr 8, 2010
My manager is asking to create a SQL scrip, which will provide following information.
Our database is 9.2.0.7.0 on Windows 2000 Server
-How many records Insert / Update or Delete daily in my Oracle database?
- Check Archive log / Redo Log switching information?
-Check database growth ?
View 10 Replies
View Related
Jan 11, 2011
i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
View 1 Replies
View Related
Jun 27, 2012
I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).
All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.
View 3 Replies
View Related