SQL & PL/SQL :: How To Connect As Manager

Feb 18, 2011

I want access to the Oracle as manager. What is the user name and password. I tried:

Username: system
Password: manager

But it gives an error. I work on oracle 11g

View 3 Replies


ADVERTISEMENT

Enterprise Manager :: Unable To Connect To Enterprise Manager Console?

Dec 20, 2010

i have already give the grant option cnnect,resource to scott but it is not connecting to enter prise manager console of Oracle database 11gR1. i am getting this error while connecting "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information"

when i am giving scott the dba rights then it is connecting. but i cann't give dba rights to scott.so, how/what is the specific command to give permission scott for connecting to enter prise manager console.

View 1 Replies View Related

Enterprise Manager :: Connect To Database Through 9i

Nov 17, 2012

I have intsalled oracle client 9i.I add my services into tnsnames.ora .I could connect in sqlplus but in Enterprise manager i receive error ora12154 tns could not resolve service name!

View 4 Replies View Related

Oracle Enterprise Manager Connect Multiple DB?

Jul 16, 2008

Is that possible to make Oracle Enterprise Manager of 10gr2 connect to multiple oracle database?

View 1 Replies View Related

Enterprise Manager :: Connect To Database Through Web Browser?

Nov 11, 2011

I am Not able to connect to the Database through the web Browser,

I have started Listener, EM, and i have checked the port number is in Listen mode all is working but not connecting to the EM through web browser.

View 8 Replies View Related

Enterprise Manager :: Failed To Connect To Database Instance

Oct 27, 2011

When login i'm getting error : Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin).

I have checked DBCONSOLE & AGENT are running properly.

litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv
litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

[code].....

View 10 Replies View Related

RAC & Failsafe :: ORA-29701 / Unable To Connect To Cluster Manager

Aug 8, 2011

when i'm creating ASM instance, i'm getting an error

Quote:ora-29701: unable to connect to cluster manager

for this there were some workaround given to start css.

i tried everything from /etc/init.d/init.cssd start/enable but nothing worked, then i tried with executing

localconfig delete
localconfig add====>it failed and recommended to go for reset option

when i executed localconfig reset i get this following error:

Quote:
[root@rac2 bin]# sh localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

[code]....

This is the same case when i used reset option.

View 3 Replies View Related

Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer

Jul 7, 2012

I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....

sqlplus username/password@IPAddress:port/ServiceName

I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.

View 3 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

Enterprise Manager :: Config - Enter Price Manager Grid Control For All DB

Feb 8, 2010

we have 5 database servers in different locations,

1.main database 10g(production) ip-192.1.1.1
2.standby for production 10g ip- 192.1.1.2

both are linux

3.another database 10g windows
4. another database 9i windows

both are in same location

5.new database 10g in linux ip-192.1.1.3
some other location
i m having a system windows xp installed
i m monitoring, all 10g by oracle enterpric manager
linux os monitor by Putty software

and i m monitoring below 10g database by sqlplus. now how could i monitor all the database by oracle enterprise manager grid control installed in my system that windows OS installed.

View 4 Replies View Related

Enterprise Manager :: Configure Enterprise Manager In Windows 2003 Server?

Aug 21, 2010

I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...

View 1 Replies View Related

Enterprise Manager :: Oracle Enterprise Manager Communication Error?

Feb 2, 2010

We have the Oracle Enterprise Manager Grid Control 10.2.0.5. We recently upgraded our Databases from 10.2.0.3 to 10.2.0.4 and since then we are having this problem.

Whenever i click an Agent on the Grid Control it gives me this error: "Communication between the Oracle Management Service host to the Agent host is unavailable. Any functions or displayed information requiring this communication link will be unavailable. For example: deleting/configuring/adding targets, uploading metric data, or displaying Agent home page information such as Agent to Management Service Response Time (ms)."

I get the same error when i try to configure a host or a database.

Don't know what is wrong

View 4 Replies View Related

Enterprise Manager :: How To Start Enterprise Manager On Windows 7

Mar 21, 2013

How to start EM on windows 7?

View 3 Replies View Related

Enterprise Manager :: Can't Open Enterprise Manager

May 11, 2011

i have change my database name successful but after that when i open my enterprise manager i can open it but i cannot do anything in enterprise manager . i cannot show any tabs there.. i have attached my this enterprise manager login page here

View 12 Replies View Related

How To Connect Toad With 10g

Jan 9, 2010

i have installed oracle 10g and toad but i don't know how to connect toad with database

View 1 Replies View Related

Can't Connect Through TOAD

Oct 9, 2012

I am Using Toad 9.3 and try to connect Oracle DB 11g through SYS but fail, because it is showing ORA-01031:Insufficient privileges.Although the same, I can connect through SQL * Plus. Is there any way to connect SYS (in TOAD).

View 1 Replies View Related

Can Connect From Database 1 To 3

Nov 10, 2011

For example, I have 3 database, database 1 and database 2 connect together by database link db_link1, database 2 and database 3 connect together by database link db_link2.

I want to ask: Can I connect from database 1 to database 3 ? ( Of course don't use database link between database 1 and 3, just use database db_link1 and db_link2 )

Both db_link1 and db_link2 are public database link.

Can I restrict user access by 2 these public database link ?

View 1 Replies View Related

Cannot Connect After Install

Nov 1, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files.

tnsnames.ora
CODEXE =
(DESCRIPTION =

[Code]....

View 1 Replies View Related

Connect To 10g After Patch Set 3

Mar 24, 2011

Had 10.2.0.3 on Win Server 2003 and ran patch set 3. Now have 10.2.0.4 but cannot login. Here is what I get along with other info.
-------
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 24 14:27:31 2011
Copyright © 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
--------
My listener service is running. Listener.ora is:
---------
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = W2K3-TX-ORA)(PORT = 1521))
)
)
-----------
Running TNSPING:

C:\oracle\product\10.2.0\db_1\network\ADMIN>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 24-MAR-2011 14:35:35
Copyright © 1997, 2007, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = W2K3-TX-ORA)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= ORCL)))
OK (60 msec)

View 3 Replies View Related

Oracle Connect By?

Nov 26, 2012

I've stucked with a query. Let me explain the situation: I have a table that i store the IDs of logically equal records.

For example;
A = B
B = C
X = Y
Z = Y

My query must return all equivalent records. If you call the query with parameter 'A', the result set must contain B and C. And if you call the query with parameter 'Y', the result set will contain X AND Z. I have thought that i can write the query wity using start with connect by statement. But the query does not work as i expected. Here is my code and sample data:

create table temptable (ID1 number,ID2 number);/
insert into temptable values(11,12);/
insert into temptable values(12,13);/
insert into temptable values(13,14);/
insert into temptable values(13,15);/

SELECT distinct ID1 from
(
SELECT * FROM temptable
START WITH ID1 = 13 OR ID2 = 13
CONNECT BY NOCYCLE

[code]...

In my sample the equality definitions is;
11 = 12
12 = 13
13 = 14
13 = 15

When i call the query with parameter 13, i'm expecting to get 11,12,14,15. But it returns only 12,14 and 15.

View 4 Replies View Related

SQL & PL/SQL :: Connect By And Rollups

Feb 10, 2011

I am trying to rollup a measure of a fact for a hierarchical dimension. The 2 entities - Dimension and the fact are described as below

Dimension Table - This maintains the hierarchical structure of the dimension in a parent child relationship format

DROP TABLE tmpDimension;

CREATE TABLE tmpDimension
(
DimValVARCHAR2 (20),
ParentDimValVARCHAR2 (20)
);
[code]...

Also, is there a way to make the group By levels dynamic. I cheated my way through by using a substr which makes it very depenent on 1 letter dimVal values

View 5 Replies View Related

User Is Not Able To Connect?

Mar 6, 2013

created one user and granted connect, resource.

SQL> create user xyz identified by welcome123;

but while connecting to that user it's not connecting. saying

SQL> conn xyz/welcome123
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL>

but i am sure i create user.i though to drop and recreate that user. But it is saying connected user can't be drop.then i checked for the connected session of xyz user. but shocked, there is no session for xyz user.

View 7 Replies View Related

Unable To Connect DB From LAN PC?

Mar 12, 2013

I hv no problem connecting oracle at localhost. but when connecting using another pc on the same LAN, the sqldeveloper returned an error saying

IO Error: The Network Adapter could not establish the connection on the linux where oracle installed, iptables is disable, but firewalld is enabled, so I did a

'firewall-cmd permanent zone=home --add-port=1521/tcp'

yet the remote pc still prompt the same IO error. what should I do to have oracle accept connection from the LAN and WAN ( I hv setup virtual server on router)

View 12 Replies View Related

ORA-257 Not Able To Connect To Database?

Feb 11, 2013

I am not able to connect to database due to ORA-257. So manually i deleted the archivelog files in diskgroup. however it is showing 13gb free space after deletiion. Archive log files generated due to Import job is running.

In below ways i have tried to connect to database.

1) Through SQLPLUS (Not able to Connect)
2) Through RMAN i tried to connect (Not able to connect)
3) I tried to connect impdp to stop the running job. It was also failed

View 7 Replies View Related

Not Able To Connect From Client Machine

Dec 23, 2010

I have installed oracle 10g on Red Hat Linux and I am able to connect as well.The listener and DB is up and running and I am able to coonect as well from the server.

But I have installed the oracle client (TOAD) on some windows machine and from there I am not able to connect . I am directly connecting by giving IP and other details and using TNS as well but I am not able to connect from client machine. I am getting ORA 12170 - TNS timeout error.

[root@rhel1 admin]# sqlplus system/system@db102
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 23 11:16:04 2010
Copyright © 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL>

View 1 Replies View Related

How To Connect To SQL Database Server

Feb 23, 2009

I do not know how to create a connection between oracle to SQL server using topology manager on my application. I understand that I must create a logical and physical architecture to create the connection and the logical and physical architecture is running under topology manager.

View 1 Replies View Related

Connect To DB On Virtual Box Using Toad?

Sep 27, 2013

Im getting this error when trying to connect toad to my test database using virtualbox. This is my first time trying to do this on a Mac as well:

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

The settings in toad are correct as far as host, port #, and sid. My listener is up, and it is registered with the database. My tnsnames.ora file is correct. No firewall. I can ping my virtualbox from my local machine. I placed my tnsnames.ora file on my local machine, and tried to connect that way as well. I have no clue what else the Network adapter is looking for.

View 1 Replies View Related

Unable To Connect To Sql Server From 11g?

Jun 21, 2012

When we tried to query a data from the sql server we are getting the below generic error message i

SQL> select * from all_users@testing
2 /
select * from all_users@testlink1
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from TESTLINK1

below are the details setup / configuration done by us:

os :windows 2008 server.
database "oracle standard edition
Command Line input /output:
C:\Users\aorenstein>C:\oracle\product\11.2.0\db_1\bin\dg4odbc
Oracle Corporation --- WEDNESDAY JUN 20 2012 10:20:54.308
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
Oracle Database Gateway for ODBC

[code]....

View 1 Replies View Related

SQL & PL/SQL :: Connect 2 DB Schemes At Same Time?

Sep 25, 2011

Is it possible to connect 2 database schemes at the same time? I want to update a table from one scheme to another with the following update statement.

Update scheme1.table Set (col1, col2, col3, col4) = (select col1, col2, col3, col4 from scheme2.table);

If there is a way of doing this, I want to do this in some procedure?

View 22 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved