Sample Header Ad - 728x90

sqlplus / as sysdba Connected to an idle instance

0 votes
1 answer
1758 views
anyone can Me help uderstand what is happends? i have oraenv corectly, use su oracle to change user, use this command to conncet as sysdba - sqlplus / as sysdba answer is: SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 4 16:33:30 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to an idle instance. i try SQL> STARTUP; answer: > ORA-01078: failure in processing system parameters LRM-00109: could > not open parameter file > '/oracle/impuls/19c/db_home1/dbs/initIMPDBP.ora' but when I use this command sqlplus sys@pdbname as sysdba paste password and answer is ok, database working, bud i don't anderstand what is happends lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-MAR-2024 16:42:39 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=amvmor1.andoria.net)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 26-JAN-2024 19:40:33 Uptime 37 days 21 hr. 2 min. 5 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/impuls/19c/db_home1/network/admin/listener.ora Listener Log File /oracle/diag/tnslsnr/amvmor1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amvmor1.andoria.net)(PORT=1521))) Services Summary... Service "02dd7d33e92ebc5fe0631801000a2bb3" has 1 instance(s). Instance "impdbt", status READY, has 1 handler(s) for this service... Service "bpsc" has 2 instance(s). Instance "bpsc", status UNKNOWN, has 1 handler(s) for this service... Instance "impdbp", status READY, has 1 handler(s) for this service... Service "e81af78f0d129774e0531801000a28a1" has 1 instance(s). Instance "impdbt", status READY, has 1 handler(s) for this service... Service "e81bb4c3318fb858e0531801000abe14" has 1 instance(s). Instance "impdbp", status READY, has 1 handler(s) for this service... Service "e81c4e8d6234d523e0531801000a4126" has 1 instance(s). Instance "impdbp", status READY, has 1 handler(s) for this service... Service "impdbp" has 1 instance(s). Instance "impdbp", status READY, has 1 handler(s) for this service... Service "impdbpXDB" has 1 instance(s). Instance "impdbp", status READY, has 1 handler(s) for this service... Service "impdbt" has 1 instance(s). Instance "impdbt", status READY, has 1 handler(s) for this service... Service "impdbtXDB" has 1 instance(s). Instance "impdbt", status READY, has 1 handler(s) for this service... Service "test" has 2 instance(s). Instance "impdbt", status READY, has 1 handler(s) for this service... Instance "test", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
Asked by Tomasz Myszak (29 rep)
Mar 4, 2024, 03:41 PM
Last activity: Mar 5, 2024, 03:22 AM