Server Administration :: Access To Database Server Machine Login?
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
ADVERTISEMENT
Dec 7, 2010
I am trying to upload a database backup on a machine. Since the structure of files is different from server, how can i start the database.
Do i need to create a new control file? If yes, how can i run the sql command "Alter database backup controlfile to trace" in nomount mode.
View 3 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
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
May 25, 2010
We have quite a number of sessions in database MES (production) coming from another machine.
From v$session, the program is oracle@WID27 (TNS V1-V3). This WID27 (hostname) consists of quite a number of development databases inside. We have to trace which jobs are actually triggering this, as WID27 are not suppose to connect to production databases.
How can we tell whether the sessions came in is from dblink or from the machine itself?
View 3 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
Apr 5, 2010
I am facing a strange issue on 11gR2 (OEL 5.4) standby readonly with apply database.It's throwing 16000: database open for read-only access during SELECT's .
Here is snapshot of errors.
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
SQL> l
1* SELECT t0.airportID, t0.archived, t0.assetTag, t0.bluetoothID, t0.cmBundle, t0.createdDate,
t0.currentProductTaskID, t0.ethernetID, t0.failOrReworkCount, t0.highestCompletedTaskTypeID, t0.lastModDate, t0.lastStationID,
t0.modCount, t0.modelID, t0.oemSerialNumber, t0.orgSerialNumber, t0.pdmVersion, t0.preburnComplete,
t0.productID, t0.reworked, t0.secondaryEthernetID,
t0.serialNumber, t0.shipped, t0.specialBuildTypeID,
[code]....
View 7 Replies
View Related
Oct 12, 2012
How to access Active directory(Microsoft 2003) with oracle database 11g.
View 1 Replies
View Related
May 21, 2010
We have created a new db link. But we are not able access the remote database. When we are trying to access any table using db link system is getting hanged.
We would like to know what are the parameters/permissions which affect the db link access either at data base level or at server level.
One observation we made is that that particular db link is not getting dropped when we tried to drop it.
View 2 Replies
View Related
Sep 21, 2010
I have installed oracle 11g Release 11.1.0.1 on windows server 2008.I access this server from a client machine running on winXP through SQL PLUS. I wanted to shutdown and start DB server from this client machine. Accordingly i issued shutdown immediate command from SQLPLUS.
Now when i tried to start the DB with "STARTUP NOMOUNT" command i received error 12514. I understand this error means that the listener received a request to establish connections to a database but since DB services are not up and running, hence the error. So my first question is how do I resolve this error.
Continuing further, i tried to re-connect to the database as sys, and i received another error ORA-01041. So, my second question is why did i receive this error and again how can i resolve it
may be you can point me to relevant reference in Oracle documentation) how can i start and stop oracle from a client machine using SQL interface in CLI mode and windows environment and avoid this error.
View 12 Replies
View Related
Mar 16, 2011
can we have multiple database version running in a single machine with multiple instances provided there are enough resources.Can we do in RAC only?
View 15 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
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
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
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
Apr 26, 2012
I have already installed oracle 10g version in my Desktop. Now i want to install APPLICATION SERVER 10g version.
Should I Un install the Normal Database.
Or else can I have both in a single machine.
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
Jul 19, 2012
Send me the procedure for cloning a database on the same machine / server .
View 1 Replies
View Related
Jul 14, 2011
I'm currently working on a project in which I do not have permissions to access the Server where the database is installed and configure.Because of company policies, I do not have Admin Rights over Oracle, but I do have an account that can make Selects to DBA_USER_PRIVS for instance.
I would like to know if there is any way to access the database logs to know if there was any kind of problem within the database, because one of my Schemas misteriously went clean (all tables, sequences, triggers, ... vanished)
View 4 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
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
Mar 26, 2013
I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?
View 2 Replies
View Related
Sep 14, 2010
I need to create one to many user DB link in oracle 10g. Meaning I have a user A in database 1 and I want to access the objects from user B,C,D in database 2, how to create a public database link so that i can have this one to many user access?
View 8 Replies
View Related
Oct 11, 2011
is it possible to track the last access to a table?
View 2 Replies
View Related
Sep 3, 2013
I have login through the sysdba and created dblink and modified the tnsnames.ora for necessary changes. And the it started working correctly and I can able to get the data by selecting it.But when I login with different user that is showing the following error.
ORA-12154: TNS:could not resolve the connect identifier specified
How to resolve this,is there any privileges or permission need to give to that user.
View 5 Replies
View Related