|
ceso
|
@ 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/aboutApplicationAccess 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/aboutApplicationAccess 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> |
|
|
|
|
|
azum
|
I have sent you and email. Reply to that email with the log files.
And do remove your email address.
|
|
|
|
|
|
azum
|
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. |
|
|
|
|
|
jabbok (m)
|
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
|
|
|
|
|
|
suntoson (m)
|
Hello, I want to given OCA for Oracle 10g can i get latest dump for the same. Its very Urgent for me. Thanks.  |
|
|
|
|
|
jimblaze (m)
|
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  |
|
|
|
|
|
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.
|
|
|
|
|
|
ceso
|
@ jimblaze, i saw your earlier post and its not the same issue with my db.
|
|
|
|
|
|
azum
|
@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. |
|
|
|
|
|
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.
|
|
|
|
|
|
jabbok (m)
|
@Ceso,
Yes u r right. There is a special version of Oracle 10g for Vista,
|
|
|
|
|
|
azum
|
@ 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? |
|
|
|
|
|
jabbok (m)
|
@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
|
|
|
|
|
|
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>
|
|
|
|
|
|
|
|
Le Moor (m)
|
I just reread the thread and i see my steps have already been suggested
|
|
|
|
|
|
jabbok (m)
|
@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 your 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. |
|
|
|
|
|
azum
|
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. |
|
|
|
|
|
ceso
|
@ jabbok, thanks for the info.
|
|
|
|
|
|
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.
|
|
|
|
|
|
azum
|
@ 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. |
|
|
|
|
|
mssiah (m)
|
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
|
|
|
|
|
|
mssiah (m)
|
oracle works on vista.there is an installation for xp ,vista and unix.you installed the wrong oracle software
|
|
|
|
|
|
jimblaze (m)
|
hello guys, does anyone know how if oracle 11g client has a GUI?and how do you use it |
|
|
|
|
|
vikkieb
|
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  |
|
|
|
|
|
jimblaze (m)
|
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 |
|
|
|
|
|
jimblaze (m)
|
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 |
|
|
|
|
|
vikkieb
|
@jimblaze, thanks for the help man. i appreciate it
|
|
|
|
|
|
azum
|
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. |
|
|
|
|
|
Kobojunkie
|
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
|
|
|
|
|
|
jimblaze (m)
|
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 :  |
|
|
|
|
|
Kobojunkie
|
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=16check out this link for more info http://www.orafaq.com/wiki/Sqlnet.oraThis 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/ |
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
