Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
How I configure DBCA (10g) to work around ORA-12162?

How I configure DBCA (10g) to work around ORA-12162?

2005-03-02       - By Ir Forex

Reply:     1     2  

Hi,

I want to use dbca to install OEM Database Control on my
10.1.0.3.0 DB.

I should not need to configure dbca;
it should be smart enough to detect my DB and
connect to it.

How do I configure dbca?

Currently I do this on my linux box:

Use sqlplus to verify the DB is up and that
my env vars are okay.

I verify that the listener and TNS is working via:

sqlplus system/howdy@(protected)

Then, I type
dbca&

It appears in my X display.

I click next

I click 'configure database options'

It then shows the name of the DB which is 'dev'.

I'm not sure where it gets the string.

I know, via experiment, that it is NOT getting it from ORACLE_SID.

'dev', however is the name of my DB so I click next.

I click
'configure the database with enterprise manager'
I check
'use database control for database management'

I click next

I click past the 'database components' screen.

I enter passwds in the password screen and then I click next.

In the next screen I pick 'dedicated server' mode.

then I click 'finish'.

It tries to connect to the db and the listener refuses
the connection.

The error window:
ORA-12162 (See ORA-12162.ora-code.com): TNS:net service name is incorrectly specified.

So back to my question,
I use dbca to configure the DB,
but how do I configure dbca??

Some kind of special env variable?
A string in a file somewhere?

I want to avoid fiddling with netservices,
they seem to work okay with sqlplus and other tools
which connect via TNS.

-moi




 
   
__ ____ ____ ____ ____ ____ ______
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
--
http://www.freelists.org/webpage/oracle-l