@ azum

my email

Yes the out put in sqlplus is for the DB i cant connect (username oe is for chin, username sysman is for orcl)

I have only 1 oracle home

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 /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Apr 13 07:54:44 2009

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

SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW                      OPEN
SYS                            OPEN
SYSTEM                         OPEN
DBSNMP                         OPEN
SYSMAN                         LOCKED(TIMED)
OUTLN                          EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
ORDSYS                         EXPIRED & LOCKED
EXFSYS                         EXPIRED & LOCKED
DMSYS                          EXPIRED & LOCKED
WMSYS                          EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
CTXSYS                         EXPIRED & LOCKED
ANONYMOUS                      EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED
ORDPLUGINS                     EXPIRED & LOCKED
SI_INFORMTN_SCHEMA             EXPIRED & LOCKED
OLAPSYS                        EXPIRED & LOCKED
SCOTT                          EXPIRED & LOCKED
TSMSYS                         EXPIRED & LOCKED
BI                             EXPIRED & LOCKED
PM                             EXPIRED & LOCKED
MDDATA                         EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
IX                             EXPIRED & LOCKED
SH                             EXPIRED & LOCKED
DIP                            EXPIRED & LOCKED
OE                             EXPIRED & LOCKED
HR                             EXPIRED & LOCKED

27 rows selected.

SQL> emctl status dbconsole
SP2-0734: unknown command beginning "emctl stat, " - rest of line ignored.
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:1158/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_orcl/sysma
n/log

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

C:\Users\CCO>set oracle_sid=chin

C:\Users\CCO>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Apr 13 07:58:06 2009

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

SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
chin

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW                      OPEN
SYS                            OPEN
SYSTEM                         OPEN
DBSNMP                         OPEN
MYUSER                         OPEN
ATGCLASS                       OPEN
OE                             OPEN
SYSMAN                         LOCKED(TIMED)
OUTLN                          EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
ORDSYS                         EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
EXFSYS                         EXPIRED & LOCKED
DMSYS                          EXPIRED & LOCKED
WMSYS                          EXPIRED & LOCKED
CTXSYS                         EXPIRED & LOCKED
ANONYMOUS                      EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED
ORDPLUGINS                     EXPIRED & LOCKED
SI_INFORMTN_SCHEMA             EXPIRED & LOCKED
OLAPSYS                        EXPIRED & LOCKED
SCOTT                          EXPIRED & LOCKED
TSMSYS                         EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
BI                             EXPIRED & LOCKED
PM                             EXPIRED & LOCKED
MDDATA                         EXPIRED & LOCKED
IX                             EXPIRED & LOCKED
SH                             EXPIRED & LOCKED
DIP                            EXPIRED & LOCKED
HR                             EXPIRED & LOCKED

29 rows selected.

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>

I have sent you and email. Reply to that email with the log files.
And do remove your email address.

After looking at the log files try the following steps to unlock your SYSMAN account:

1. Stop dbconsole:
$ORACLE_HOME/bin/emctl stop dbconsole

2. check the status of the dbconsole using the following:
C> emctl status dbconsole

3. Unlock the SYSMAN user. Connect in SQLPlus as SYSDBA and run following statement:
ALTER USER SYSMAN ACCOUNT UNLOCK;

4. Check the new password
   SQL> connect sysman/<new_password>[@database_alias]

5. Backup and edit the following file:
$ORACLE_HOME/<hostname_SID>/sysman/config/emoms.properties

6. Locate and change following lines:
oracle.sysman.eml.mntr.emdRepPwd=<encrypted_string>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

to

oracle.sysman.eml.mntr.emdRepPwd=<password_from_repository_unecrypted>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

7. Start db control:
$ORACLE_HOME/bin/emctl start dbconsole

8. check the status of the dbconsole.

9. While still at it check that the password has been encrypted
Edit the file emoms.properties
Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Check that the password is encrypted
Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=
Check that the value is TRUE

While doing this remember that you have 2 dbconsoles running from the same Oracle Home.
My advice is you shutdown both before doing the above steps for each one.

Basically what you're doing here is to unclock the SYSMAN account. Unfortunately just unlocking at the database level alone is not enough.

Let me know if this works for you.

hi all,

What is virtualization in Unix enviroment(solaris to be precise) really about? And where does it meet with the works of a DBA?
Thanks

Hello,

I want to given OCA for Oracle 10g can i get latest dump for the same.
Its very Urgent for me.

Thanks.

hello all, azum, cabali, a-40,jabbok and all the dba's here @ceso, i encountered this same problem last year and i solved it by Gods grace so if you check my earlier posts, you will find the solution, so happy hunting

@azum, Apologies couldnt reply to your post soon enough. Just tried both emctl stop/status dbconsole, and i keep getting the error message "system 5 error has occured, access is denied". After poking around a bit, i figure this is an admin rights issue but i'm logged in as the administrator.

@ jimblaze, i saw your earlier post and its not the same issue with my db.

ceso:

@azum, Apologies couldnt reply to your post soon enough. Just tried both emctl stop/status dbconsole, and i keep getting the error message "system 5 error has occured, access is denied". After poking around a bit, i figure this is an admin rights issue but i'm logged in as the administrator.

Now a few things:

1. Were you able to change the SYSMAN password?
2. Were you able to confirm this by loggin on to sqlplus using SYSMAN and its new password?
3. If the above are true, then send me the logfiles.

@ azum,
im still not able to login as sysman, keeps saying my account is locked. I just found out that oracle 10g is not compatible with windows vista Home premium and im not sure if that has anything to do with the system 5 error i encountered while stopping dbconsole and also the loss of connection to my database. I find it strange that i was able to download 10g on vista home premium inspite of the compatibility issue.

@Ceso,

Yes u r right. There is a special version of Oracle 10g for Vista,

ceso:

@ azum,
im still not able to login as sysman, keeps saying my account is locked. I just found out that oracle 10g is not compatible with windows vista Home premium and im not sure if that has anything to do with the system 5 error i encountered while stopping dbconsole and also the loss of connection to my database. I find it strange that i was able to download 10g on vista home premium inspite of the compatibility issue.

Who told you Oracle 10g is not compatible to Windows Vista. It is and you can quote me on this.
Also, unlocking sysman account is not easy. That's why i took the pains to set out the steps above. Follow through those steps and you will be able to unlock the sysman account. Did you try the steps?

@azum,
I have some difficulty login into my EM on Windows enviroment. I cant remember where I have seen d solution on d net b4.
the error message:

Error Message



RemoteOperationException: ERROR: Wrong password for user
.

I have used the correct OS n target DB username and password. But it wont login!Pls help

@azum, yes i followed the steps you outlined but could not get past No.4. because i keep getting the message error 28000 account is locked. My guess is the password im entering is incorrect and i dont know how else to change it; tried using alter user identified by password and also forcing the password to change when logging in but no luck: see details below

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 Mon Apr 20 20:29:49 2009

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

SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> alter user sysman identified by oracle;

User altered.

SQL> connect sysman/oracle
ERROR:
ORA-28000: the account is locked


Warning: You are no longer connected to ORACLE.
SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> alter user sysman password expire;

User altered.

SQL> connect sysman
Enter password:
ERROR:
ORA-28000: the account is locked


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

@jabbok, see if this helps http://weblogs.asp.net/wallym/archive/2005/01/03/345818.aspx

I just reread the thread and i see my steps have already been suggested

ceso:

@azum, yes i followed the steps you outlined but could not get past No.4. because i keep getting the message error 28000 account is locked. My guess is the password im entering is incorrect and i dont know how else to change it; tried using alter user identified by password and also forcing the password to change when logging in but no luck: see details below

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 Mon Apr 20 20:29:49 2009


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

SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> alter user sysman identified by oracle;

User altered.

SQL> connect sysman/oracle
ERROR:
ORA-28000: the account is locked


Warning: You are no longer connected to ORACLE.
SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> alter user sysman password expire;

User altered.

SQL> connect sysman
Enter password:
ERROR:
ORA-28000: the account is locked


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

@Ceso, thanks for the link. To overcome your error, u need to add an additional command to ur earlier alter command. the command should be as thus:

SQL> alter user sysman identified by oracle
         account unlock;

I assume you are aware that u must connect as d SYSDBA b4 u can issue the command effectively. U can log on as sysman afterwards.It should work.

Ceso:

If you really need to solve this problem then follow the steps below in full. Dont stop halfway.

After looking at the log files try the following steps to unlock your SYSMAN account:

1. Stop dbconsole:
$ORACLE_HOME/bin/emctl stop dbconsole

2. check the status of the dbconsole using the following:
C> emctl status dbconsole

3. Unlock the SYSMAN user. Connect in SQLPlus as SYSDBA and run following statement:
ALTER USER SYSMAN ACCOUNT UNLOCK;

4. Backup and edit the following file:
$ORACLE_HOME/<hostname_SID>/sysman/config/emoms.properties

6. Locate and change following lines:
oracle.sysman.eml.mntr.emdRepPwd=<encrypted_string>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

to

oracle.sysman.eml.mntr.emdRepPwd=<password_from_repository_unecrypted>
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

7. Check the new password
SQL> connect sysman/<new_password>[@database_alias]

8. Start db control:
$ORACLE_HOME/bin/emctl start dbconsole

9. check the status of the dbconsole.

10. While still at it check that the password has been encrypted
   Edit the file emoms.properties
   Search for the line beginning with:
   oracle.sysman.eml.mntr.emdRepPwd=
   Check that the password is encrypted
   Search for the line beginning with:
   oracle.sysman.eml.mntr.emdRepPwdEncrypted=
   Check that the value is TRUE

I have slightly changed the sequence. Check it out and let me know
If this does not work i might try to recreate the problem and see what is happening so as to get a solution.

@ jabbok, thanks for the info.

@ azum, I followed the steps but no luck, my guess is that it has something to do with admin rights as all attributes in the oracle folder are set to readonly. As soon as i uncheck readonly and close properties, the attributes automatically goes back to readonly. Anyway thanks for all your effort; i will delete and re-install enterprise manager.

ceso:

@ azum, I followed the steps but no luck, my guess is that it has something to do with admin rights as all attributes in the oracle folder are set to readonly. As soon as i uncheck readonly and close properties, the attributes automatically goes back to readonly. Anyway thanks for all your effort; i will delete and re-install enterprise manager.

If that's what you want to do, i believe somewhere in these threads i stated the steps to take to do a clean uninstall on windows.
Good luck.

to change your sysman password and to also unlock it also issue this command

alter user sysman identified by orac account unlock;

This will rectify your problem.

Cheers

oracle works on vista.there is an installation for xp ,vista and unix.you installed the wrong oracle software

hello guys, does anyone know how if oracle 11g client has a GUI?and how do you use it

hello!@ all dbas, pls i need to learn how to install on linux. been using windows and i see its easy with theDBCA. pls can anyone help me out, installing oracle on linux plssssssssssssss

go to this website
Oracle-on-Linux Installation Guides
This installation content is a collection of guides and tips that worked best in the Linux Discussion Forums and Installfests. (Warning: Not everything here may be fit for consumption on your
http://www.oracle.com/technology/tech/linux/install/index.html - 73k

hello guys were are all of you?lemoor, a40, cabali, wats happening? i installed oracle 11g db on a coworkers pc and i installed oracle 11g client on my pc and i have been trying to use the client to connect but not possible, i keep getting ORA-12154: TNS:could not resolve the connect identifier specified and ORA-12154: TNS:could not resolve the connect identifier specified so, solutions

@jimblaze, thanks for the help man. i appreciate it

jimblaze:

hello guys were are all of you?lemoor, a40, cabali, wats happening? i installed oracle 11g db on a coworkers pc and i installed oracle 11g client on my pc and i have been trying to use the client to connect but not possible, i keep getting ORA-12154: TNS:could not resolve the connect identifier specified and ORA-12154: TNS:could not resolve the connect identifier specified so, solutions

You must have TNSNAMES.ora file configured on the client.
Make sure it is properly configured.

Visit this link for good explanation

http://media.datadirect.com/download/docs/jdbc/alljdbc/reference/wwhelp/wwhimpl/common/html/wwhelp.htm?context=Reference&file=jdbcoracle8.html


Tnsnames file is usually located at the path

C:\Oracle\product\ NETWORK \ADMIN folder
Note: Location depends on your installation path

If you already have a tns file and you can ping the connection
Let’s assume this is y tnsnames file

FITZGERALD.SALES =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(CONNECT_DATA =
(SID = ORCL)
)
)
ARMSTRONG.ACCT =
(DESCRIPTION =
(ADDRESS_LIST=
(FAILOVER = on)
(LOAD_BALANCE = on)
(ADDRESS= (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = server3)(PORT = 1521))
)
(CONNECT_DATA=
(SERVICE_NAME = acct.us.yourcompany.com)
(FAILOVER_MODE =
(BACKUP=server2)
(TYPE=select)
(METHOD=preconnect)
(RETRIES=20)
(DELAY=3)
)
)

to ping the server, I ould
1) Open a command window on your machine and try to do a “tnsping” on the server from that file.

tnsping ARMSTRONG.ACCT

well i tnsping and it says TNS-12535: TNS:operation timed out and my sqlnet.ora file on both the server and client is this-# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)


this is not good right :

I don't understand the question or what you posted. This is a sample sqlnet.ora file


# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

#NAMES.DEFAULT_DOMAIN = world

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= TNSNAMES

#TRACE_LEVEL_CLIENT=16


check out this link for more info

http://www.orafaq.com/wiki/Sqlnet.ora


This link points to possible solution for the problem you are having there


tns-12535 tns operation timed out http://www.orafaq.com/forum/t/49404/0/