Oracle DBA Corner

What i can think about is that you're having compatibility issues. If i remember correctly IE8 came out not long ago. And i doubt if Oracle has completely tested it to CERTIFY it for use with e-Business Suite or even with basic Oracle Forms. These things from experience take time. You may want to check/confirm from Metalink on Oracle website to see if e-Business is CERTIFIED for IE8. A temporary solution until IE8 is certified is to downgrade to IE7 which i believe is certified for e-Business Suite. Dont know about Mozilla but i believe it could be the same compatibility issue. Check Metalink for the compatibility matrix.

I guess you're on windows. First download the IE7 installer. As well as the Mozilla installer. Then go to programs and totally uninstall your IE and mozilla. Reboot your system to ensure these have been cleanly uninstalled. The once your system comes up verify from the list of installed programs that you do not have IE7 and Mozilla.
Then using the installers of IE7 and Mozilla you downloaded, reinstall these and you should be fine.

Yeah you can say that again but then you just have to keep working at it with a little bit of luck and connects who knows.There are few opportunities but certainly not much

I just uploaded a zip files contains some nice documentation on RAC i collated over a long time. You can access it using the link below.

http://www.esnips.com/web/TechnicalDocumentation

Hello,
Can I call u on the Junior DBA offer?

Provide more information. What operating system are you using? and what exactly are you trying to do?

@ azum, i ran the items below and my listener is up but still cant connect to the database.


Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\CCO>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Sat Apr 11 20:07:41 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> $ tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 11-APR-2
009 20:08:12

Copyright (c) 1997, 2006, 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 = Obianwu)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (30 msec)

SQL> $ lsnrctl services

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 11-APR-2009 20:09
:45

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary,
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service,
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "chin" has 1 instance(s).
  Instance "chin", status READY, has 1 handler(s) for this service,
    Handler(s):
      "DEDICATED" established:12 refused:0 state:ready
         LOCAL SERVER
Service "chinXDB" has 1 instance(s).
  Instance "chin", status READY, has 1 handler(s) for this service,
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: OBIANWU, pid: 4168>
         (ADDRESS=(PROTOCOL=tcp)(HOST=Obianwu)(PORT=61650))
Service "chin_XPT" has 1 instance(s).
  Instance "chin", status READY, has 1 handler(s) for this service,
    Handler(s):
      "DEDICATED" established:12 refused:0 state:ready
         LOCAL SERVER
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service,
    Handler(s):
      "DEDICATED" established:139 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service,
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: OBIANWU, pid: 5972>
         (ADDRESS=(PROTOCOL=tcp)(HOST=Obianwu)(PORT=56630))
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service,
    Handler(s):
      "DEDICATED" established:139 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

SQL>

@ azum, Happy Easter--> i checked under services and the dbconsole status is set to"started" and startup type is "automatic". I tried restarting both the oracleDBconsole and Oracleservice orcl, but no luck.

I believe i only have 1 instance named chin, also restarted my laptop and still encountering the same problem. Is it possible to connect to both databases with 1 instance? See below the the output i get when i try to login through EM

Oracle Enterprise Manager
Help

Database Instance: orcl

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
Page Refreshed Apr 11, 2009 9:06:04 PM

Database Instance

Status
Open
Host
Obianwu
Port
1521
SID
orcl
Oracle Home
C:\oracle\product\10.2.0\db_1

Details
The instance is open.

Listener

Status
Up
Host
Obianwu
Port
1521
Name
LISTENER
Oracle Home
C:\oracle\product\10.2.0\db_1
Location
C:\oracle\product\10.2.0\db_1\network\admin

Agent Connection to Instance
Status
Succeeded

Related Links
Recovery Settings
Monitor in Memory Access Mode

Database | Help
Copyright © 1996, 2006, Oracle. All rights reserved.
About Oracle Enterprise Manager 10g Database Control

@azum, see below. I have restarted my laptop and im still not able to connect.

OracleDBConsoleChin Status "Started"
OracleDBConsoleOrcl Status "Started"
OracleJobSchedulerChin Status " "
OracleJobSchedulerOrcl Status " "
OracleOraDb10g_home1iSQL*PLUS Status "Started"
OracleOraDb10g_home1TNSListener Status "Started"
OracleServiceCHIN Status "Started"
OracleServiceORCL Status "Started"

@ azum
(1) They are both on port 1521
(2) I'm trying to open the orcl database
(3) I can connect to chin via sqlplus and when i try orcl in sqlplus i get the error message the account is locked ora-28000
(4) There arent an other oracle services besides what i sent you

@ azum

1521 is the listener port. This is ok since all it implies is you're using one listener to service both databases. However the dbconsoles ports are different. So the first thing you need to do is figure out what your dbconsole port is. There will be two for the dbconsoles you have installed.


If your trying to connect via the command line prompt, then you need to first set your ORACLE_SID to the database you want to connect to. in this case ORCL. you use the following command: C:\> set ORACLE_SID=ORACL
and on the next line issue your sqlplus command.
There is also an Oracle utility that allows you to toggle your ORACLE_SID. This utility will be located in the Oracle folder.
if you trying to connect via the sqlplus utility ensure that your tnsnames file is properly setup.
The above scenerio works if you have a single Oracle Home hosting the multiple database instances you have. But if you have different oracle homes for each instance then you have to set the oracle homes for each instance whenever you want to connect to it.


Like it says your account is locked. The possibilities here are multiple:
a. the account is locked by default - meaning you need to log on to sqlplus as system to unlock that account.
b. the account is locked because it has exceeded the maxmum number of tries as allowed by the default password policy in place. By default after 3 tries with wrong combination of username/password the account gets locked and needs to be unlocked.

By the way provide more information as per the username you're trying to use here.


k.

(1) The port number for orcl is 1158 and the port number for chin is 5500


(2) I tried setting my sid to orcl and orcl , see the results below; also what oracle utility were you refering to in terms of togglng the sid?


Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\CCO>set oracle_sid=chin

C:\Users\CCO>sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Apr 12 14:31:48 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: oe
Enter password:

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

SQL> $ emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://Obianwu:5500/em/console/aboutApplication
Access is denied.
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory C:\oracle\product\10.2.0\db_1/Obianwu_chin/sysma
n/log

SQL>




Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\CCO>set oracle_sid=orcl

C:\Users\CCO>sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Apr 12 14:27:02 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: sysman
Enter password:
ERROR:
ORA-28000: the account is locked





(3) The orcl user name and pass sysman/chin has been locked for a while. I've reset it several times but keep getting the message ora-28000.
      the chin username and pass oe/oracle

Do the following for the two environments:

1. log on to oracle via sqlplus as system. Issue a select command against the dba_users. Paste the output.
2. send me the log file from the sysman/logs directory for both databases.
3. check and ensure that the DBSNMP user is not locked in the 2 databases.

give me your emailaddress and i will send you an email immediately.
Also, this output from sqlplus is that from the database you can not connect to?

Please do the following and paste the output respectively:

1. c:\> set ORACLE_SID=orcl
2. c:\> log on to oracle via sqlplus using system
3. issue the following command:
    select instance_name from v$instance;
4. still in sqlplus issue the following command:
    select username,account_status from dba_users;
5. log out of sqlplus
6 at C:\> prompt issue the following command:
   emctl status dbconsole

Paste the output here.

Then execute the following command too:
1. c:\> set ORACLE_SID=chin
2. Repeat steps 2 to 6.

paste the output here.