problem with new database [message #264033] |
Fri, 31 August 2007 09:45 |
marcosbr
Messages: 24 Registered: April 2007 Location: Argentina
|
Junior Member |
|
|
Hi Guys:
I’m doing my first steps in Oracle 10g and first steps to the next certification also.
I’ve a little problem at moment to create a new database.
I’m working with Windows 2003 and Oracle 10g 10.2.0
The specific problem happened when I did create the second database, then I’ve 2 questions:
1- why it don’t create in the windows program menu another menu “Database control – my new database”
2 – The listener is not working…now…and it seem like no database is registered.
- After that I’ve uninstalled and installed the database again and now with just one database my listener is still crazy.
- The Listener is hire:
# 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 = optimus)(PORT = 1521))
)
)
It give two errors:
Database Error
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=optimus)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=base1)))
And in the enterprise manager says:
Agent Connection to Instance
Status
Failed
Details
ORA-12505: TNS:el listener no conoce actualmente el SID proporcionado en el descriptor de conexión (DBD ERROR: OCIServerAttach)
I guess it is too easy to some of you.
Thanks a lot for the help
Marcos
|
|
|
Re: problem with new database [message #264064 is a reply to message #264033] |
Fri, 31 August 2007 10:46 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = optimus)(PORT = 1521))
)
)
wheres your service or sid name?
Try it
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 8192)
(TDU = 8192)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SDU = 8192)
(TDU = 8192)
(GLOBAL_DBNAME = MYDB.xyz.com)
(SID_NAME = MYDB)
(ORACLE_HOME = /opt/oracle/10.2.0)
)
|
|
|
Re: problem with new database [message #264069 is a reply to message #264064] |
Fri, 31 August 2007 11:01 |
marcosbr
Messages: 24 Registered: April 2007 Location: Argentina
|
Junior Member |
|
|
Exactly, it was I saw, no database name inside, I’ don’t know so much for that reason I’m asking..
I’ don’t know how to fix the listener parameter, I’m giving my first steps learning to administer the Oracle 10g.
I’ll try it and tell you what happened.
But you know why my database were desconfigured after create the second database?
Thanks a lot!
Marcos
|
|
|
|
Re: problem with new database [message #264095 is a reply to message #264033] |
Fri, 31 August 2007 14:08 |
marcosbr
Messages: 24 Registered: April 2007 Location: Argentina
|
Junior Member |
|
|
Thanks a lot, I understand your point.
But I would like to take a little bit more information, I mean:
I’m using windows, and of course we are at 2007 year and Oracle is maybe the more advanced Database in the world, is possible that using DBCA wizard it don’t create for you the listener input with the information of the new database that your are creating?
As I said, I doing my first steps in Oracle 10g and In the chapter 3 of my book “Oracle database 10g administration Workshop I” just say that you have to use DBCA wizard in order to create your first database and that’s all.
And at moment, I’m don’t know how to configure Oracle Net services, and TNS Listeners because it is some chapters ahead (of course it is not problem to jump and read the needed information!).
Then I’ don’t know why, using DBCA wizard I’ve to modify manually the Listener?
It’s very important to know because I’m doing exactly all that the book suggest me, then I Don’t know, I’m not advanced administrator at moment.
I’m explaining of this way, not for fight with anybody, I just want to obtain more information if possible of course.
Thanks a lot again.
Marcos
And sorry for my bad English
|
|
|
Re: problem with new database [message #264108 is a reply to message #264095] |
Fri, 31 August 2007 16:46 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
Quote: |
Then I’ don’t know why, using DBCA wizard I’ve to modify manually the Listener?
|
DBCA use for create/delete/manage/template,not update your listener.ora.
Quote: | And at moment, I’m don’t know how to configure Oracle Net services, and TNS Listeners because it is some chapters ahead (of course it is not problem to jump and read the needed information!).
|
Use Net configuration assitant (netca) or netmgr for LISTENER & SERVICENAMING.
|
|
|