Hi, This is the only pic i took. The vehicle is in lagos as we speak. feel free to call me and have a look. I promise you wont be disappointed

available price is negotiable for the right buyer

available

available

still available

Ok Thanks Hakir, i will get intouch with you by phone to discuss.

@Kharis, Good job on your transparency. I intend to invest in real estate in abj and was wondering if you can educate me on the areas.

@hakir, what can i expect to pay for land cos  I would much rather buy land to build a detached duplex in the lokongoma area ? also is lokongoma a good area to buy land?

Does anyone know what the prices are for a completed 4bedroom detached duplex and also detached duplex land at sahara homes lokogoma district phase III FCT?

@ 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.

@ jabbok, thanks for the info.

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

@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>

@ 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.

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

@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.

@ 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>

@azum, i appreciate you taking the time to help me with this issue. As for number (2), let me know were you want me to send the files cos they are > 200kb which is the MIN size attachement.

(1)

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 13 05:00:04 2009

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

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

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>

(2) pls see attached log files
(3) i believe this is related to number 1 (dbsnmp -> status-->open) if not let me know.

@ azum, sorry on No (2) i meant i tried setting my sid to orcl for the orcl DB, and chin for the chin DB

(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

@ azum, Not sure what happened but i'm not able to connect to the chin db through EM

@ 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, 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"

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, 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.

@ 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>

Thanks for the quick response azum. I downloaded oracle 10g database on my laptop (OS windows vista) and for a while i was able to login and then all of a sudden i cant connect to my database anymore. When i try to login i get the message"enterprise manager is not able to connect to the database instance"; i can see that my database instance is open and my listener is up however the agent connection to instance failed(ORA-12505). I have tried to define the SID but no luck. Anyway I ended up creating another DB but i still want to find out why i lost connection on the first database.

@azum: came across this site while searching for solutions on how to connect to my db. I have a similar problem as jabbock however i'm still getting the message that my oracle_sid is not defined. I restarted oracledbconsole, oracle tns listener and oracle services, but no luck. Any ideas on how i can fix this ?