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 ?
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 RelatedWhen 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
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
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
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 RelatedI 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.
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.
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.
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 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
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.
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 RelatedHow 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
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.
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]....
I have a global index and I want to convert it to local index.Is there a way to recreate local index with out dropping the global index.
I can create a local index first and then drop the global index. But is there a way to create it with out dropping the global index, just convert it.
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?
There's an Application Express application which is based on a schema named TRAFOGLED. In order to let users test new features, there's a test application (Apex has export/import capabilities; no problem about that) which is based on another schema whose name is TRAFOTEST.
I'd like to export TRAFOGLED and import it into TRAFOTEST.I'm using 10gR2 EXPDP utility with a parameter file. Everything seems to be OK, except the fact that I'm unable to export global temporary tables (GTT). How can I tell? I didn't see them after import!
These are my GTTs:
SQL> show user
USER is "TRAFOGLED"
SQL>
SQL> select table_name from user_tables where temporary = 'Y';
[code]...
C:TEMP>
No tables were exported. Certainly, I don't expect any data to be exported, but I'd be happy with CREATE TABLE statements so that I don't have to create these tables separately.
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 .
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.
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 .
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 Relatedi'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.
Explain about Global variables in Plsql? What is use of these global variables and where do use these variables?
View 1 Replies View RelatedMy 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 ?
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."
When I installed Oracle 11.g I set 'GlobalDataBaseName' ("orcl.net").SID was "orcl". from where can I invoke 'GlobalDataBaseName' value ?
View 1 Replies View RelatedI have two database DB1 for EBS database and DB2 for Portal database. DB2 is always up.
DB1 uses some Global Temporary tables to write and store session level information.
I have Secondary database also for DB1. Whenever DB1 is down and its secondary database base is up, my requirement is to enable write operation to these Global Temporary Tables. Since secondary database we open Read-Only mode , I can't write to these GTTs.
DB2 is always up so I want to create the copies of these GTTs in DB2 portal database. Is there any harm on doing this.
Is there any harm storing session level information of DB1 database In DB2 database through DB-Link.